Fulfillment requests can have one of the following statuses: Updating Fulfillment Request Status in NetSuite via SuiteScript To update the status of a Fulfillment Request, use the transtatus field record.setValue({ fieldId: ‘transtatus’, value: ‘B’ // ‘B’ typically represents “Pending Fulfillment” });
Category: NetSuite ERP
NetSuite ERP
Managing Sales Team Members in NetSuite
Sales Team Members play a key role in tracking sales and managing customer relationships. This feature helps organizations define who is responsible for what within the sales process. What is a Sales Team Member? A Sales Team Member is anyone in the sales process, including Primary, Secondary, or Tertiary roles. The Primary Sales Rep is… Continue reading Managing Sales Team Members in NetSuite
Inventory Inactivity & Obsolescence report
Requirement: We need a reliable way to measure how long items have been sitting without movement at each location. The default aging report in NetSuite has helped us get part of this visibility, but it does not pull last movement dates or values accurately enough. We’re requesting an Inventory Inactivity & Obsolescence report that shows,… Continue reading Inventory Inactivity & Obsolescence report
RESTlet Script
Retslets are activate when external application calls it get, put, post, delete requires authorization Restlet entry points post-create put-update get, delete -parameters is sent through url function get(requestParams) requestParams is form external apk tba ceate a new role give permissions assign the role to user creaye an integration record create… Continue reading RESTlet Script
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
AI Innovations in NetSuite 2025.2
In the latest NetSuite 2025.2 release, Oracle has embedded AI more deeply into the platform, focusing on planning, financial close, compliance, and global collaboration. The new AI features are designed to reduce manual effort, surface insights automatically, and help leaders make faster, more confident decisions. 1. AI‑Powered Planning & Forecasting Embedded AI in Planning and… Continue reading AI Innovations in NetSuite 2025.2
Grab Link in case record
For getting this Grab functionality, we need to check the checkboxes in the employee record Creating a group – List – Relationship – group Use this employee as the assignee in the case record When left click on the Grab link, it is assigned to ourselves.
Create a transaction saved search to fetch the document number of invoice and IF
1. Navigate to List > Search > Saved Searches > New 2. Click Transaction 3. Search Title: Enter Title 4. Click Criteria tab Select Type as ‘Sales Order’ 5.In the Results tab, Select Formula(Numeric) Formula: CASE WHEN {applyingtransaction.type} = ‘Invoice’ THEN {applyingtransaction.number} ELSE NULL END Provide label as Invoice# To get invoice date, Select Formula(Numeric) Formula: CASE… Continue reading Create a transaction saved search to fetch the document number of invoice and IF
SuiteQL for Retrieving Notes Attached to a Transaction
When working with transactions in NetSuite, it’s often important to access the notes associated with them—especially for audit trails, collaboration, or historical context. These notes are stored in the TransactionNote table and can be retrieved using a simple SQL query. ✅ Sample Query to Retrieve Transaction Notes SELECT TO_CHAR(TransactionNote.NoteDate, ‘YYYY-MM-DD @ HH12:MI PM’) AS NoteDate,… Continue reading SuiteQL for Retrieving Notes Attached to a Transaction
Swagger in the Context of API Testing
What is Swagger in the Context of API Testing? Swagger, now primarily known as the OpenAPI Specification (under the OpenAPI Initiative), is an open-source framework for describing, documenting, and testing RESTful APIs. It uses a machine-readable YAML or JSON format to define API endpoints, parameters, request/response schemas, and security schemes. In testing, Swagger excels at… Continue reading Swagger in the Context of API Testing