Get..Tally.ERP9 Book + GST Assignment @ Rs. 550


 

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

 
Get..Tally.ERP9 Book + GST Assignment @ Rs. 550
 
 

Get..Tally.ERP9 Book + GST Assignment @ `. 550 !

15 Chapters in Tally.ERP9 Book + 21 Chapters in GST Practical Assignment on GST in Tally.ERP9 & All features are described with Practical Problems with Solutions.

Buy Now


 
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 GST,TallyERP9 GST, 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 : 09437264738

© 2018 : www.tallyerp9book.com

Tally.ERP9 Book CONTENT Tally.ERP9 Book ORDER