1. Price Levels in Tally.ERP9
In Tally.ERP 9, you can create different Price Levels and assign different Price Lists to these Price Levels. For example, you can create Wholesaler, Corporate and Retail as Price Levels and assign applicable Price Lists to these Price levels, as per your requirements, so that only the relevant prices and discount rates are used during entry of orders and invoices.
Before you start creating Price Lists, you may decide to create Price Levels as required.
1.1. Create Price Levels
Multiple price levels can be created and different price list can be assigned to these price levels.
1. Go to Gateway of Tally > F11: Features > F2: Inventory .
The Company Operations Alteration screen appears.
2. Set Use multiple price levels to Yes . The Company Price Levels screen appears as shown below:
3. Enter the Company Price Levels names.
4. Press Ctrl+A to accept and return to the inventory features screen.
1.2. Assign Price Levels to Ledger Accounts
On creating price levels, you can make price levels applicable for ledgers grouped under Sundry Debtors and Sundry Creditors.
Example :
Already we have & created our Sundry Debtor Groups into Corporate Customer, Local Customer, Wholesale Customer.
Now you can link …
>> all Ledgers under Corporate Customer to Corporate Price Level
>> all Ledgers under Wholesale Customer to Wholesale Price Level
>> all Ledgers under Local Customer to Retail Price Level
Go to Gateway of Tally > Accounting Info. > Ledgers > Alter ( Single) > Adarsh Tiles Pvt. Ltd.
Select the Price Level i.e. Corporate as shown in screen below :
If you select the price list in the ledger, you need not select it again while passing an invoice. This will make the process of Invoice entry faster.
Note: For a Ledger, you can only assign only one Price Level at a time, however you can change the Price Level selection depending upon your requirement in alteration mode or during voucher entry.
Once Price Level assigned to Ledger accounts, the stock item prices are automatically displayed in a transaction which minimizes errors during Invoicing (Sale voucher) as shown below.
2. Price List in Tally.ERP9
Once you have created Price Levels , the Price List option appears in the Inventory Info. menu.
Tally.ERP 9 assists in creating quantity based pricing with complex discount structure. Price Lists are available only for inventory items and hence the feature is available only if inventory and invoicing are activated for the company.
You may require more than one price list, when you have different price structures/levels for different purposes viz., different groups of customers requiring different discounts or dealing in different products.
You can create a price list for a items falling under a group.
Example:
Create the following Price Lists with different Price Level :
Price Level : Corporate
Stock Group : Accessories
Price Lists of Following Stock Items :
| 1. | Cabinet | ||
| Upto 5 Nos. | Rs. 4000 | ||
| From 5 Nos. to 10 Nos. | Rs. 3800 | ||
| From 10 Nos. Onwards | Rs. 3500 ( Disc. 5%) | ||
| 2. | Keyboard – Logitech | ||
| Upto 5 Nos. | Rs. 1400 | ||
| From 5 Nos. to 10 Nos. | Rs. 1200 | ||
| From 10 Nos. Onwards | Rs. 1000 ( Disc. 10%) | ||
| 3. | Mouse – Logitech | ||
| Upto 5 Nos. | Rs. 500 | ||
| From 5 Nos. to 10 Nos. | Rs. 450 | ||
| From 10 Nos. Onwards | Rs. 400 |
Solutions:
1. Go to Gateway of Tally > Inventory Info. > Price List .
2. Select a Stock Group Name from the List of Stock Groups .
3. Select the Price Level .
Note: To view all the Stock Items under the selected Price Level, click F12: Configure and set the option Show all Items for Price Level to Yes .
4. Select the item.
5. Enter the range of quantity for which the price level is applicable in the fields From and Less than to create a quantity based staggered pricing.
Note: If you don’t require quantity based staggered pricing, press Enter to skip the fields From and Less than .
6. Enter the Rate .
7. Enter the Disc % .
Note: The field Disc% is available only if the option Separate Discount Column on Invoices is enabled in the F11: Features (Inventory Features) .
8. Press Enter .
The Price List screen appears as shown below:
Note: You can alter a price list by overwriting the details entered in the Price List screen.
3. Use Price Levels & Price List during Voucher Entry
Once price levels are created and assigned to ledger accounts, the stock item prices are automatically displayed in a transaction. The automation minimizes errors during invoicing.
Example:
Sold the following items to Adarsh Tiles Pvt. Ltd. as per Corporate Price Level & Price List (already created in earlier example)
Cabinet 15 Nos.
Keyboard – Logitech 12 Nos.
Mouse – Logitech 4 Nos.
Solutions:
1. Go to Gateway of Tally > Accounting Vouchers > F8: Sales .
2. Select the customer ledger in the field Party’s A/c Name i.e. Adarsh Tiles Pvt. Ltd..
Note : Price level i.e. Corporate selected by default which already linked in the above paragraph.
3. Select the Items with Quantity as per example, Here Rate , Disc. & Amount Column will skip which you can not edit.
- Press Enter to Save.
The Sale Invoice screen appears as shown below:
