Simple-seeming question that seems to elude me. Do...
# general
c
Simple-seeming question that seems to elude me. Does NetSuite allow for an external ID to be updated more than once? I took a template from NetSuite Support and am running it exactly as explained, with CSV "Update" - still not getting the actual External ID to update. I've also tried a workflow, with no good results. But the answer to whether you can update an External ID more than once for a NetSuite Customer Record doesn't seem to lie in SuiteAnswers.
s
pretty sure you can update it as much as you want, whats the volume? if its not a lot, I 'd almost use a debugger script or just go right through with the ui console if you have admin
n
Hey Curtis, I can confirm this works for at least Employees. Can you share your import file?
I do have admin. We have a custom field for External IDs that is supposed to reflect the assigned External ID. This is how we know the External IDs are not being copied properly. The external ID is blank for one of the lines because I want to null the ext id
Also, despite the "inactive" mention, currently both records are active.
n
Importing a blank value like that doesn’t actually set the value to null. To do that, you need to either use the advanced option Overwrite Empty Fields, or manually set the field mapping to null. Additionally, if you have a custom field named External ID, be sure NetSuite didn’t automatically map your upload to the custom field when you meant to import against the native field.
c
Agreed, that makes sense. And thank you for the Null field mapping point, I will try that.
I thought I had mapped the native external field, but it's worth trying again. Thanks!
1
m
It's not possible to blank out an external id once it's set. Your only option is to set it to a random value.