Wednesday, January 2, 2019

Inventory Valuation Report to show Balance in Foreign Currency Amount

1.  Navigate to Reports > Inventory/Items > Inventory Valuation > Customize Detail

2.  Report Builder > Edit Columns > Search Fields > click Amount (Foreign Currency) > click Preview or Save

3.  Item On Hand 0 > Inventory Value = 0.00 > Amount (Foreign Currency) = positive amount.

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.

No comments:

Post a Comment