Requirement to display the Foreign Currency Amount without the Currency symbol in a Saved Transaction Search

Scenario: User wants to display the Amount (Foreign Currency) without the Currency Symbol in a Saved Transaction Search.

Solution:

Navigate to Lists > Search > Saved Searches > New
Click Transaction
Search Title: Enter Title
Click Criteria
Click Standard
Filter: Add all necessary filters
Click Results
Click Columns
Field:
Select Formula (Currency)
Formula: Set {fxamount}
Custom Label: Enter Amount (Foreign Currency)
Click Save & Run

Leave a comment

Your email address will not be published. Required fields are marked *