I was involved to get the Avg unit cost of an item. I found the table is cst_perpavg_cost . This table is being updated whenever a specified quantity of an item is entered an inventory (organization).
This operation called receive. in the table, there are three Quantities can be confusing. UNIT_COST_ONHAND is the avg unit cost before the operation started. The receive operation itself in this example is [UNIT_COST_NEW] . This operation will result that a new Avg unit cost is created (in the same record). the new Avg unit cost is [UNIT_COST_AVERAGE].
•Item=FPPCDA4
•[UNIT_COST_ONHAND]
before the last transaction is 2.2020 SAR
•QTY: 987 unit with a Cost 2.1322 [UNIT_COST_NEW]
•The system calculates the New Avg
Unit Cost
•[UNIT_COST_AVERAGE] is
the latest Avg
Unit Cost 2.2008
•The new Avg
Unit Cost has been decreased because of the low cost 2.1322 SAR and Qty
987 Unit
same values shown above are found in the Fusion Screens
and the history shows last transaction that cause the Avg unit cost to be changes/updated
hope this info is helpful
