Requirement:
Is it possible within NetSuite to export and/or download the Currency Exchange Rate History.
Currently there is no option to filter or to export.
Is one available ?
Solution:
Currently, the ability to export the data in the Currency Exchange Rate page is a system limitation filed under enhancement 158715 Lists > Accounting > Currency Exchange Rates/Currencies. Ability to export exchange rates and historical exchange rates.
There are two options in generating the data:
Option 1:
Via Currency page:
1.) Navigate to Lists>Accounting>Currencies
2.) On the page, click the Currency Exchange Rate History
3.) In Exchange Rate History page
You can copy the data on this page and paste into an Excel spreadsheet
On the spreadsheet, you can add filters, sort the data, or do any data manipulation to be able to show the desired report
Note: You will need to copy per page on an Excel spreadsheet
Option 2:
You can create a Saved Search
1. Navigate to Lists>Accounting>Currency Exchange Rates>New
2. On the upper left side of the screen right above the page title click on Search
3. Click Create Saved Search
4. On the Criteria tab add the following fields:
• Base Currency = Select a Base Currency for example: USD
• Transaction Currency = Select a Currency for example: GBP
• Effective Date is within (for example 6/01/2022 to 6/30/22)
5. On the Results tab add the following fields:
• Base Currency
• Transaction Currency
• Exchange Rate
• Effective Date
6. Hit Preview or Save and run.
7. Export the saved search.
Note that the results will show the Internal ID of the Currency and not the actual Currency Name.
