When working with saved searches in Map/Reduce (M/R) scripts, developers often encounter a frustrating issue: multiple formulatext columns in the saved search result get collapsed into a single key in the mapContext.value object. This happens because NetSuite uses the column type (e.g., formulatext) as the key, and if multiple columns share the same type without… Continue reading Handling Duplicate formulatext Keys in Map/Reduce Scripts in NetSuite
Author: Jasmine Jacob
Proposal for Wirelo-NetSuite Integration
Proposal Summary This proposal outlines the implementation of a secure and scalable integration between Wirelo and NetSuite ERP to automate the synchronization of orders, products, and tracking details. The solution will ensure: All orders created in Wirelo are imported into NetSuite as Sales Orders. Product catalogs between Wirelo and NetSuite are kept synchronized. Tracking information… Continue reading Proposal for Wirelo-NetSuite Integration
Remove Standard Center Tabs for Roles
Some Standard Center Tabs can be removed for Custom and Standard Roles. If the “Set Up Custom Tab” link can be seen under Center Tab Overview, then this Tab can be removed for a Role. 1. Navigate to Setup > Users/Roles > Manage Roles. 2. Customize the Role and note the Center Type. 3. In Permissions tab > Setup subtab > set Custom Center… Continue reading Remove Standard Center Tabs for Roles
Deduplicating Customer Records in NetSuite Using SuiteScript
In any business, managing customer records efficiently is crucial for maintaining data integrity and optimizing operations. However, duplicate customer records can lead to confusion, errors, and inefficiencies. In NetSuite SuiteScript provides powerful tools to automate tasks and streamline processes. One such tool is the task.TaskType.ENTITY_DEDUPLICATION function, which can be utilized within scripts to deduplicate customer… Continue reading Deduplicating Customer Records in NetSuite Using SuiteScript
SOAP Web Services endpoint release and support policy changes
If you are only using Oracle NetSuite solutions which are developed, owned and maintained by Oracle NetSuite, such as NetSuite Connector, NSPOS, or SuiteProjects Pro, no further action is needed. Starting with the NetSuite 2026.1 release, Oracle NetSuite will no longer provide a SOAP web services endpoint with each release. New SOAP endpoints will be… Continue reading SOAP Web Services endpoint release and support policy changes
Prerequisites for Installing Saudi Arabia E-Invoicing
Before installing the Saudi Arabia e-Invoicing SuiteApp, you must complete the following: Register with the Saudi Arabian Taxation Portal (ERAD). You must be registered as a taxpayer in Saudi Arabia and must have a valid value-added tax (VAT) registration number. Install the Electronic Invoicing SuiteApp. For more information, see Installing and Setting Up Electronic Invoicing.… Continue reading Prerequisites for Installing Saudi Arabia E-Invoicing
N/cache Module
Use the N/cache module to enable temporary, short-term storage of data. Using a cache improves performance by eliminating the need for scripts to repeatedly retrieve the same piece of data. You can use this module to build a cache to store and retrieve string values using a specific key. You can create a cache that… Continue reading N/cache Module
Browser Extensions
NetSuite: Show Field IDs This helpful extension will allow you to instantly locate a field on a NetSuite record. Simply type, CTRL + SHIFT + F to locate the field by the internal ID. Use CTRL + SHIFT + L to find a field by the label. This will even work across different tabs and… Continue reading Browser Extensions
Tips to use NetSuite
Reports and Searches Web queries allow admins to share many reports with colleagues that don’t have a NetSuite license. Navigate to the Report, click Customize and under the More Options tab, click the box for Allow Web Query. You can export the report to Excel and, once saved, the report will refresh with the latest… Continue reading Tips to use NetSuite
Keyboard Shortcuts in NetSuite
Keyboard Shortcuts 1. When inputting a date, type “t” in the box to autofill with today’s date. 2. Type “y” to autofill with the previous day’s date. 3. Press “Shift + t” to autofill with the following day’s date. 4. Type “m”to autofill with the final day of the current month. 5. To reach the global search bar, press “Alt… Continue reading Keyboard Shortcuts in NetSuite