This article explains how to retrieve price level mappings and fetch price change details for inventory items using a combination of saved search and SuiteQL queries in SuiteScript 2.x. The approach compares pricing records of different versions to highlight pricing updates. Overview of Key Functions getPricelevel() Retrieves all price levels from NetSuite pricelevel record type… Continue reading How to Get Price Changes Using Saved Search and SuiteQL Queries in NetSuite
Author: Manikandan B
Fetching Data with Firestore Structured Queries and Index Creation
Overview This article explains how to fetch data from Firestore using the structured query format via REST API, demonstrates a sample query code, and covers the essential step of creating Firestore indexes to support complex queries. Fetching Data Using Firestore Structured Query In Firestore’s REST API, you can fetch data by sending a POST request… Continue reading Fetching Data with Firestore Structured Queries and Index Creation
Estimating Completion Date While Ignoring Holidays and Weekends
Overview This article outlines how to calculate an estimated completion date for a task or order in NetSuite, excluding weekends and holidays. Holidays are loaded from a CSV file stored in the File Cabinet, and the logic accounts for both hourly and daily turnaround times. Components 1. Holiday CSV File Format: The CSV should have… Continue reading Estimating Completion Date While Ignoring Holidays and Weekends
Calculating and Setting Due Date in Workflow Formula
This article explains how to calculate and set a due date in a NetSuite workflow using a formula that incorporates an interval and a date field. The formula uses NetSuite’s SuiteScript API functions nlapiDateToString and nlapiAddDays to compute the due date dynamically. Overview In NetSuite workflows, you can use formulas to dynamically set field values… Continue reading Calculating and Setting Due Date in Workflow Formula
Project Task Configuration and Work Tracking
Setting Up a Parent Task When creating a Project Task as a Parent Task, ensure the Planned Work field is set to 0 (zero). This configuration is required for the task to appear in the Parent Task dropdown menu. Understanding Work Tracking Fields The following fields are automatically populated by the system based on time… Continue reading Project Task Configuration and Work Tracking
BeforeLoad User Event Script for Item Image Display on Line Level
Overview This explains a User Event Script that runs in the BeforeLoad entry point to fetch a File ID on the Custom Field, retrieve an item’s image URL, and set an Inline HTML field with the image URL. The script enables users to view item images directly at the line level on a Sales Order,… Continue reading BeforeLoad User Event Script for Item Image Display on Line Level
Restricting the Promotion Banner in NetSuite List View
Overview This Article explains how to restrict the promotion banner from appearing in the NetSuite list view by updating the General Preferences and unchecking the “Show product recommendations” checkbox. Purpose This setting is useful for maintaining a clean and focused list view, free from promotional banners that can be distracting for users. Step-by-Step Guide 1.… Continue reading Restricting the Promotion Banner in NetSuite List View
Updating Sales Order New Tax Group on Line Level Using Map/Reduce Script
Overview This article provides a step-by-step guide on how to update the tax group on the line level of Sales Orders using a Map/Reduce script in NetSuite. The provided script example demonstrates how to achieve this efficiently by leveraging caching and search functionalities. Script Example /** * @NApiVersion 2.1 * @NScriptType MapReduceScript */ define([‘N/runtime’, ‘N/record’,… Continue reading Updating Sales Order New Tax Group on Line Level Using Map/Reduce Script
Customizing the Summary Box on Sales Order in NetSuite
Introduction Customizing the summary box on a sales order in NetSuite can enhance the user experience by displaying relevant information in a clear and concise manner. This article explains how to customize the summary box using JavaScript to manipulate the DOM elements. Steps to Customize the Summary Box Access the Totalling Table: let totallingTable =… Continue reading Customizing the Summary Box on Sales Order in NetSuite
Using Global Variables with Cache Module in Map/Reduce Script
Introduction In Map/Reduce scripts, managing data efficiently is crucial for performance. One way to optimize data handling is by using global variables with the cache module. This article explains how to implement this in your Map/Reduce scripts. What is a Global Variable? A global variable is a variable that is accessible throughout the entire script.… Continue reading Using Global Variables with Cache Module in Map/Reduce Script