NetSuite expects the first transaction in an item’s history (especially for lot-numbered items) to be an Inventory Revaluation. This sets the initial value of the inventory. However, if another transaction—like a receipt, adjustment, or transfer—is dated before the revaluation (even if added later or edited), NetSuite throws this error: INVENTORY_REVALUATION_IS_NOT_THE_FIRST_TRANSACTION_IN_THE_ITEM_HISTORY_ERROR_MSG When creating an Inventory Adjustment… Continue reading Inventory Cost Revaluation Record
Author: Linu Paul
POWER BI Connectivity
There are primarily two effective methods to establish the Power BI connection: 1. Using SuiteAnalytics Connect (ODBC Method) The SuiteAnalytics Connect Service enables you to archive, analyze, and report on NetSuite data using external tools like Power BI. It supports ODBC, JDBC, and drivers, compatible with Windows, Linux, or macOS environments. Important: This service is… Continue reading POWER BI Connectivity
Automate LI Ship Date for E-commerce Sales Orders
Proposal Summary This proposal outlines the scope and approach for implementing a NetSuite customization that automates the population of both the body-level Ship Date and the line-level Estimated Ship Date (EST. Ship Date) on Sales Orders identified as e-commerce. The goal is to streamline order processing and ensure consistent, calendar-aware shipping commitments. The logic will… Continue reading Automate LI Ship Date for E-commerce Sales Orders
Duplicate Cases are created when we click ‘Submit’ button again and again
Go to: Customization → Forms → Entry Forms or Transaction Forms Edit the Form used in the Online Case/Feedback submission Under “Custom Code” section: Set the Client Script to your deployed script Save the form /** *@NApiVersion 2.1 *@NScriptType ClientScript */ define([‘N/search’, ‘N/ui/dialog’], function (search, dialog) { function pageInit(context) { const form = document.querySelector(‘form’); const… Continue reading Duplicate Cases are created when we click ‘Submit’ button again and again
Purchase Request Approval – Employee Centre role
If you use the Approval Routing feature for purchase approvals, purchases must be approved before they can be processed. Purchase approvals are generally processed through the Employee Center. You must have the Employee Center role to access the Employee Center. An administrator can add the Employee Center role on your employee record. If your company… Continue reading Purchase Request Approval – Employee Centre role
PROPOSAL FOR TRANSFER ORDER INTEGRATION IN WEB APP
Proposal Summary This proposal outlines the integration of Transfer Order Management into the existing web app, allowing delivery personnel to efficiently track and confirm deliveries of transfer orders. The proposed solution will also automate the creation of Item Receipts in NetSuite, ensuring seamless synchronization between the web app, Firebase, and NetSuite. The integration will focus… Continue reading PROPOSAL FOR TRANSFER ORDER INTEGRATION IN WEB APP
LTL Carrier and Tracking Details
We can create a custom record to store tracking details with the following fields: Carrier (List/Record) Tracking Number (Text) Tracking Link (Long Text / URL) Item Fulfillment (List/Record) Sales order (List/Record) Points to consider in record creation: The Item Fulfillment and Sales Order fields should be marked as “Record is Parent” to appear as sublists… Continue reading LTL Carrier and Tracking Details
Payment Record – VOID button
User event Trigger for Void action of Transaction in NetSuite VOID actions do not have a dedicated execution context, meaning they are not explicitly supported in user event scripts. When a transaction is voided, scripts designed to run on the EDIT action may still trigger, potentially causing unexpected behavior for VOID actions. To prevent unintended… Continue reading Payment Record – VOID button
Created new Admin role cannot log in while assigning it to an employee.
The permission below needs to be removed. SAML Single Sign-on
Steps to Configure the Celigo Flows
Steps to Configure the Flows: Enable the new GraphQL flows. Re-authorize the Shopify connection: Once GraphQL flows are enabled, the Shopify connection needs to be reauthorized. This step must be completed by the client using the Celigo Account Owner and Shopify Store Owner logins. Recreate custom mappings: We have identified that custom mappings are currently… Continue reading Steps to Configure the Celigo Flows