Hi James, You can find the average cost of the product on this screen <https://demo-trunk.ofbiz.apache.org/facility/control/InventoryAverageCosts?facilityId=WebStoreWarehouse>. If you receive the inventory of the product then average cost is automatically calculated by updateProductAverageCostOnReceiveInventory service.
Thanks & Regards -- Yashwant Dhakad On Tue, Aug 28, 2018 at 5:39 PM <[email protected]> wrote: > 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 > >
