Category: NetSuite ERP

NetSuite ERP

How to add country based validations in Address form?

Requirement When adding a new [billing or shipping] address, can we remove all the countries except Canada and United States? Solution To implement country-based validation on address records, a client script can be created and attached to the custom code section of the custom address form. This script ensures that users can only select “United… Continue reading How to add country based validations in Address form?

Fixed Asset bundle provisioned but not available for installation

Scenario: FAM bundle has been provisioned to the NetSuite account based on the Billing information. However, the bundle is not available for installation. Findings: Based on SuiteAnswers #103553, the FAM bundle will be available only in selective timings. Important: The availability schedule during phased upgrades applies only to customers who will be installing the Fixed… Continue reading Fixed Asset bundle provisioned but not available for installation

Select ‘Accounting Period’ in column dropdown for Cashflow Statement

This is related to existing Enhancement # 187781 OneWorld> Cashflow Statement. There is no option to display column = accounting period on the footer filter of the report An Alternative solution is: Navigate to Reports > Financial > Cash Flow Statement > Customize Summary Click Edit Columns Set Alternate Period Range Type = Relative to Today’s Date Set Alternate Period Range = This… Continue reading Select ‘Accounting Period’ in column dropdown for Cashflow Statement

No bills shown in Vendor prepayment application

Scenario: When clicking the Apply button on the Vendor Prepayment, there’s no Bills showing even though we have Open Bills for the same Vendor. Findings: Check and confirm the following aspects of vendor prepayment: Is the subsidiary and currency of the vendor prepayment the same as that of the open bills? Bills available for application… Continue reading No bills shown in Vendor prepayment application

Artificial Intelligence (AI) in NetSuite

You might have questions about how NetSuite application features use artificial intelligence (AI) and machine learning (ML). AI is computer software that simulates how humans think and reason. ML lets computer systems learn and improve from experience, without explicit programming. Features in NetSuite that use AI and ML include: NetSuite Expert in SuiteAnswers SuiteScript Generative… Continue reading Artificial Intelligence (AI) in NetSuite

Getting the List of Customer Statuses

In NetSuite, each customer record is assigned a status—such as Qualified, Close Won, or Renewal—based on their position in your sales pipeline. These statuses are stored internally using numerical IDs, which can be unclear when building reports or SuiteQL queries. To help with this, you can use the SuiteQL query below to generate a list of customer statuses. It allows you to easily… Continue reading Getting the List of Customer Statuses

Resource Allocation

The resource allocation record supports reserving an employee’s time for a particular project.  We can view the resource allocations for a specific project through the project record’s Resources subtab (Lists > Relationships > Projects). This record is available only if the Resource Allocations feature has been enabled at Setup > Company > Enable Features, on… Continue reading Resource Allocation

Joining Employees and Vendors in Purchase Order Using SuiteQL

When working with SuiteQL to analyze Purchase Orders, you may want to include additional information about related Entities (e.g., Vendors) and Employees (e.g., Sales Reps). However, not all Purchase Orders are associated with an Employee, so it’s important to structure your joins correctly. This guide demonstrates how to build a SuiteQL query that pulls Purchase Orders along with: The Entity (Vendor) information — always required. The Employee information — if available. INNER JOIN vs LEFT… Continue reading Joining Employees and Vendors in Purchase Order Using SuiteQL

Benefits of Using External ID While Uploading Transaction Data in NetSuite

When you’re importing transactions like vendor bills or customer invoices in NetSuite, using an External ID can make the process much smoother. Here’s how it helps: Group Multiple Lines into One Transaction If a bill or invoice has many lines, giving all those lines the same External ID tells NetSuite they belong to one transaction.… Continue reading Benefits of Using External ID While Uploading Transaction Data in NetSuite