map/reduce script – knowledgebase JJ

Unique Folder Name for Error Files

If the map/reduce script, we can create unique name for the error file by using the time in seconds in the summarize stage. All the error details are stored as a csv file and will save in a file cabinet with different name for the future reference. reduceContext.write({ … Continue reading Unique Folder Name for Error Files

Updating Entity Name In Journal Entry Line Level

Client needs to update missing entity names in specific lines in the journal entry record. The details was given in CSV file. We have updated using a scheduled script,

Map/Reduce Script to Update Landed Cost In IR record using CSV Custom Import

The client needs to update the landed cost template at line level in IR record using a CSV file. We have created a map/reduce script to update the values.

Scheduled script to update custom price field in Item Record

The client needs to update a custom price field in the item record based on some values in other fields.

Schedule a map reduce script to run on weekdays.

We can schedule a map reduce script to run on weekdays. For that, Go to Script Deployment–> Schedule–>Select daily event–>Select repeat every weekday

RX Status Change in Auto-Ship

Map reduce script powered by saved search, to set RX Status in line record based on date range set.

Schedule the map-reduce script on the first working day of every month

Changing The Value In A Custom Field In The Sales Order Using Scheduled Script

Script For Sending Payment Reminder Emails (Map/Reduce)

The requirement is to send a payment reminder email if the customer is not done payment after 1 hour of sales order creation from the website. We need to consider the following conditions for sending the payment reminder email: Condition For sending Email: The following conditions need to be true. The payment confirmation checkbox(a custom… Continue reading Script For Sending Payment Reminder Emails (Map/Reduce)

How to resolve errors while deploying Map/reduce script

Scenario:While creating a new script record in Netsuite and deploying the script, there may b a “Failed” message displayed on the status page. One major reason for this will be the file name of the script file if the filename of the script file is large or any special characters are used this may lead… Continue reading How to resolve errors while deploying Map/reduce script