Many businesses deliver stock with a delivery note or a challan and the bill is raised later. There may be a situation where you raise a bill first and then deliver the goods against the bill raised or receive the goods against a purchase bill. In such cases, it is important to 'Track' the delivery or receipt of inventory against the bill. Tally.ERP 9 has a feature called Tracking Numbers to achieve the same.
'Tracking' the delivery or receipt of inventory, is purely an inventory-related activity. Tally.ERP 9 helps in bringing such entries into the accounting statements to help the user in ascertaining the profit or loss for a stipulated period. In case sales bills are to be raised an additional element in the detailed Profit & Loss statement appears as Sales bills pending and for Purchases the same will appear as Purchase Bills pending.
1. Using Tracking Numbers in Tally.ERP9
On 2-8-2017 Ref GRN/NB - 1,000 Pcs of Bricks received from Navketan Bricks @ ₹. 4 /Pc against previous Purchase Order No-1
In the earlier sections, we have recorded Purchase Orders No-1 on 2-7-2017 with due dates 1-8-2017 with 5000 Pcs. Bricks from Navketan Bricks.
The above receipt of 1,000 pcs is received against the ordered quantity of 5,000 pcs.
Let us raise a Receipt Note for the PO/001 raised on 2-8-2017 with due date 2-8-2017.
In the F11: Features (Inventory Features), activate
Step 1: Create Receipt Note
Go to Gateway of Tally > Inventory Vouchers >F9: Receipt Note.
Party's A/c Name: Navketan Bricks
Purchase Ledger : Phases @ 5%
Name of the item: Bricks
In Item Allocations for screen, Select Tracking No.1
In the main voucher screen, enter 3% for Freight charges and the value gets calculated automatically.
Enter the remaining details and accept the voucher.
2. Display Purchase Bill Pending
Go to … Gateway of Tally > Display > Statements of Inventory > Purchase Bills Pending >
The Purchase Bills Pending report appears as shown below :
- Press Alt + F1 for a detailed view.
Tally.ERP 9 tracks down the details of goods received for which bills have not been received. To view effect of above report,
Go to Gateway of Tally > Profit & Loss Account and view the Purchase Account.
You will find that the value of goods received (recorded through Receipt Note) are included in the Purchase Accounts under Purchase Bills to come, for ascertaining the profits accurately.
view Sundry Creditors from Balance Sheet, you will find that liability is created under Purchase Bills to come
On 2-9-2017, you receive the purchase Bill No. NB/15 from Navketan Bricks for their Delivery Note No. GRN/1 for 1,000 Pcs of Bricks @ ₹. 4 /Pc.
Go to Gateway of Tally> Accounting Vouchers > F9: Purchase
After completing the above entry, view Purchase Bills Pending. You will see No Pending details.