ANS-1597 · CUSTOMER & CRM RECORDS
How to Change a Customer’s Currency in NetSuite with Open Transactions?
NetSuite offers solutions for adjusting a customer's currency when open transactions are present, ranging from data re-entry to using the Multiple Currencies feature.
Short answer
When a customer's currency needs changing with open transactions, NetSuite offers solutions. Options include deleting and re-entering transactions, creating a new customer record for the desired currency, or leveraging the 'Multiple Currencies' feature, which enables a single customer record to manage transactions in multiple currencies.
Scenario
A common challenge in NetSuite arises when a customer's primary transaction currency needs to be changed, but there are already open transactions associated with that customer. This situation requires a careful approach to ensure data integrity and proper financial reporting, as NetSuite typically locks the currency once transactions are recorded.
Solution
NetSuite provides several methods to address currency changes for customer records with open transactions:
Transaction Deletion and Re-entry:
If the volume of open transactions is low and they were potentially entered in error, the existing transactions can be deleted. Subsequently, the customer record's currency can be corrected, and the transactions re-entered with the accurate currency.
New Customer Record Creation:
An alternative approach involves creating a completely new customer record. This new record would be configured with the desired currency for future transactions, effectively separating the customer's financial activities by currency.
Utilizing the Multiple Currencies Feature:
The most robust and generally recommended solution is to leverage NetSuite's 'Multiple Currencies' feature. This feature allows a single customer record to manage and process transactions in various currencies, eliminating the need for separate customer records or extensive data re-entry. Users are advised to consult NetSuite Help documentation for comprehensive details on its configuration, usage, and any specific caveats.
Expert NetSuite Support
Need help with this NetSuite issue?
Customer & CRM Records consulting and configuration support