-
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…
-
Formula for excluding non-summary inactive COA
We usually use datasets instead of saved searches for COA export as several fields like ‘Eliminate Intercompany transactions’ and ‘Reconcile bank statements’ options are not available in Saved Searches. While preparing the dataset, we cannot directly put the criteria as exclude inactive as the inactive accounts include…
-
NetSuite Admin Tip|Manage Shared Resources More Effectively w/Resource Records & Calendar Preference
Administrators often need a simple way to manage shared resources such as conference rooms, equipment, or shared service areas. In NetSuite, resource records can be used on events so users can reserve a resource while scheduling activities. After a resource is created, administrators can also maintain its calendar…
-
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 | Sensitive Information Notices for Imported Bank Data in 2026.2
In NetSuite 2026.2, Administrators should pay close attention to the new notices shown during bank data import. The update highlights that imported bank transaction memo fields may contain sensitive information, including bank account numbers, credit card numbers, and addresses. This is an important reminder for admins who…
-
Netsuite Access for new employees not logging in
Hi Admin help, We gave netsuite access and allowed Employee Center role added to the user. But, access is denied for the role message is popping out. Can you help us.
-
Resolution of error when trying to change General Preference Date format
Scenario: When we try changing the short date format to ‘DD-Mon-YYYY’ and long date format to ‘DD Month YYYY’, the preference reverts to default on saving. We were abe to set the option in Set Preferences but not in General Preferences. We tried using different browsers and all the users are facing this issue. We also…
-
NetSuite Financial topics – CTA, Exchange rate Gain/Loss
Currency Translation Adjustment (CTA) CTA is meant to reflect currency fluctuations during consolidation. For example, if the Indian subsidiary (base currency INR) has ₹1,00,000 in retained earnings and the INR-USD rate changes from 83 to 85, NetSuite calculates the translation difference during consolidation and posts a…
-
MTD For UK Tax
Requirement understanding We need to remit VAT to the UK government. For UK VAT‑registered entities, Making Tax Digital (MTD) requires businesses to keep VAT records digitally, prepare VAT Returns (VAT100), and submit VAT returns digitally via the VAT (MTD) API. NetSuite supports this capability natively through the…
-
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 | 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…