Keeping your Customer database current is essential for maintaining accurate records and supporting efficient business operations. Over time, some Customers may become inactive, no longer placing orders, or engaging with your company. Instead of manually reviewing each record, you can automate this process using a Scheduled Script. This script uses the N/search and N/record modules… Continue reading Customer Inactivity Detection and Status Change via SuiteScript
Category: NS Administration
All articles / code related to Netsuite administration
Item Doesn’t Appear in Vendor Credit Transaction
A client recently reported that a specific item was not appearing in a Vendor Credit transaction. They had already verified key configuration details such as the subsidiary, location, and other relevant fields. Despite this, the item remained absent from the Vendor Credit form. Upon reviewing the item setup, it was discovered that the item in… Continue reading Item Doesn’t Appear in Vendor Credit Transaction
How to create Access Tokens for Administrator role
In NetSuite, we cannot create an Access token from the Navigation: Setup → Users/Roles → Access Tokens → New Instead of this, if the user trying to create has an Admin role, he/she can create an Access Token from the Home Page, using the Manage Access Tokens
Generating HAR File on Edge
Press F12, Ctrl+Shift+I or go to More tools>Developer tools. The following window will open: Go to settings by clicking the Settings button or pressing F1. Under Global settings check Auto-open Dev tools for popups. Go to Network Tab, and Click the Clear button to clear out any existing logs from the Network tab. Press the play button at the top left to start recording. Reproduce the issue. After you have… Continue reading Generating HAR File on Edge
Ensure Sales Tax Applies After Adding New Nexus States
When expanding into new states, it is standard practice to set up additional sales tax nexus locations in your system. After importing the relevant state tax codes and groups (SAID: 8045 Importing the State Sales Tax Table), everything may seem correctly configured. However, if tax still is not applying on transactions, there is one commonly overlooked step: assigning… Continue reading Ensure Sales Tax Applies After Adding New Nexus States
standard numbering for the chart of accounts
Ensure the ‘Use Account Numbers‘ preference is enabled. This will automatically associate four-digit account numbers with existing accounts. (Go to Setup > Accounting > Accounting Preferences > General > Use Account Numbers box) Assign account numbers that are alphanumeric, with a maximum of 60 characters. The first digit should be any number from 1 to 8,… Continue reading standard numbering for the chart of accounts
Options for Business Intelligence for CFO
There are primarily two effective methods to establish this 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 read-only—you cannot… Continue reading Options for Business Intelligence for CFO
Resolving the “This line has been marked shipped. This line cannot be received” Error
Issue: While trying to receive items in a Purchase Order, users encountered the following error: This line has been marked shipped. This line cannot be received Solution: The mentioned purchase order is a drop ship purchase order. Drop ship orders are handled differently from regular purchase orders. If you mark items as shipped and then… Continue reading Resolving the “This line has been marked shipped. This line cannot be received” Error
Getting the List of Customer Statuses
In NetSuite, each customer record is assigned a status—such as Qualified, Close Won, or Renewal—based on their position in your sales pipeline. These statuses are stored internally using numerical IDs, which can be unclear when building reports or SuiteQL queries. To help with this, you can use the SuiteQL query below to generate a list of customer statuses. It allows you to easily… Continue reading Getting the List of Customer Statuses
Benefits of Using External ID While Uploading Transaction Data in NetSuite
When you’re importing transactions like vendor bills or customer invoices in NetSuite, using an External ID can make the process much smoother. Here’s how it helps: Group Multiple Lines into One Transaction If a bill or invoice has many lines, giving all those lines the same External ID tells NetSuite they belong to one transaction.… Continue reading Benefits of Using External ID While Uploading Transaction Data in NetSuite