Price Lists — Multiple Pricing for Different Customers
Creating retail, wholesale, and distributor price levels for Sunrise Retail's products — auto-fill pricing by customer
Module 18 of 31 — Tally Prime. Multiple price levels — configure once, auto-fill in every sales voucher by customer type. Duration: 35 min.
Prerequisites: Module 14 — Stock Items
Learning Objectives
- Enable price lists in Tally Prime via F11
- Create price levels (Retail, Wholesale, Distributor) and set rates per stock item
- Assign price levels to customer ledgers
- See how prices auto-fill in sales vouchers — no manual lookup needed
Enable Price Lists
Once enabled, two new options appear in Inventory Masters: Price Levels and Price Lists.
Step 1: Create Price Levels
Price levels are the tier names — not the prices themselves. Create them first.
Create all four price levels:
Step 2: Create Price Lists (Rates per Item per Level)
Now set the actual prices for each stock item at each price level.
Samsung Phone (Model X):
Samsung Galaxy A55:
iPhone 16 128GB:
Dell Inspiron 15:
iPad Air (WiFi):
USB-C Charger 45W:
Sunrise Retail — Complete Pricing Table
| Product | Retail | Wholesale | Distributor | Corporate |
|---|---|---|---|---|
| Samsung Phone (X) | ₹17,000 | ₹16,000 | ₹15,000 | ₹15,500 |
| Samsung Galaxy A55 | ₹28,000 | ₹26,000 | ₹24,500 | ₹25,000 |
| iPhone 16 128GB | ₹85,000 | ₹82,000 | ₹79,000 | ₹80,000 |
| Dell Inspiron 15 | ₹58,000 | ₹54,000 | ₹50,000 | ₹52,000 |
| iPad Air (WiFi) | ₹75,000 | ₹72,000 | ₹69,000 | ₹70,000 |
| USB-C Charger | ₹1,800 | ₹1,500 | ₹1,300 | ₹1,400 |
Step 3: Assign Price Level to Customer Ledger
This is the key step — assign once, and Tally auto-fills the correct price every time.
Walk-in / retail customers: no price level assigned → Tally defaults to Retail.
Customer → Price Level Mapping
| Customer | Location | Price Level | Phone Price |
|---|---|---|---|
| Walk-in buyers | Madhapur showroom | Retail | ₹17,000 |
| Digital Hub Retail | Secunderabad | Wholesale | ₹16,000 |
| CloudStore Online | Bangalore | Distributor | ₹15,000 |
| TechStart Solutions | Hyderabad | Corporate | ₹15,500 |
| Prism Computers | Hyderabad | Wholesale | ₹16,000 |
| Global Academy | Hyderabad | Retail | ₹17,000 |
Auto-Fill in Action
When Kiran creates a sales invoice for Digital Hub Retail, the Wholesale price auto-fills:
No need to remember Digital Hub's price — Tally fills it from the price list. The rate can still be overridden manually if needed (e.g., special one-time offer).
When selling to a walk-in customer (no price level set):
Price List Effective Dates
You can set different prices for different periods:
Tally automatically uses the rate effective on the invoice date. No manual update needed — just add a new row in the price list with the new effective date.
Practice Exercise
Exercise: Create a "Government" price level for Sunrise Retail at 10% below Retail prices for all items (government tenders). Assign it to "District Collectorate Office, Hyderabad" (new customer). Show how the price auto-fills for Dell Inspiron 15.
Show Solution
Step 1: Create Price Level:
Step 2: Add to Price List — Dell Inspiron 15:
Step 3: Create Customer Ledger:
Step 4: Sales Voucher:
Key Terms
| Term | Meaning |
|---|---|
| Price Level | A named pricing tier — Retail, Wholesale, Distributor, Corporate |
| Price List | The rate table — which item, which level, which price, from which date |
| Auto-fill | Tally fills the rate in F8 (Sales) based on the customer's assigned price level |
| Price Level in Ledger | The tier assigned to a customer — determines which price list they get |
| Effective Date | The date from which a price applies — allows time-based pricing |
Module Summary
- Enable price lists:
F11 → Inventory → Maintain Multiple Price Levels: Yes - Create price levels first (tier names) → then create price lists (actual rates per item per level)
- Assign price level in customer ledger master — this is the one-time setup per customer
- Sales vouchers auto-fill rate from price list — eliminates pricing errors and manual lookups
- Sunrise Retail: Digital Hub = Wholesale (₹16,000/phone), CloudStore = Distributor (₹15,000/phone), walk-in = Retail (₹17,000/phone)
- Effective dates allow price list updates for future periods — old invoices keep old prices
Checklist before moving on:
- F11 → Maintain Multiple Price Levels: Yes
- Four price levels created: Retail, Wholesale, Distributor, Corporate
- Price list created for Samsung Phone (X) at all four levels
- Digital Hub ledger: Price Level = Wholesale
- CloudStore ledger: Price Level = Distributor
- Test: create F8 for Digital Hub → Samsung Phone rate = ₹16,000 auto-fills
Quick Quiz
1. To enable multiple price lists in Tally Prime, activate:
- a) Use Multiple Godowns
- b) Maintain Multiple Price Levels
- c) Enable Order Processing
- d) Activate Interest Calculation
Answer
b) Maintain Multiple Price Levels — in F11 → Inventory Features. This is the switch that enables price levels, price lists, and ledger-level price assignment.
2. CloudStore is assigned "Distributor" price level. When selling Samsung Phone (Distributor rate ₹15,000), the Tally sales voucher auto-fills rate as:
- a) ₹16,000 (Wholesale)
- b) ₹17,000 (Retail)
- c) ₹15,000 (Distributor)
- d) ₹12,000 (Cost price)
Answer
c) ₹15,000 — Tally reads the price level from CloudStore's ledger master (Distributor) and auto-fills ₹15,000 from the Distributor price list for that item.
3. Two different dates are set for the Samsung Phone Wholesale price: ₹16,000 from April 1 and ₹15,500 from July 1. An invoice dated June 15 will auto-fill:
- a) ₹15,500 (latest price)
- b) ₹16,000 (April price, still effective on June 15)
- c) Average of both
- d) ₹12,000 (cost price)
Answer
b) ₹16,000 — Tally uses the price effective on the invoice date. June 15 falls within the April 1–June 30 period, so the April rate applies. The July price is effective from July 1 onwards.