Aggregation and weighted average?

Question

I am a newbie to FAW so seeking for help here.

I am trying to display the weighted average price for products but have no idea how to achieve it.

In the below table, I would like to aggregate invoiced qty and $/uom by month, and $/uom is showing weighted average price.

For example, in Mar-23 New Zealand's invoice qty should be 234+37+498+2899=3668 and weighted average $ should be (234x369)+(37x371.05)+(498x371.05)+(2899x371.05)/(234+37+498+2899)=370.92

So, under Mar-23 for New Zealand, it shows 3668 as quantity and 370.92 as price.

Any advice is appreciated. Thank you.

Phil Leu · Answer

@User_8LCPT - I agree with you and we're having the same issue.  The "Inventory Onhand Value" is incorrect in the 'Inventory Turns' subject area.  In our case, it's drastically overstating the value.  Hope Oracle resolves this.

User_8LCPT · Answer

@Sinduja Sekar-Oracle  I'm having the same problem, the inventory on hand value is being wrongly calculated in the 'Inventory Turns' subject area as the unit price is being aggregated instead of providing an weighted average.

Did you find a solution for that issue?

User_Q29EU · Answer

Having the same problem

———————————————————————————

Edit: MyTeamz