Scenario
Inventory Valuation Report with Foreign Currency Amount shows positive balance when On Hand and Inventory Value is zero.
Solution
- Navigate to Reports > Inventory/Items > Inventory Valuation
- Report Name: Enter Name
- Click Customize Detail
- Click Edit Columns
- On Search Fields, search Amount (Foreign Currency)
- Click Preview or Save
Note:The reason why column Amount (Foreign Currency) is not showing zero or the expected amount is because transactions in the inventory valuation are not converted to foreign currency.
The ability to convert the report amount to a Foreign Currency is still an enhancement request filed under Enhancement 80057.