When I'm creating a SalesOrder, I can reference th...
# suitetalkapis
Steve Cahill
08/09/2019, 2:36 PMWhen I'm creating a SalesOrder, I can reference the currency code thusly: <ns1:currency xsi:type="platformCore:RecordRef" internalId="USD"/>. But when I try the same thing when creating a Customer, it says I need to provide a valid internalId, and only accepts the numerical id of the currency. Is there a way I can reference the ISO Code for the currency when creating a Customer?
Steve Cahill
08/09/2019, 5:19 PMAs a workaround, I queried the NetSuite Currency object and stored the isocode in a Document Cache. Then during mapping, I used the ISO Code to retrieve the corresponding internalId from the Cache.
Steve Cahill
08/09/2019, 5:20 PMnote: solution is Boomi-specific
j
Jon Kears
08/10/2019, 6:46 AMit's worth populating your currencies with an external ID that matches the currency code. That's what we do anyway. You can do that using the netsuite API too. Just need to remember to do it whenever you have a new one (or run a saved search as the basis to populate it)
Jon Kears
08/10/2019, 6:46 AMIt's interesting you can push USD as an internalD on a sales order, must admit I've never even tried that
s
Steve Cahill
08/12/2019, 6:33 PMturns out the "iso code as internalid on transaction" has limitations -- doesn't work when multicurrencycustomer feature is enabled. best practice is definitely to either use ExternalId or to cross-reference the iso-to-internalid at runtime
2 Views