This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

how to fetch the list of day to day exchange rate of the currencies in netsuite

&gt;*AI generated answer (using internal Slack threads):*
To fetch the list of day-to-day exchange rates of the currencies in NetSuite, you can use the SuiteTalk API. The SuiteTalk API provides a SOAP web service that allows you to interact with NetSuite data and services. 

Here is a general outline of the steps you would need to follow:

1. Use the `search` operation of the SuiteTalk API to search for exchange rates. You would need to specify the `CurrencyRateFilter` in your search request. This filter allows you to specify the base currency, the transaction currency, and the effective date for the exchange rate.

2. The response from the `search` operation will include a list of `CurrencyRate` records that match your search criteria. Each `CurrencyRate` record includes the base currency, the transaction currency, the effective date, and the exchange rate.

3. Parse the response to extract the exchange rates and their corresponding effective dates.

Please note that the exact details of how to use the SuiteTalk API, including how to authenticate your requests and how to format your search requests, are beyond the scope of this response. You should refer to the SuiteTalk API documentation for more information.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C29HKGM6J/p1619622992256700|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.826798

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1678126191137989|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.820262313

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C2K2RJNAC/p1621334449002500|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.816281796



Please provide your feedback on this answer.

If you want a simpler way through the UI, drop this URL into your browser when logged in:

&lt;https://[your_account_number_without_the_brackets].app.netsuite.com/app/common/report/dataset.nl?recordType=currencyrate&gt;

You can add/remove the fields you want and save and then it will be in your saved data sets under the Analytics tab.