Average Unit & FIFO Unit Costs for the Physical Inventory Adjustment Report
I am hoping that you Inventory Cloud gurus can help me. I have created a custom report that shows the Physical Inventory Adjustments. Now I have to add the following columns to the report.
- Avg unit cost
- FIFO unit cost (not sure if this is possible given there could be multiple FIFO costs depending on quantities??)
- GL Adjustment Value (Adjustment Quantity x FIFO for negative adjustments OR Avg Cost for positive adjustments) *this would be what finance is actually “approving” to post to the GL*
Can anyone please advise me which tables to access for the above information?
We are currently on version 23A Oracle Fusion.