Requirement Power Pony required an automated solution to route sales orders to the correct warehouse (West Coast or East Coast) based on: SKU type (specific Power Pony items such as PP-PPU-4, PP-PWU-4, PP-PRW-4) Ship-To State (e.g., California → West Coast, New York → East Coast) The goal was to eliminate manual intervention, ensure accurate warehouse… Continue reading Automated Order Routing for Power Pony in NetSuite
Category: NetSuite ERP
NetSuite ERP
Exporting CSV from NetSuite Suitelet page with Client Scripts
/** * @NApiVersion 2.x * @NScriptType ClientScript * @NModuleScope SameAccount */ define([‘N/currentRecord’], /** * @param{currentRecord} currentRecord */ function (currentRecord) { const SUBLIST_ID = ‘custpage_report’; /** * Generates and downloads a CSV file containing data from… Continue reading Exporting CSV from NetSuite Suitelet page with Client Scripts
Unexpected Unrealized Gain/Loss Posted on Zeroed or Closed Accounts During Currency Revaluation
Scenario When an account has been zeroed out or closed in the subsidiary’s base currency—but contains transactions in a different currency—month-end currency revaluation may still post unrealized gain or loss amounts. NetSuite Support has reviewed this behavior and confirmed that it is expected system functionality. This situation occurs because, although the account’s displayed net balance… Continue reading Unexpected Unrealized Gain/Loss Posted on Zeroed or Closed Accounts During Currency Revaluation
Workaround for Subsidiary Bank Transfers Using Clearing Accounts
Scenario A user needs to transfer funds from a bank account to a different subsidiary. Solution Since the affected account is a Bank-type account, Enhancement #155077 – OneWorld: Allow Bank Transfers Between Subsidiaries applies. If this enhancement is not available, you may use the alternate solution below. Alternate Solution 1. Create a Clearing Account Navigate… Continue reading Workaround for Subsidiary Bank Transfers Using Clearing Accounts
Using NetSuite’s Internal remoteObject.bridgeCall API to Load Dataset Definitions
When working with NetSuite Analytics Datasets (Workbooks), it’s often necessary to retrieve the underlying dataset schema—fields, joins, aggregations, types, and metadata. NetSuite does not expose a public REST API for this; however, its internal client-side API allows you to load dataset definitions using the remoteObject.bridgeCall method. The getDatasetObject() function below demonstrates how to call this… Continue reading Using NetSuite’s Internal remoteObject.bridgeCall API to Load Dataset Definitions
Inbound shipment in amazon connector (NetSuite – Amazon integration)
Bundles Required in NetSuite To enable the integration, two bundles must be installed in NetSuite: Celigo integrator.io bundle Celigo Amazon Connector Types of Orders in Amazon Seller Central Amazon Seller Central classifies orders into three types, all supported by the Celigo Amazon bundle: Fulfilled by Amazon (FBA) Orders stored and shipped by Amazon from its… Continue reading Inbound shipment in amazon connector (NetSuite – Amazon integration)
Incoterm in Transfer Orders
In NetSuite, Incoterms (International Commercial Terms) are used in Transfer Orders to define the point of ownership transfer between locations—either at the time of shipping or receipt. Here’s a breakdown of how Incoterms work and how to configure them: Available Incoterms in NetSuite NetSuite supports two default Incoterms for transfer orders: Ex Works (EXW): Ownership… Continue reading Incoterm in Transfer Orders
Missing Submit button in Match Bank Data page
With the 2025.2 release, NetSuite introduced enhancements to the Match Bank Data page (referenced in the NetSuite 2025.2 Release Notes under the Banking section). As a result of these updates, the traditional “Submit” button is no longer present. The following changes have been made: The Review subtab now includes options to: Submit Selected transactions Undo Selected transactions… Continue reading Missing Submit button in Match Bank Data page
SAML Single Sign-on role permission
In NetSuite, the “SAML Single Sign-on” role permission allows users to log in using SAML-based Single Sign-On (SSO), which is an authentication method that enables users to access NetSuite through an external Identity Provider (IdP) like Okta, Azure AD, or OneLogin without entering separate NetSuite credentials. Key Points about the SAML Single Sign-on Permission: Purpose:… Continue reading SAML Single Sign-on role permission
Verify TDS Amount Page
The Verify TDS Amount page is designed to assist administrators in reviewing, comparing, and correcting TDS calculations. Through this feature, the SuiteApp enables users to search for vendor bills using filters such as subsidiary, vendor, fiscal period, and section code. It then performs an automatic calculation of the exact TDS that should have been collected… Continue reading Verify TDS Amount Page