Why scheluded script creates duplicate entries?

AI generated answer (using internal Slack threads):

A scheduled script in NetSuite might create duplicate entries due to several reasons: 1. Lack of Uniqueness Check: If the script doesn't have a mechanism to check for uniqueness of records before creating them, it might end up creating duplicate entries. This can be resolved by implementing a uniqueness check in the script. For example, in the provided conversation, a user event script is used to enforce uniqueness by checking if a record with the same 'name' field already exists before creating a new one. If a duplicate is found, an error is thrown. Here is the code snippet from the conversation:

code
   var uniqueId = newRecord.getValue({
     fieldId: 'name'
   });

   var filters = [
     search.createFilter({
       name: 'name',
       operator: <http://search.Operator.IS|search.Operator.IS>,
       values: uniqueId
     })
   ];

   var existingId = search.create({
     type: 'customrecord_abc_container',
     filters: filters
   }).run().getRange({
     start: 0,
     end: 1
   });

   // Check if any existing records were found
   if (existingId.length > 0) {
     throw new Error('The record already exists.');
   }

2. External ID: Another way to enforce uniqueness is by using the 'externalid' field. NetSuite won't allow you to create a new record with an existing 'externalid'. However, this might not be applicable for records created through the UI, as 'externalid' cannot be set in the UI. In such cases, a script can be used to automatically set the 'externalid' in the UI. 3. Companion Custom Record: Another approach suggested in the conversation is to create a companion custom record and set its 'externalid' as the 'name' of the original custom record. If the companion record saves successfully, then it's unique. If it doesn't, it isn't unique and an error can be thrown. Remember, these are potential reasons and solutions based on the provided conversations. The actual reason might vary depending on the specific script and its context. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******