Team I am trying to follow where the moving average inventory for an item is stored in the system so I can track that things are calculating correctly. Here is an example:
On 10-1 I have a beginning inventory of 100 units @ $10 On 10-3 I receive a purchase order of 100 units @ $11 So we have ($1000+$1100)/200 - Moving Average is $10.50 and we have 200 units at that costs I would assume the system calculates the inventory valuation prior to each sell to get an accurate Costs of Goods Sold On 10-5 we have a sale of 100 units. The Costs of Goods Sold should go out at $10.50 This leaves us 50 units @ 10.50 (Where does Of biz store this?) On 10-6 we receive a purchase order of 100 units @10.80 We now calculate our new moving average as ((50 * 10.50)+(100*10.80)/150) = $10.70 (Where does Ofbiz store this) On 10-7 we sell 50 units and our Costs of Goods Sold should go out @ $10.70 Where in Ofbiz can I see the storing of the perpetual moving average? Thanks, James
