Connect with ...

12. Different Actual and Billed Quantities in Voucher in Tally.ERP9

The need for different actual and billed quantities may arise in several instances. For example if an extra  inventory is sent to cover up for any stock that reaches in a damaged condition or Inventory sent as extra samples or the Stock is despatched to the customer as quantity discount.
   

Setup:

Ensure that you are in the Gateway of Tally of National Traders.

        Go to F11: Features (Inventory Features) and set Use Different Actual & Billed Qty to Yes.

12.1. Using Different Actual and Billed Qauntities
Go to Gateway of Tally > Accounting Vouchers > F8: Sales. You will notice that the Quantities column is divided into two columns, viz. Actual and Billed

On 3-3-2010, make a purchase invoice from Parvathi Stockers for the following items :

 

Name of the Item

Actual Qty

Billed Qty

Rate

(in Rs.)

Rice

100 Kgs

90 Kgs

10

Wheat

50 Kgs

50 Kgs

100

 

Setup :

        Create a new stock item as Rice with the following details :

          Group it under stock group Foodstuffs.

          Stock category - Not Applicable

          Unit of Measure - kgs (kilos) with decimal places - 3 (create if not present).

          Accept the master creation without any opening balance and return to the Gateway of

Tally.

 

 

Step 1 : Create Purchase Invoice

1. Enter a Purchase invoice on 3-3-2010 on Parvathi stockers.

2. Price level - Not Applicable

3. Select Rice under Name of Item

4. Order number - Not Applicable

5. Select the godown as Onsite

6. Type Actual Quantity as 100 kgs and Billed Quantity as 90 kgs

7. Specify the Rate as Rs. 10 and the value appears as Rs. 900 (billed quantity * rate). The screen appears as shown below :
Different Actual and Billed Quantities in Vouchers in Tally.ERP 9

8. Allocate to Purchases ledger and press Enter.

                    Select another item Wheat and enter the following details

 

                 Tracking number and Order number - Not Applicable

        Select Godown as Onsite

        Type Actual and Billed quantity - 50 bags

        Specify Rate as Rs. 100, the amount is defaulted as Rs. 5,000

 

9. Press Enter and accept the purchase invoice with the default bill-wise details.The Purchase invoice amounts to Rs. 5,900 (Rice - Rs. 900 and Wheat - Rs. 5,000).

 

 

Step 3 : Display Stock Summary

Go to Gateway of Tally > Stock Summary

 

                    Select Foodstuffs as stock group and press Enter
Different Actual and Billed Quantities in Vouchers in Tally.ERP 9

Tally.ERP 9 displays 100 kgs of Rice stock item because this is the quantity that we have actually received from the party. In case of Wheat the quantity appears as 150 kgs.

 

Go to Gateway of Tally > Display > Account Books > Purchase Register

 

        Select March month

        Press F12: Value button,

 

          Specify the range as Voucher - Having - Ledgers - With - Name - Containing - Par- vathi stockers (party name in purchase entry of 5-3-2010)

 

„         Press Enter.

        Press Alt+F1 to display the stock summary in detailed format

        Press F12: Configure and activate the option Show Inventory Details also

 

Tally.ERP 9 displays Voucher Register as shown below :

Different Actual and Billed Quantities in Vouchers in Tally.ERP 9
The inventory details display 90 kgs for the stock item Rice, because this is the quantity that the party has billed us for. (We have received 100 kgs of Rice i.e, the actual quantity. We will be making the payment for only 90 kgs i.e., the billed quantity). Therefore, the actual quantity affects the inventory books while the billed quantity reflects in the accounting books.
 
 
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