Suite scripts samples – knowledgebase JJ

REST API for updating an RMA by PATCH method

Scenario: if a user needs to update the RMA record, we can use the method ‘PATCH’ in RESTLET. Method: PATCH End point URL: https://[account id].suitetalk.api.netsuite.com/services/rest/record/v1/returnAuthorization/[RMA record id] sample: https://123456-sb1.suitetalk.api.netsuite.com/services/rest/record/v1/returnAuthorization/123 Request body: { “item”: { “items”: [ { … Continue reading REST API for updating an RMA by PATCH method

Accessing Record Data in a Suitelet Without Passing Parameters

When working with Suitelets in NetSuite, a common approach to pass data from a record to a Suitelet page is by sending it through URL parameters. However, there are situations where you might not want to expose data in the URL or you simply want a cleaner approach. Luckily, there’s a way to access record… Continue reading Accessing Record Data in a Suitelet Without Passing Parameters

suiteQL query to get invoices by a date range

The SuiteQL query below returns all customer invoices issued in the past 30 days. SELECT Transaction.ID AS Invoice, Transaction.TranID AS InvoiceNumber, Transaction.TranDate AS InvoiceDate, Transaction.Entity AS Customer, BUILTIN.DF( Transaction.Entity ) AS CustomerName, Transaction.OtherRefNum AS CustomerPONumber, TransactionLine.CreatedFrom AS SalesOrder, BUILTIN.DF( TransactionLine.CreatedFrom ) AS SONumber, Transaction.Employee AS SalesRep, BUILTIN.DF( Transaction.Employee ) AS SalesRepName, Transaction.ForeignTotal AS TotalAmount, REPLACE(… Continue reading suiteQL query to get invoices by a date range

REST API for Updating an Existing RMA

If a user wants to update an RMA record using the REST API, use the following for that: The API type: PATCH Endpoint URL: https://[Account ID].suitetalk.api.netsuite.com/services/rest/record/v1/returnAuthorization/[Internal ID of the RMA record] Request body: { “item”: { “items”: [ { … Continue reading REST API for Updating an Existing RMA

Await, Without the Wait

await lets you pause inside an async function until a Promise settles, so async code reads like clear, top-to-bottom logic. It doesn’t block the thread; it yields to the event loop and resumes with the result (or throws on rejection). Advantages Clear, readable control flow (less callback/promise chaining) Centralized error handling with try/catch/finally Easier testing… Continue reading Await, Without the Wait

RENDER ADVANCED PDF VIA SUITELET

define([‘N/record’, ‘N/render’, ‘N/search’], (record, render, search) => { “use strict”; const TEMPLATE_MAP = { salesorder: ‘CUSTTMPL_JJ_SO_HIDE_LINE_ITEM_STBUK154’, estimate: ‘CUSTTMPL_JJ_QUOTE_HIDE_LINE_ITEM_STBUK154’, invoice: ‘CUSTTMPL_JJ_INV_HIDE_LINE_ITEM_STBUK154’, itemfulfillment: ‘CUSTTMPL_JJ_IF_HIDE_LINE_ITEM_STBUK154’ }; /** * Searches and maps SO… Continue reading RENDER ADVANCED PDF VIA SUITELET

How to Check if Inventory Detail is Assigned in NetSuite

When working with item sublists in NetSuite, it’s often necessary to validate whether an Inventory Detail has been assigned to a transaction line. This can be achieved by retrieving the inventorydetail subrecord and checking its assignments. let inventoryDetail = newRecord.getSublistSubrecord({ sublistId: ‘item’, fieldId: ‘inventorydetail’, line: line }); // Check if Inventory Detail is assigned let… Continue reading How to Check if Inventory Detail is Assigned in NetSuite

Utilizing TimeZone in the N/Format module Effectively

We are using the format module to convert dates into a standardized string format. First, we parse the date using format.parse(), and then format it using format.format(). When dealing with time values, we plan to apply the timezone. However, we need to know where to use the timezone so that it does not affect the… Continue reading Utilizing TimeZone in the N/Format module Effectively

suitescript Replace transaction SKUs without affecting transition total

const updateTransaction = (transactionId, valueArray) => { try { let transactionRecord = record.load({ type: RECORD_TYPE[valueArray[0][“Type”]], id: transactionId, … Continue reading suitescript Replace transaction SKUs without affecting transition total

REST API for Fetching the list of Locations from the account

The REST API details for fetching the locations list from the NetSuite account, we use the SQL query, and the details for that are given below: The API type: POST Endpoint URL: https://359045-sb1.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql Request body: { “q”: “SELECT * FROM location WHERE location.isinactive = ‘F’” }