Category: NS Administration

All articles / code related to Netsuite administration

Wave Record – Functionality

A wave transaction is used to consolidate orders for release to the warehouse. When you release a wave, the items from the order become available for picking and further fulfillment processing on a mobile device. Released waves display pick tickets and pick tasks generated from items in the orders, as well as status updates that… Continue reading Wave Record – Functionality

Subscription Billing Bulk Operations

SuiteBilling Enhancements SuiteApp enables you to perform bulk operations for subscription billing records. The bulk operations feature provides a flexible way to clean up charge, usage, and change order records that are no longer needed in the system. You can also update specific fields on charge or change order records, and change the status of… Continue reading Subscription Billing Bulk Operations

Mass Update Stuck at 0% Progress

Scenario Administrators have the ability to run Mass Updates and the progress can be viewed. Refer to Check Mass Update Status in NetSuite. There are times when the Mass Update is stuck at 0%. Solution Factors which may cause delay: Progress may depend on the amount of data to be updated. Mass Update performs on a first come first… Continue reading Mass Update Stuck at 0% Progress

Mass Update Limitation

Scenario How many records can be updated via Mass Update? Is there any limitation? Solution Limitations – The Mass Update can do more than 100,000 records at a time depending on various factors described below. – When you run a Mass update, processing 50 records or less begins instantly. If you are processing more than… Continue reading Mass Update Limitation

Bank Feeds SuiteApp: Replacement of TargoBank with Abanca

What is Changing? Starting October 17, 2024, the authorized Account Information Service Provider (AISP) of NetSuite is deactivating the TargoBank financial institution from bank feeds integration.  TargoBank financial institution will be replaced by Abanca. This change is a result of the merger of TargoBank with Abanca financial institution. As a result, you will no longer be… Continue reading Bank Feeds SuiteApp: Replacement of TargoBank with Abanca

Downloading Fixed Assets Reports in Excel Format

Scenario: When generating a report in the Fixed Assets Management module, users may find that the report is only available in XML and PDF formats. To convert this to excel, follow these steps: Click on the XML hyperlink for the report you wish to open in Excel. The XML file will be downloaded and will… Continue reading Downloading Fixed Assets Reports in Excel Format

Cost Variance Analysis

The Cost Variance Analysis SuiteApp analyzes the variances during the execution of work orders. These variances are associated with quantity and cost between the planned values for the work order and the actual values recorded against the work order. This SuiteApp also enables you to do the following: Measure the performance of work orders and… Continue reading Cost Variance Analysis

Customer Saved Search for Yearly Comparison of Sales Orders

1) Navigate to Reports > Saved Searches > All Saved Searches > New 2) Click on the Customers link 3) Criteria tab > Standard sub tab > set the following Filters with their corresponding Description:    — Transaction:Type | is Sales Order         — Transaction:Date | is on or after 11/20/2022 4) Results tab > Columns sub tab> set… Continue reading Customer Saved Search for Yearly Comparison of Sales Orders

Create a Custom Customer Entity Field to Show Total Sales of the Customer

Create a Customer Saved Search: 1. Navigate to Lists > Search > Saved Searches > New. 2. Select Customer. 3. Give a name to the Search. 4. Under the Criteria tab > Standard subtab add two fields: Transaction Fields… Type is any of Invoice, Cash Sale. Transaction Fields… Main Line is True. 5. Under the… Continue reading Create a Custom Customer Entity Field to Show Total Sales of the Customer