RE: How to write script to avoid duplicate record creation before record submit using suitescript 2.0

I want to create a user event script to avoid custom record creation if record is duplicate.

Also this custom record is being attached to another custom record. I have to stop from creating and attaching custom duplicate record.

Please Help!!

Maira S Beginner Asked on February 23, 2023 in SuiteScript.
Add Comment
10 Answers

Are the two fields globally unique, or just unique for the record they are attached to?  If they are globally unique, you could combine both field values into a single string and set that as the external id, assuming you aren’t already setting a different value in the externalid.  Netsuite will prevent duplicate creation and throw a DUP_CSTM_RCRD_ENTRY error.  If the two values are not globally unique, then maybe a combination of those two values and the internal id of the record they are being attached to would work instead.  For example:  custrecord_field1 + ‘~’ + custrecord_field2   or   otherRecord.id + ‘~’ + custrecord_field1 + ‘~’ + custrecord_field2, using whatever separator character makes sense.

Beginner Answered on February 23, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.