Item Average Cost
Hi Guys
Do the below Query Correct to get average cost ?
SELECT avg(ACTUAL_COST) FROM MTL_MATERIAL_TRANSACTIONS WHERE organization_id='XXX' AND inventory_item_id='XXXXX';
Actually, i compared the result of this query with the average cost from item cost workbench
but they are a different, do I miss another condition on the query ?
Thank you