Price Lists & Price Levels in Tally.ERP 9 | Tally Solutions

Price Lists and Price Levels in Tally

  • 1. What’s is meant by price level in world of business ?
  • 2. About Price list feature in Tally.ERP 9
  • 3. How to set selling price in Tally.ERP 9 ?
  • 4. How to modify price list in Tally.ERP 9 ?
  • 5. How to import price list in Tally.ERP 9 from Excel file ?
  • 6. How to print price list in Tally.ERP 9 ?

1. What’s is meant by price level in world of business ?

There are two meanings of the term price level in the world of business. One meaning refers to the price of assets traded on the market. The other meaning refers to the price of goods and services and is used in reference to inflation.

Mainly in business it refers to the decision to change prices based on daily market conditions or trends. To put it in simpler terms, say two companies who change prices on the same products by the same amount may get widely different results depending on how they implement the new policy.

Raising and lowering prices effectively involves careful attention to timing. It requires knowing how to affect your customers' perception of the value inherent in what you are selling. It forces you to study and accurately predict reactions from your competitors.

It is this need which business asks the business men to journalize in books of accounts for all future references and to know the changing trends in the product line. ERP systems are the best to record these transactions to be made useful at time of creation of invoices or quoting or pitching a sales order to a client.

2. About Price list feature in Tally.ERP 9

This is a set of predefined multiple levels where we can set prices for the product and can select the appropriate price list whenever a sale transaction is passed in Tally.ERP 9. For e.g. one can define price lists for Distributors, Dealers and Retailers.

While defining the price lists Tally.ERP 9 displays the cost price as well as last price (historical data) for that particular stock item. This simplifies and expedites invoicing and also eliminates the possibilities of errors at the time of Invoice entry.

3. How to set selling price in Tally.ERP 9 ?

How to define price levels in Tally :  To define price level in Tally. ERP 9 is an easy task as one can set these multiple price levels in the ledger creation screen itself. The simplest rule is to select the stock item and enter the quantity in sales voucher creation screen  and let Tally do the work of prefilling the price automatically based on the levels defined.

Route : To set price levels in Tally :

Starting Point : Gateway of Tally
Choose Destination : F11 : Inventory Features >  
What to do on reaching the destination point Set Use Multiple Price Levels to Yes by selecting a category suitable for transaction
  • Dealer
  • Retailers
  • Distributors
  • wholesale
Route : To set price list in Tally :
Starting Point : Gateway of Tally
Choose Destination : Inventory Info. > Price list >
What to do on reaching the destination point :
  • Select any Group or All Items
  • Specify rates for all items/group (Note : We can specify different rates for different quantities of the same item discount %)

4. How to modify price list in Tally.ERP 9 ?

To alter price list in Tally
Step 1 : Follow the given direction : Gateway of Tally > F11 : Features > F2 : Inventory Features screen.
Step 2 : Tab down to Use Multiple Price Levels field and press Enter to go to Company Price Levels screen.
Step 3 : The same procedure as discussed in Creating Price Levels, needs to be followed to alter the name of a price level. We can simply overwrite the names specified previously and save the changes.

5. How to import price list in Tally.ERP 9 from Excel file ?

From Gateway of Tally march towards Price List Import Screen and in the next screen you will be asked to select and fill the following.

  • Price list source From : Select Excel Format here
  • Location of the file. : Select the location of file saved on your computer
  • Give a file name say Price List (for convenience)
  • Give a table/ sheet name and enable the following tiles to use price list feature by labelling them like Item Name/ Applicable date/ Price level/ From quantity/ To quantity/ Rate and Discount
  • Finally enter Yes and Export the price list

6. How to print price list in Tally.ERP 9 ?

Step 1 Create a price list using the method listed above
Step 2 : Go to Gateway of Tally >  Inventory Info > Price List
Step 3 : Select stock group of product which has to be printed
Step 4 : Now select the Price Level already created.
Step 5 : Finally Press enter to get the price list.
Step 6 : Click on Print button or Click Alt + P
Step 7 : Click on Yes and the Price list get printed.


GST Software Free Trial
 
Thank You !