-
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…
-
New to NetSuite | SuiteQL Advanced Queries: NVL2
In New to NetSuite | SuiteQL Overview and New to NetSuite | Understanding SuiteQL Syntax articles, we explored the fundamental concepts, capabilities, and structure of SuiteQL. SuiteQL Syntax for Advanced Queries goes beyond simple selections and joins to deliver robust, flexible, and analytical queries within database.…
-
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…
-
New to NetSuite | N/record: Column.type Property
In our previous article, New to NetSuite | Understanding SuiteScript 2.x Modules, we explored the SuiteScript Modules and N/record module, New to NetSuite | N/record Module Overview, which is used to interact with records. Now, we will take a closer look at one of the members of N/record: Column.type Property. The…
-
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…
-
New to NetSuite | SuiteQL Advanced Queries: NVL
In New to NetSuite | SuiteQL Overview and New to NetSuite | Understanding SuiteQL Syntax articles, we explored the fundamental concepts, capabilities, and structure of SuiteQL. SuiteQL Syntax for Advanced Queries goes beyond simple selections and joins to deliver robust, flexible, and analytical queries within database.…
-
Extracting Legacy Tax Code data via REST Web Services
Hi all, I'm trying to extract legacy tax code data using REST Web Services. What's the correct record/table name for this? If it is not possible to use REST web services, what is the alternate option? Thanks!
-
New to NetSuite | NetSuite AI Connector Services Overview
The NetSuite AI Connector Service lets supported external AI clients connect to NetSuite through the Model Context Protocol, also known as MCP. MCP helps improve integration capabilities and enables secure interactions between AI models and data systems. With the NetSuite AI Connector Service, supported AI clients can…
-
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…
-
New to NetSuite | N/record: Field.label Property
In our previous article, New to NetSuite | Understanding SuiteScript 2.x Modules, we explored the SuiteScript Modules and N/record module, New to NetSuite | N/record Module Overview, which is used to interact with records. Now, we will take a closer look at one of the members of N/record: Field.label Property. The…