Skip to Content
This question has been flagged
2 Replies
3376 Views
Avatar
ABU K

Hi all,


I need this Scenario... need a help..


We need a virtual Stock Amount: Normally the System shows me a Sum of everything we

have on Stock, minus the Sales plus the Purchases – I will need a second virtual Stock,

showing me the Sum of what we have, minus the Sales (without the Purchases).

Avatar
Discard
Avatar
Thomas Guénard
Best Answer

Strange need! You will explain I guess....

The end of period stock is a calculated as

value at the beginning of the period + purchases of the period - cost of good for the items sold during the same period

The stock journal records stock moves as follows (using the valuation method  that fits your needs: FIFO or average cost; I do not recommand using LIFO because it undervalues the inventory)

  • receipt of goods (purchases)    debit stock account / credit stock receipts account (a special account to be created into your chart of account and used for the settings of recepits of the product categories); the value of your inventory is increased by these purchases/receipts

  • sale of goods:                                credit stock account / debit stock delivery account (a special account to be created into your chart of account  and used for the settingsof deliveries of the product categories););  the value of your inventory is decreased by these deliveries. This account represents the cost of good sold


Avatar
Discard
ABU K
Author

is this satisfy my requirement?

Avatar
Nick Lines
Best Answer

we also need this feature, anyone?

Avatar
Discard