Scenario The user wants to know the reason of automatic change in value of Printed Picking Ticket field in the System Notes of a Sales Order. Solution The value of the Printed Picking Ticket field on System Notes of a Sales order would change from F to T once the Picking Ticket is printed from the Sales Order. If the Sales Order is only partially fulfilled, the Printed Picking Ticket field would reset… Continue reading Reasons of Printed Picking Ticket Field Value Change on Sales Order’s System Notes
Category: NetSuite ERP
NetSuite ERP
Automated Location routing for Powerpony orders
Requirement: For some specified SKUs, and based on the ship state the Powerpony orders need to default to east cost and west cost locations. Solution: In the Celigo flow achieving this is not possible as adding complex conditions is not feasible. Hence we can add a server scripts to set the location values based on… Continue reading Automated Location routing for Powerpony orders
Create a Library Function
/** * @NApiVersion 2.x * @NScriptType Suitelet * @NModuleScope Public */ define([ ‘../Library.FHL.2.0.js’ , ‘N/record’ , ‘N/search’ ], function(Library, Record, Search) { /** * Initialise function for suitelet * * @param {Object} context * @return {Any} data */ … Continue reading Create a Library Function
Node.js code for making a POST API call to NetSuite using OAuth 1.0.
const axios = require(‘axios’); const CryptoJS = require(‘crypto-js’); const ACCOUNT_ID = ”; const ENDPOINT = “; const AUTH = { consumerKey: ”, consumerSecret: ”, token: ”, tokenSecret: ” }; function generateOAuthHeader(httpMethod, url) { try { const nonce = Math.random().toString(36).substring(2); … Continue reading Node.js code for making a POST API call to NetSuite using OAuth 1.0.
Joining Datasets in NSAW
Joining datasets in NetSuite Analytics Warehouse (NSAW) allows you to combine information from multiple sources into a single dataset for reporting and dashboards. When you add multiple record types, NSAW uses SQL-style joins to determine how the data relates. Inner Join Returns only the records that have matching values in both datasets. Best when you… Continue reading Joining Datasets in NSAW
Setting up Tax Deduction at Source (TDS) in NetSuite
Setting up Tax Deduction at Source (TDS) in NetSuite involves enabling the SuiteTax feature and installing the India Localization bundles to configure specific rules, rates, and vendor information. The process ensures accurate, automated TDS calculations and compliance with Indian tax regulations. Prerequisites Enable SuiteTax: This is the foundational tax engine in NetSuite needed for the… Continue reading Setting up Tax Deduction at Source (TDS) in NetSuite
Upcoming Change to the SuiteAnalytics Connect ODBC Driver [February 16, 2026]
The root certificate for the SuiteAnalytics Connect Service will be rotated on February 16, 2026. After this change, old versions of the Linux ODBC driver for SuiteAnalytics Connect will stop working. If you are using a Linux ODBC driver, upgrade your driver to version 8.10.181 and adjust the Truststore parameter before February 16, 2026. If you… Continue reading Upcoming Change to the SuiteAnalytics Connect ODBC Driver [February 16, 2026]
Suitelet Page: Using UI components
Sometimes we need to add some more features to the Netsuite built-in pages, but it has no customizable option. In this case, we usually create the Suitelet page the same as the Netsuite built-in page, but it’s sometimes complicated to make it the same as the origin, or it takes a lot of time or… Continue reading Suitelet Page: Using UI components
SuiteBundler
SuiteBundler is NetSuite’s native tool for packaging customizations, configurations, and scripts into reusable bundles. While developers often focus on SuiteScript or workflows, SuiteBundler quietly enables scalable deployment across accounts. It allows administrators to group saved searches, dashboards, scripts, and workflows into a single package that can be installed in other NetSuite environments. The least explored… Continue reading SuiteBundler
NetSuite OAuth 2.0 M2M (Client Credentials) Configuration Steps
Prerequisites Enable SuiteCloud > OAuth 2.0 in Setup > Company > Enable Features before starting. Role Permissions must match the scopes you intend to use. Please note: Only RESTlets, REST Web Services, and SuiteAnalytics Connect are supported. Steps for configuring Log in with Administrator role Ensure you have Administrator privileges to configure integrations. Create an… Continue reading NetSuite OAuth 2.0 M2M (Client Credentials) Configuration Steps