Display the amount along with the transaction currency in the saved search.

Scenario: User needs to display the currency along with the amount in the report made using saved search.

Solution:

List> Saved search> New
Edit the transaction saved search.

1. On the Results tab: Add the following Fields.
   1. Document Number
   2. Name
   3. Formula Numeric
      Summary Type: Sum
      Formula: ((CASE {currency} WHEN ‘USA’ THEN ‘$’ WHEN ‘British pound’ THEN ‘£’ WHEN ‘Canadian Dollar’ THEN ‘$’ WHEN ‘Euro’ THEN ‘€’ END)||{amount})
2. Add a Label
3. Click Save & Run