-
NetSuite Admin Tip | A Script Needs Admin-Controlled Values: How to Use Script Parameters
When a script uses values that may change over time, it is usually better to control those values through script parameters instead of hardcoding them directly in the script. Script parameters allow administrators to update certain script values from the script deployment without editing the script file. Scenario A script…
-
NetSuite Admin Tip | Inspect Customer Field Types and Values with SuiteScript
When preparing a Customer onboarding workflow, an administrator at a growing distribution company needed to confirm which Customer fields held usable data before building saved searches, workflows, and integrations. For example, the Customer Status field stored an internal ID, while users saw a readable status name. Script…
-
NetSuite Admin Tip | Managing Blank PO Numbers and Memos in Sales Orders Using SuiteQL
Sales Order reports are commonly used across the company by sales operations, customer service, finance, and order management teams to support day-to-day order processing. These teams may need to quickly review the Sales Order number, Customer, Customer PO Number, and Memo when validating orders, responding to customer…
-
NetSuite Admin Tip | Inspect Item Sublist Field Types in Sales Order Using SuiteScript
When developing SuiteScript solutions, integrations, or troubleshooting transaction records, it is often necessary to determine the data type of a sublist field. Knowing whether a field is a select, checkbox, currency, float, or another type helps you write more reliable scripts and avoid runtime errors. This example…
-
NetSuite Admin Tip | Classify High-Value Sales Orders Using SuiteQL
As a NetSuite Administrator, you may be asked to quickly identify high-value sales orders for executive reporting, finance review, or approval workflows. Rather than manually filtering transaction lists, you can use SuiteQL to automatically categorize sales orders based on their transaction amount. This approach is useful…
-
NetSuite Admin Tip | Retrieve Field Labels and Values Using SuiteScript
Suppose your company wants to review customer information before integrating it with an external CRM or performing data validation. Instead of manually checking each field in the NetSuite UI, you can use SuiteScript to automatically retrieve and log important customer fields along with their labels and values. Sample Usage…
-
NetSuite Admin Tip | Enable the SuiteTax Engine for Subsidiary Nexuses
During SuiteTax setup, administrators may find that the tax engine is not available for assignment on a subsidiary nexus. This can happen even when SuiteTax is enabled, the SuiteTax Engine bundle is installed, and transaction migration is complete. For admins, the issue may appear to be related to the nexus configuration,…
-
NetSuite Admin Tip | Find Active Inventory Items Never Used on a Sales Order Using SuiteQL
Over time, unused inventory items can accumulate due to discontinued products, testing, customer-specific requests, or changing business requirements. While these items remain active, they can clutter your item master and make inventory management more challenging. Identifying inventory items that have never appeared on a…
-
New Feature: Passkey Login in NetSuite
NetSuite now supports passkeys as a passwordless alternative to logging in with a password. This applies to all users in all roles on our account. There are two types of passkeys: Physical - a piece of hardware, like a USB security token. Digital - typically via biometrics such as fingerprint or Face ID on a device (this…
-
NetSuite Admin Tip | Find Customers Who Have Purchased a Specific Item Using SuiteQL
Whether you're preparing a targeted marketing campaign, identifying customers for product upgrades, or analyzing purchasing trends, knowing who has purchased a specific item is a common reporting requirement. SuiteQL provides a flexible and efficient way to retrieve this information directly from the database. SuiteQL…