Connect with ...

8. Price Levels and Price Lists in Tally.ERP9

A Price List refers to a list of items maintained by an organisation along with their price details. A price list is generally used by organisations which deal in multiple products. Price Lists are main- tained in various structures for different types of buyers (customers), viz., Wholesalers, Dealers, Retailers, etc. The price list is structured based on the classification of buyers and is referred to at the time of making sales. Whenever the sale prices change (on the basis of time), the changes reflect in the Price List also. In case of bulk sales, discounts can also be given to the buyers.

 

Let us now see how Tally.ERP 9 handles such a situation through the Price List feature.
 

8.1. Activating Price Lists and Defining Price Levels

Setup:

 

Go to Gateway of Tally > F11: Features (Inventory Features)

 

       Set Use Multiple Price Levels for Invoicing to Yes. (This will appear only if the feature Allow Invoicing is set to Ye.)

        Tally.ERP 9 takes you to the Company Price Levels screen, type different price levels for National Traders as

            „         Retail Sales

„          Export Sales

„          Wholesale

‡        Accept the screen and return to the Gateway of Tally.

 

 

Step 1: Creating a Price List

Go to Gateway of Tally > Inventory Info. > Price List

 

1. Select the Group Components (you will notice that all the items grouped under Components

appear automatically).

2. Select Retail Sales as Price Level and specify 1-1-2010 in the Applicable From field

3. For USB Pen Drives 100MB give the details as follows:

        Less than - 10 nos - Rs.1,250/- and no discount

        From 10 nos and Less than 25 nos - Rs.1,250/- and 5% discount

        From 25 nos onwards - Rs.1,250/- and 7.5% discount

4. Specify the price details for other items as it appears in the Price List screen below :
Price Levels and Price Lists in Tally.ERP9

5. Accept the Price List Details

6. Similarly, create another Retail Sales Price List as on 3-1-2010 with the following rates:

                    USB Pen Drives 100MB - Rs.1,500

        Wireless Keyboard - Rs.500

        Wireless Mouse - Rs. 300

 

7. The Quantity and Discount details are similar to the price list screen given previously. Ensure the price details are as shown below :
Price Levels and Price Lists in Tally.ERP9
8. Press Y or Enter to accept the Price List.
 

8.2. Using Price Lists

On 2-1-10 raise a sales Invoice on Beltron Computers for the following Items :

 

Name of the Item

Qty

USB Pen Drives 100MB

30 Nos

Sound Card

10 Nos

 

The Invoice amounted to Rs. 35,687.50

Setup:

       Create a New customer called Beltron Computers with the following details.

 

Pricing Level Applicable

Maintain balances bill-by-bill

Cost Centres are applicable

Activate Interest Calculation

Retail Sales

Yes

No

No

       In the  F11:  Features  (Inventory Features) activate Separate  discount column  on invoices.

 

 

Step 1: Create Sales Invoice

 

1. On 2-1-10 raise a sales Invoice on Beltron Computers

2. Select the stock item USB Pen Drives 100MB from On-site

3. Specify quantity as 30 nos.

4. Rate and discount automatically appears as Rs. 1,250 and 7.5% respectively (as the required price level is selected in the ledger master of Beltron Computers).

5. Ignore negative stock and allocate to Sales- Components

6. Select Amar as Cost Centre.

7. Now, select another item - Sound Card

8. Type the quantity as 10 nos (here in this case, the cursor prompts in the Rate field since price lists is not defined for this item)

9. Specify Rs. 100 as Rate

10.Press Enter to skip the discount field

11.Allocate to Sales- Components and select Amar as Cost Centre.

12.Give the bill-wise details as required and accept the entry

Step 2: Create Sales Invoice

 

On 5-1-10 raise a sales Invoice on Beltron Computers for the following Items :

 

Name of the Item

Qty

USB Pen Drives 100MB

30 Nos

Sound Card

10 Nos

The Invoice amounted to Rs. 41,500.

 

1. Similar to invoice dated 2-1-10 select the item USB Pen Drives 100MB

2. Specify quantity as 30 nos.

3. Rate as Rs. 1,500 and discount of 10% appears automatically (as we have defined it in the Price List dated 3-1-10)

4. Ignore the negative stock and allocate to Sales- Components. Select Amar as Cost Centre.

5. Accept the quantity details of the USB Pen Drives 100MB stock item

6. Select another item, Sound Card and give the quantity as 10 nos

7. Specify Rs.100 as the Rate.

8. Tally.ERP 9 prompts for the discount information. Let us leave it blank (you already know that you can specify as required or simply leave it blank).

9. Allocate to Sales- Components ledger

10.Give the bill-wise details as required.

11.Accept the entry

 
 
Text
 
Company Information @ Tally.ERP9
Group & Ledger

Introduction
1. THE GROUP
2. THE LEDGER
3. VOUCHERS TYPES

Advanced Inventory / Stock
Meaning
Order Processing
Re-Order Levels
Tracking Numbers
Batch-wise Details
Additional Cost Details
Bill of Materials (BOM)
Price Lists and Price Levels
Stock Valuation
Zero Valued Entries
Inventory Ageing Report
Actual and Billed Quantities
Advanced Usage of Vouchers
Maintain Bill-wise Details
Cost Center and Cost Category
Interest Calculation
Reversing Journals
Post-Dated Voucher
Memo (Memorandum) Voucher
Optional Voucher
Using Tracking Number
Tally.ERP9 Report
  1. Unit Objectives
  2. Modifying Reports (Options)
  3. Balance Sheet
  4. Profit & Loss Account
  5. Stock Summary
  6. Trial Balance
  7. Day Book
  8. Books of Accounts
  9. Statement of Accounts
  10. Inventory Books
  11. Statutory Reports
  12. List of Accounts ( Chart of Accounts)
  13. Exception Reports
  14. Printing Reports
Tally.ERP9 MIS and Other Reports
Statutory & Taxation
 
Utilities & Others @ Tally.ERP9
Credit Limits
Knowledge Base @ Tally.ERP9
Stock Items
Stock Groups
Inventory Masters
Inventory Vouchers
Inventory Report Statements
Balance Sheet
Accounting Reports
Accounting Vouchers
Interest Calculation
VAT-Value Added Tax
Service Tax
TDS (Tax Deducted at Source)
 
Disclaimer :

The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit www.tallysolutions.com , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :

Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP –9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners. This Website is not associated with any product or vendor mentioned in this Website.

 
 
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09853349238, 09437264738
Get Updated ...
Website Designed, Hosted, Owned by : www.BalasoreCity.Com