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

Hey :saluting_face: i have a question?
when we create Order via Celigo to NetSuite
and if i try to create same  Order via CSV it's will create same Order is there a way to prevent that from happening in CSV

Thanks in advance

use an unique external ID for SO via Celigo, and if the same external ID is in your CSV for the same order then CSV import for that SO will fail with error external ID already exists. That means no duplication.

<@U2A2VHL3W> so you mean i will map it like this : OrderId = External ID on the Order flow

does Celigo brings in the order ID? If so make sure to map that to external ID so Celigo can set the external ID

once set use that as that as the exception