Currencies in Salesforce and NetSuite
6 min
breadwinner can handle any combination of currencies and multi currency status it is designed to work with situations where both netsuite and salesforce have one currency situations where both netsuite and salesforce have multiple currencies situations where one system is single currency and the other is multi currency multiple netsuite orgs with multiple different currencies in each situations where the currencies are not aligned and each system might have currencies the other does not all of this will be handled transparently, with no action required by the user data flow from netsuite to salesforce breadwinner will identify all the currencies in netsuite, and replicate those currencies back to salesforce and store the netsuite currencies in an object netsuite currencies those currency records will contain the netsuite currency name and the iso value of that currency the iso value is vital as salesforce uses the iso value as well all records that breadwinner replicates from netsuite to salesforce, which have a currency value, will have that currency displayed on the record in salesforce this is stored as regular data in salesforce, in a text field, and is fully reportable the currency field is on almost all objects, including the subsidiary record, and the transaction records (sales order, estimate, invoice, credit memo) additionally, the company record will have a primary currency field, and a list of all currencies enabled for that company breadwinner will show a netsuite item's price level and currencies (the grid below on the item takes all the information from the item price, which is the record that associates an item to a price level and currency for a given quantity) data flow from salesforce to netsuite some aspects of record creation will need to be done in netsuite as they are best handled there for instance, breadwinner cannot add currencies to netsuite, nor can breadwinner add additional subsidiaries to netsuite this is by design, as this level of functionality is strictly the remit of the finance department and is also best handled in netsuite for records that are normally created via breadwinner, then we handle setting the currency transparently, with little to no effort from the user creation of a netsuite company when you create a netsuite company, breadwinner checks if the netsuite company being created will be in a netsuite org with only one possible currency if so, then that's the currency of the new company if the netsuite org has multiple currencies, then breadwinner displays a primary currency picklist with values for all of the available netsuite org's currencies that currency picklist selection will default to the sf account's currency if that currency is available in the netsuite org's currencies if not, then the currency of the primary subsidiary here is a screenshot of a netsuite customer creation, with the full list of currencies it defaulted to the salesforce account currency, but we allow the option to override the default choice creation of a netsuite transaction (transaction includes the estimate, sales order, invoice, and credit memo) when you create a netsuite transaction, breadwinner displays the currency field read only first, breadwinner checks to see if a currency was specified in the custom url? and, if not, what is the currency of either the originating record (if salesforce multi currency has been enabled) or the currency of the salesforce org? and then breadwinner checks if that currency is available in the netsuite customer's currencies? if so, that currency will be displayed read only if not , breadwinner will provide a warning message about currency mismatch, and will not allow record creation
