Average Unit & FIFO Unit Costs for the Physical Inventory Adjustment Report

Hello,

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.