has anyone run into difficulty importing a sales o...
# integrationsa
al3xicon
03/30/2020, 3:31 PMhas anyone run into difficulty importing a sales order via Celigo before, when mapping the billing address country? i'm trying to map 'United States' to "Bill To Country (Name)" and it returns INVALID_KEY_OR_REF "Invalid country reference key United States."
r
rico
03/30/2020, 3:47 PM@Mannan
👍 1
m
Mannan
03/30/2020, 3:50 PMHey Alex, NetSuite would be expecting 'USA' as the value instead of 'United States'. Would you be able to map that and give that a go?
a
al3xicon
03/30/2020, 4:06 PMinteresting @Mannan thanks - my CSV file (exported via FTP site) has "United States" as the value - how can we get from there to a correct mapping in Bill To Country? I was expecting internal ID to be "US" and Name to be "United States", not "USA"
al3xicon
03/30/2020, 4:07 PMis this the same for other countries as well? i.e. what is the Name value for "Canada"?
al3xicon
03/30/2020, 4:08 PMalternatively, how can we get a lookup from "United States" to "US?" (for internal ID) -- there is no "Country" list I can see in the lookup record list
al3xicon
03/30/2020, 4:17 PM@Mannan meanwhile I tried your suggestion and received the following: "Invalid country reference key USA."
al3xicon
03/30/2020, 4:18 PMlet me try "US" now...
m
Mannan
03/30/2020, 4:35 PMWe do have options within the 'field mappings' to perform transformations so you could effectively change A-> 1 and B-> 2 etc
Mannan
03/30/2020, 4:36 PMAlso, there's a custom record available through the NetSuite bundle (20038) called 'Celigo Import Lookup' which houses a few basic address transform tables and you can add as many as you'd like to it, just ensure that the 'External value' column is unique
a
al3xicon
03/30/2020, 4:53 PMI'll take a look, thanks
al3xicon
03/30/2020, 6:28 PMthat helps, thanks again
m
Mannan
04/03/2020, 4:51 PMAnytime!
3 Views