Thank you. Is there a table that shows me whats remaining in inventory and what COGS it will go out at when sold? So in my example below after the sale of 100 units on 10-5 I have 50 remaining at an average costs of $10.50 which is different than the original $10 I paid for those items.
-------- Original Message -------- Subject: Re: Moving Average Inventory From: Yashwant Dhakad <[email protected]> Date: Tue, August 28, 2018 5:34 am To: [email protected] 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 > >
