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

does “Currency Exchange rates” record exists? Is it possible to insert new exchange rate via suitescript

officially supported records are found at <https://system.na0.netsuite.com/app/help/helpcenter.nl?fid=preface_3710625923.html|SuiteCloud supported records>

yeah, I know... but it is strange that we have option to import CSV exchange rates but it is not possible to script... I would like to create custom integration for exchange rates...

unofficially you guess the record id and  create it anyways

the name of the record in suitecloud supported records gives you a pretty good guess on its id

<https://blog.prolecto.com/2013/05/30/updating-netsuites-currency-rates-programmatically/|https://blog.prolecto.com/2013/05/30/updating-netsuites-currency-rates-programmatically/>

yup actually I was about to say, have you ever thought about N/task -&gt; trigger the csv import in a scheduled script?

I'd just um add on to this, that if you do have a system with many base currencies, make sure your csv in the integration includes the combinations
USD (base) -&gt; GBP  rate and also include GBP (base) -&gt; USD

Because NetSuite wont cover it natively for you. Make sure if it's a monthly rate those values are 1/ the other

^and make sure it's consistent...