-
EBOOK: Top Tips for NetSuite Admins
Whether you’re a new or an experienced NetSuite administrator, we’re always looking for ways to work more efficiently. Download this ebook to discover best practices for top administrator tasks, including: Defining user roles and permissions Maintaining data integrity Creating and publishing personalized dashboards This…
-
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 | Why You Should Avoid Assigning Standard Roles Directly
Standard NetSuite roles provide a strong foundation for user access, but assigning them directly can create future administration challenges. Because standard roles cannot be modified, any changes to permissions, restrictions, forms, or reporting requirements require administrators to create a new custom role and reassign…
-
NetSuite Admin Tip | Why a Revenue Arrangement May Not Appear on an Invoice’s Related Records
As a NetSuite administrator, you may be asked to investigate why a Revenue Arrangement does not appear under an Invoice record’s Related Records > Revenue Arrangements subtab, even though the same Invoice is visible from the Revenue Arrangement’s Related Records subtab. At first, this may look like a missing relationship,…
-
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…
-
NetSuite Admin Tip | Error while viewing Revenue Arrangement Record
When a sales transaction (such as Sales Order, Invoice, etc) is approved and a Revenue Arrangement is created, the user is unable to view or open the Revenue Arrangement record. An error message appear when the user attempts to access the record. Why does this happen? By default, no Revenue Arrangement form is marked as…
-
Transaction Line Distribution > Bill > No Journal Entry Generated
Concern: A Bill transaction is not generating a Distribution Related Journal Entry. The Distribution Related Journal field remains blank. Expected Result: A journal entry should be generated and displayed in the Distribution Related Journal field on the Bill. Steps to Reproduce Open a Bill transaction. Verify that the…
-
Financial Reports > List of all Title and Internal IDs
User wants to get the list of the reports in their account with the Internal IDs and the Title. To do this, follow steps below: Log in as Administrator Go to Lists > Search > Saved Searches > New Click Report Name your Saved Report Search Go to Results tad and add the following: * Title * Owner * Internal ID * Report Type…
-
NetSuite Admin Tip | Verify a Column's Parent Sublist Using SuiteScript
Organizations often develop reusable SuiteScript libraries to support multiple transaction types and record customizations. When processing sublist data, it's important to verify that a retrieved column belongs to the expected sublist before performing line-level operations. Using Column.sublistId helps make scripts more…
-
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…
-
NetSuite Admin Tip | Standardize NFP Financial Reports for Consistent Reporting
Nonprofit organizations rely on accurate financial reports to support board meetings, grant reporting, audits, and internal decision-making. While NetSuite provides standard nonprofit (NFP) financial reports, administrators play an important role in ensuring these reports are configured consistently across the…
-
NetSuite 2026.2 Feature Spotlight: Bulk Import for Advanced Pricing Records
The NetSuite 2026.2 release introduces a valuable enhancement for organizations using Advanced Pricing—support for importing Price Rules and Price Rule Entries through the CSV Import Assistant. Previously, these records could only be created individually, making large pricing updates and data migrations both time-intensive…
-
NetSuite Admin Tip | Improve Timesheet Accuracy with These 5 Administrative Best Practices
Timesheets are more than just a way for employees to record hours. They drive project costing, customer billing, payroll, resource planning, and business reporting. When timesheets are incomplete or inaccurate, the effects can ripple across multiple departments. Whether you are implementing Time Tracking for the first time…
-
Sneak Peek | Bulk Importing Units Type Records via CSV in NetSuite 2026.2
From the 2026.2 release preview notes—not live yet. When? Expected ~September 2026 (phased rollout—check your New Release portlet for your account's date). What's changing: Right now, unit types and their units have to be created one at a time. In 2026.2, you'll be able to bulk-import them via CSV, including all units for…
-
NetSuite Admin Tip | Inspect Customer Record Fields in SuiteScript
As a NetSuite Administrator, you may occasionally need to inspect the metadata of fields on a Customer record while troubleshooting customizations, validating configurations, or verifying field properties. Rather than checking each field manually through the UI, you can use the getField() method to retrieve a Field object…
-
NetSuite Admin Tip | Rank Employees by Expense Limit Using SuiteQL
Managing Employee Expense policies often requires identifying who has the highest spending authority within your organization. With SuiteQL function, you can quickly rank Employees based on their assigned Expense Limits, making it easier to audit approvals, review policy compliance, or analyze expense management…
-
France E-Invoicing & E-Reporting (2026–2027): What’s Changing and How to Comply in NetSuite
France E-Invoicing & E-Reporting (2026–2027): What’s Changing and How to Comply in NetSuite France is making structured electronic invoicing and electronic reporting mandatory for business transactions over 2026 and 2027. If your company trades in France, or operates a French subsidiary, this will change how you issue,…
-
NetSuite Admin Tip: Sales Order Line Level Location is Not Defaulting from Items' Preferred Location
In the Item Record > Purchasing/Inventory tab > Locations subtab > Preferred Location field, users can set the location that they want to default on the Sales Order line when the item is added to an order. However, there might be a scenario that this location is not being automatically set on the Sales Order line Aside…
-
NetSuite Admin Tip | Difference Between Sublist Column Labels & Line Values in SuiteScript
When working with transaction records, it is common to inspect fields on the Item sublist of a Sales Order. One area that can cause confusion is the difference between column metadata and the actual value stored on a transaction line. For example, the item column on the Sales Order item sublist has a label such as Item.…
-
NetSuite Admin Tip | Can Expense Accounts Be Assigned Based on Employee and Expense Category?
When configuring expense reporting in NetSuite, organizations may encounter situations where the same type of expense needs to be posted to different General Ledger accounts depending on the employee submitting the expense. A common example is fuel or gas expenses, where some employees' expenses should be charged to…
-
NetSuite Admin Tip | Ranking Customer Invoices by Amount with SuiteQL
As a NetSuite Administrator, you may need to quickly identify the largest Invoices for each Customer. This can be useful for reviewing high-value transactions, supporting collections analysis, preparing customer reporting, or validating invoice activity. In this article, we use SuiteQL to rank Customer Invoices by Invoice…
-
Understanding and Resolving the Error: “The customer part code already exists for this customer..."
When working with Customer Part Numbers, users may encounter the following error while adding a Customer Part Number to an item record: “The customer part code already exists for this customer. Enter another code or select another customer.” Why This Error Occurs: A Customer Part Number can only be associated with a…
-
NetSuite Admin Tip | Understanding Available Without Login in the File Cabinet
The Available Without Login setting in the NetSuite File Cabinet is one of the most misused file access controls. While it is essential for websites, images, and online forms, incorrect usage can unintentionally expose files externally. This article explains how the setting works, when to use it, and the risks…
-
NetSuite Admin Tip | How to Audit User Roles and Permissions Effectively
Managing user access is one of the most important responsibilities for NetSuite administrators. Over time, roles can accumulate unnecessary permissions, creating security risks, segregation-of-duties concerns, and reporting inconsistencies. This article reviews practical ways administrators can audit roles and permissions…
-
NetSuite Admin Tip | Audit Available Sales Order Forms Using SuiteScript
When working with transactions, Administrators often need to confirm which custom forms are available to users on a record. This is especially useful when troubleshooting role permissions, form restrictions, transaction form setup, or unexpected form behavior on Sales Orders. One practical way to inspect available form…
-
NetSuite Admin Tip | Find Each Customer’s 3 Most Recent Sales Orders with SuiteQL
NetSuite Administrators often need a quick way to review recent Customer activity, especially when working with Sales Orders. While Saved Searches are useful for many reporting needs, SuiteQL gives admins more flexibility when they need to rank, filter, and return a specific number of records per group. A common example is…
-
NetSuite Admin Tip | Quickly Audit Customer Emails Using SuiteScript
Maintaining accurate customer email data is more important than it seems. Whether you are sending invoices, running marketing campaigns, or supporting integrations, missing or incorrect email addresses can lead to failed communications and operational issues. While Saved Searches are great, there are times when admins need…
-
NetSuite Admin Tip | Use Custom Lists to Reduce Typing Errors
Free-form text fields can be useful, but they also allow users to enter the same value in different ways. This can create reporting issues, duplicate values, and extra cleanup work. Custom lists help reduce typing errors by giving users a controlled set of values to choose from. Scenario A team needs users to select a…
-
NetSuite Admin Tip | Create Saved Searches for Customization Reviews
Saved searches can help admins review and monitor customizations more efficiently. When an account has many custom fields, custom records, forms, workflows, or scripts, saved searches can make it easier to identify what exists, what is active, and what may need further review. Using saved searches for customization reviews…