How can we find Inventory Item Costing Data at Inventory Transaction Level ?
Summary: How can we find Inventory Item Costing Data at Inventory Transaction Level ?
Each month we compare Inventory Stock Valuation [Cost Accounting > Review Inventory Valuation] to GL [Material Stock Account (Oracle Inv control a/c)] to see they are still in line.
At the close of February we have a difference of 18.99. where the Material Stock Account is showing greater than the Inventory Stock Valuation.
We have a way of identifying the value of each Transaction to hit the Material Stock Account in GL and therefore verify that total.
However, we are not able to find a Task/Report/Data Extract that gives the transactional details from within Inventory / Cost Accounting to reconcile the Inventory Stock Valuation.