This article summarizes the creation of the currency exchange rates saved search without showing duplicate rates in the result.
We can create a currency exchange rate saved search from the currency exchange rate page. When creating a saved search for currency exchange rates, it will show multiple lines for the exchange rates of the same currency pairs on the same effective date. Even if we have grouped the internal id to “Maximum” the search result will show multiple lines. These multiple lines are showing in the search because a user had updated the exchange rate multiple times for the same currency pair and in the same effective period.
To create the currency exchange rate search without duplicate lines,
Go to, List> Accounting> Currency exchange rates> New. Click on the “Search” link. On the results tab, provide the following:
- Internal id
Summary type – Maximum
- Effective Date
Summary type – Group
- Formula (Text)
The currency exchange rate search result will show only the internal id of the currencies. To show the currency name/symbol, we have to add a formula to the results.
Example:-
Internal id Currency
1 GBP
2 USD
3 CAD
If we have the above base currencies in our NetSuite account, then the formula to use is,
Formula – Decode({basecurrency},’1′,’GBP’,’2′,’USD’,’3′,’CAD’)
Summary type – Group
The result will show the currency name instead of the internal id.
- Formula (Text)
Formula – Decode({transactioncurrency},’1′,’GBP’,’2′,’USD’,’3′,’CAD’)
Summary type – Group
The above formula is to show transaction currency in the result.
- Exchange Rate
Summary type – Maximum
When ordered by = “Internal id”
- In the available filters, provide the fields:
– Effective date
– Base currency
– Transaction currency
Provide a name to the search and click on “Save & Run”.