This will treat last ‘inwards’ as a reference point for the valuation rate. This takes into account the ‘landed cost’ based on the last ‘inwards’ (inclusive of any allocated additional costs to it. The last ‘inwards’ is selected for the stock item.
Entries are shown below:
Date |
VCh Type |
Inwards |
Outwards |
||||
|
|
Quantity |
Rate |
Value |
Quantity |
Rate |
Value |
01/04/09 |
Purchase |
10.00nos |
100.00 |
1000.00 |
|
|
|
02/04/09 |
Purchase Bill Pending |
2.00nos |
175.00 |
350.00 |
|
|
|
03/04/09 |
Purchase |
10.00nos |
200.00 |
2000.00 |
|
|
|
04/04/09 |
Purchase |
25.00nos |
225.00 |
5625.00 |
|
|
|
05/04/09 |
Sales |
|
|
|
10.00nos |
300.00 |
3000.00 |
06/04/09 |
Sales |
|
|
|
15.00nos |
400.00 |
6000.00 |
|
|
47.00nos |
183.50 |
8975.00 |
25.00nos |
360.00 |
9000.00 |
When these entries are passed in Tally.ERP 9, the stock voucher report will appear as shown below:
As on 1st April 2009 = closing rate will be taken Rs. 100/-.
As on 2nd April 2009 = closing rate will be taken Rs. 220/-. Ie., 2nd April 2009, receipt note is raised for 2 nos and on 3rd April 2009 10 nos are purchased, hence 20 nos (1st and 2nd purchase) + 2 nos = 22 nos, hence, 22 x 200 = 4400/-.
And it continues to calculate the values in the same way.