TallyERP9 Tutorial Part-23: Price Levels & Price List

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.

Tally.ERP9 Book (Advanced Usage) @ Rs.550
Tally.ERP9 Book (Advanced Usage) @ Rs.550

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:

Price Levels and Price List  in TallyERP9
Price Levels and Price List in TallyERP9

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 :

Price Levels and Price List  in TallyERP9
Price Levels and Price List in TallyERP9

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.

Price Levels and Price List  in TallyERP9
Price Levels and Price List in TallyERP9

2. Price List in Tally.ERP9

Once you have created Price Levels , the Price List option appears in the Inventory Info. menu.

Price Levels and Price List  in TallyERP9
Price Levels and Price List in TallyERP9

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. OnwardsRs. 3500 ( Disc. 5%)
2.Keyboard – Logitech  
  Upto      5 Nos.Rs. 1400
  From 5 Nos. to   10 Nos.Rs. 1200
  From     10 Nos. OnwardsRs. 1000 ( Disc. 10%)
3.Mouse – Logitech  
  Upto      5 Nos.Rs. 500
  From 5 Nos. to   10 Nos.Rs. 450
  From     10 Nos. OnwardsRs. 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 .

Price Levels and Price List  in TallyERP9
Price Levels and Price List in TallyERP9

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 .

Price Levels and Price List  in TallyERP9

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:

Price Levels and Price List  in TallyERP9
Price Levels and Price List in TallyERP9

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.

  1. Press Enter to Save.

The Sale Invoice screen appears as shown below:

Price Levels and Price List  in TallyERP9
Price Levels and Price List in TallyERP9

Leave a Comment

Your email address will not be published.

error: Content is protected !!