This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

What are the rules for setting externalids via SuiteScript? I'm seeing a lot of conflicting info online. I've tried using null/empty string via MR script using `submitFields` and `setValue`. None of these attempts have worked. We have a poorly designed integration and it's failing to create Items and BOMs because it's updating BOMs on inactive Items.

The documentation says Web Services and CSV import only. Is that really the only way? I was hoping to automate this process, and we don't have any Web Services infrastructure.

You should be able to set an external ID on create but I don't believe you can modify it after record creation.

You can modify it using scripting, but it can't be cleared

i knew there was some little gotcha with it

That makes sense I guess. Uniqueness and all

Ditto with the above. I've written map/reduce scripts to keep these updated, but you cannot clear them.