Updating NetSuite’s Currency Rates Programmatically

This article is relevant if you are using NetSuite’s multiple currency rates and you are not satisfied with the default daily automatic price update feature.

Foreign Currency Exchange Rate Updates

NetSuite does a good job supporting over 190 different currencies native.  Out of the box, you can ask NetSuite to update currency rates nightly.  However, what do you do if you are not satisfied with the rates they provide or the frequency / timing for the updates?  You can take matters into your own hands.

Three ways to Update Foreign Currency Exchange Rates

NetSuite offers three ways to update the foreign currency rates:

1. Manually via the menu Lists, Accounting, Currency Exchange Rates.
2. Via CSV Import.
3. Via Web Services (NetSuite’s SuiteTalk).

How to Update NetSuite’s Currency Exchange Rates with SuiteScript

function scheduleCSVCurrencyUpdate(csvLine) {
	//csvLine represents a line of comma separated values of price information

	var mappingFileId = "CUSTIMPORT_rate_trx_csv"; // this references a saved CSV import map with header info below

	// add a header to the import
	var primaryFileAsString =  "Base Currency,Currency,Exchange Rate,Effective Date\n" + csvLine;

	nlapiLogExecution('DEBUG', 'scheduleCSVCurrencyUpdate', csvLine); 

	// create the CSV import job with a description that leverages the date
	var job = nlapiCreateCSVImport();
	job.setMapping(mappingFileId);
	job.setPrimaryFile(primaryFileAsString);
	job.setOption("jobName", "MY_CURRENCY_UPDATE: " + new Date());

	nlapiSubmitCSVImport(job);
	nlapiLogExecution('DEBUG', 'scheduleCSVCurrencyUpdate', 'Job submited!');
}

Marty Zigman

Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - YouTube