Scheduled Script Best Practices

The following are best practices for scheduled scripts. Genaral guidelines: You should set your scheduled scripts to run during the hours of 2 AM to 6 AM PST. Scripts set to run during the hours of 6 AM to 6 PM PST may not run as quickly due to high database activity. The number of Not… Continue reading Scheduled Script Best Practices

Single CSV file for different Records Import

Scenario Feasibility of using a single CSV file for importing various types of records into NetSuite using task module in scheduled script Created a scheduled script. Created 2 Saved imports, one for customers and the other for items. Saved a CSV file in suitescript folder under the name testcsvimport.csv The sample is given below Script… Continue reading Single CSV file for different Records Import

Coordinating Workflow and User Event Scripts in Sales Order Processing

In sales order processing, it is common to utilize both workflows and user event scripts to automate and streamline various tasks. However, a challenge arises when both the workflow and user event script need to be triggered in the Aftersubmit event, but the user event script must execute after the workflow is completed. In this… Continue reading Coordinating Workflow and User Event Scripts in Sales Order Processing

Function to fetch the Start time and End time for saved search based on the availability of the processor.

Case: When we schedule a script to run every 6 hours, then it will run at 12 am, 6 am, 12 pm, and 6 pm. when the script runs at 6 am, then we need the data from the time 12 am up to 5.59 am. But in case of priority, the scheduler runs at… Continue reading Function to fetch the Start time and End time for saved search based on the availability of the processor.