Show Amount in Foreign Currency Based on the Currency of the Transaction

 

This behavior is reproducible when the Currency set in the Subsidiary Record assigned to the  Customer is same as the Base Currency of the Account. To explain further, see example below:

• Setup > Company > Company Information > Currency= USA
• Sales Order transaction record > Accounting tab > Currency = British Pound
• Customer Record > Currency = British Pound, Subsidiary= Head Office
• Subsidiary Record (Head Office) > Currency= USA

The ability to show the transaction amount in foreign currency based on the transaction is logged as Enhancement 180347. The alternate solution is to add Formula Currency and then enter the formula {fxamount}/ NULLIF({quantity},0).

We can also use Formula Currency {grossamount}/{exchangerate} to get the expected Amount in the search results.