Reducing the Recurrence count by one whenever a user creates a copy of the PO record in Before Submit Trigger using User Event Script in Netsuite.

Steps:- First visit a Parent PO record. Click on edit and enter a desired positive integer value in the Number of Recurrence field. Click on save. Make a copy of the Parent PO. Save the child record or copy of that PO. Navigate to the respective or related Parent PO. The number will be reduced… Continue reading Reducing the Recurrence count by one whenever a user creates a copy of the PO record in Before Submit Trigger using User Event Script in Netsuite.

Scheduling Fixed Asset Creation

Scenario: If the bill/journal contains lines that don’t have fixed assets created is greater than 100,  The script will create fixed assets with scheduled process. The script will be scheduled for every 1 hour. And the scheduled script will send the email to the bill owner after creating the fixed asset for that bill. Solution:… Continue reading Scheduling Fixed Asset Creation

Search is not working in the Extension

The search is not working in the extension. But the search is working in Netsuite. Issue: There are two functions in the extension for getting details of files and folders from the backend(suitescript file), In the execution log of the corresponding ssp application, it is showing as blank object value is not getting. Solution 1:… Continue reading Search is not working in the Extension

Map-Reduce script example

Map/Reduce scripts in NetSuite is a scheduled script type that can work on large set of data. It is intended for parallel bulk data operations. They offer more power and benefits over the standard Scheduled scripts.This is a sample code of a map-reduce script for sending emails to all customers with pending invoices that are… Continue reading Map-Reduce script example

Differentiate OneWorld and Mid-market accounts for Scripts

While creating scripts for NetSuite OneWorld and Mid-market accounts, we can make use of the feature runtime.isFeatureInEffect(‘SUBSIDIARIES’)) returns true if Subsidiary is present and thereby denoting One World account. returns false if Subsidiary is absent and thereby denoting Mid-market account. runtime.isFeatureInEffect(‘MULTISUBSIDIARYCUSTOMER’)) returns true if Subsidiary is present and thereby denoting One World account. returns false… Continue reading Differentiate OneWorld and Mid-market accounts for Scripts

SALES REP CONTRIBUTION BASED ON THE BRAND.

This proposal covers the scope of displaying the sales rep contribution based on the brand. Requirement  The client sells many types of brands. The sales reps are responsible for selling these brands, the sales rep can sell more than one brand.  A customer can have multiple sales reps if they buy different brands. On a… Continue reading SALES REP CONTRIBUTION BASED ON THE BRAND.