Hello James, *cogsMethodId *column of *PartyAcctgPreferance *entity is used to define the COGS method
There are four COGS methods are defined in the OFBiz - LIFO - FIFO - Average cost - Inventory item cost *ProductAverageCost* entity is used to store the average cost of a product and product average cost is updated every time whenever inventory is received. Hope that help Cheers! Vaibhav Jain Sr. Enterprise Software Engineer HotWax Systems m: 782-834-1900 e: [email protected] On Tue, Aug 28, 2018 at 6:44 PM <[email protected]> wrote: > 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 > > > > >
