You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!