Joining datasets in NetSuite Analytics Warehouse (NSAW) allows you to combine information from multiple sources into a single dataset for reporting and dashboards. When you add multiple record types, NSAW uses SQL-style joins to determine how the data relates. Inner Join Returns only the records that have matching values in both datasets. Best when you… Continue reading Joining Datasets in NSAW
Category: NS Administration
All articles / code related to Netsuite administration
basic mathematical formulas in Journal Credit and debit columns
Did you know you can enter amounts in a journal entry using formulas? When filling out the debit or credit columns, you can use basic mathematical formulas such as addition, subtraction, multiplication, and division right in the field. Just press enter and the total should be there! This feature helps reduce manual calculations and minimizes… Continue reading basic mathematical formulas in Journal Credit and debit columns
Difference between Name and Name (Internal) filter in Item Saved Search
Scenario User created an Item Saved Search and set a Name Filter under Criteria Subtab Example : Name = is 2345 However, the system is pulling up the item record with the Name “970-2345” Solution 1. Navigate to Lists> Search> Saved Searches > New 2. Click Item 3. Click Criteria 4. Click Standard 5. Filter: Select Name(Internal) Note: Use the field “Name(Internal)” instead of… Continue reading Difference between Name and Name (Internal) filter in Item Saved Search
Email Size limits
Outbound Email Limits The total email size limit is 15 MB for outbound emails. This limit covers both the email content and all attachments. The limit leaves space for things like email headers and message encoding. Therefore, after NetSuite processes the email, the final message might be larger than 15 MB Attachment size limits can… Continue reading Email Size limits
Customer Inactivity Detection and Status Change via SuiteScript
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
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