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:
[hidden email]
On Tue, Aug 28, 2018 at 6:44 PM <
[hidden email]> 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 <
[hidden email]>
> Date: Tue, August 28, 2018 5:34 am
> To:
[hidden email]
>
> 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 <
[hidden email]> 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
> >
> >
>
Locked
