Hi I am having difficulty trying to work this one out work.
I have a customer being added or updated from a hubspot deal into NetSuite.
The error I am receiving is "Failed to save record because Currency must be unique"
The customer may or may not already have the currency against them.
I feel I have tried all the combinations I can for setting the currency fields
The field settings are
Has anybody got any idea what I should be doing to get this working?
Thanks
Tim
I doubt this is an option (i.e. it depends on if HubSpot always has all the currencies that need to be set), but there should be a 'Currencies: Replace All Lines' mapping that you can hardcode to true, and then this will tell NetSuite to wipe out and reset all the currency values, which should solve the duplicate currency value issue.
If HubSpot does not always contain all the currency values, or if currency values are being updated in NetSuite directly by some other business processes or integrations (which i imagine is the case), then you really need a solution that can dynamically iterate through the existing currency list in NetSuite right before the record is updated, and then decide if the currency value(s) being sent by HubSpot need to be preserved vs discarded, etc... To do something like this, you can use a preMap SuiteScript hook.
