-
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…
-
Generic "Unexpected error has occurred" when saving Customer Refund — anyone seen this?
Hi all, I'm running into a recurring issue in a test/training NetSuite account and wanted to check if anyone else has come across this. When attempting to save a Customer Refund record, the system doesn't complete the save. Instead it returns a generic error page: Error : "An unexpected error has occurred. Please click…
-
NetSuite Admin Tip | Use Reversing Journal Entries as a Best Practice for Posted Adjustments
When a journal entry has already been posted and needs to be corrected or offset, administrators should consider using a reversing journal entry rather than removing the original transaction. NetSuite supports reversing journal entries specifically for reversing ledger entries that have already posted to accounts. A…
-
NetSuite Admin Tip | Separate Admin Fields from User Entry Fields
As customizations grow, forms can become crowded with fields used for different purposes. Some fields are meant for users to complete during data entry, while others are used by admins, workflows, scripts, reporting, or review processes. Separating admin fields from user entry fields can make forms easier to use and easier…
-
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 | Improve Bank Reconciliation Matching with the new 3-Day Rule
NetSuite Admin Tip | Improve Bank Reconciliation Matching with the new 3-Day Rule Bank transactions and General Ledger transactions do not always carry the exact same date. Processing times, bank posting schedules, weekends, and other timing differences can cause a transaction to appear in NetSuite a few days apart from…
-
NetSuite–Coupa Integration: Implementation, Bundle & Integration Support
Discussion Title: NetSuite–Coupa Integration: Implementation, Bundle & Integration Support Hello NetSuite Community, We’re Flowtaris, and we work with organizations on NetSuite and Coupa integration, implementation, enhancement, and ongoing support. We’d be happy to connect with community members who are working on…
-
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…
-
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…