Overview: Tracking product returns is essential for improving quality, reducing costs, and enhancing customer satisfaction. This SuiteQL query helps NetSuite users identify which inventory items are returned most frequently, offering actionable insights for product and operations teams. What It Does: Targets return authorization transactions (RtnAuth) from NetSuite Filters out voided or cancelled records Focuses specifically… Continue reading SuiteQL query for Identifying most returned Inventory items in NetSuite
Author: Alan Shibu
Checkout Error: “Please Select Shipping Method” — Even After Selection
Problem Overview Customers encounter the error message “Please select shipping method” at checkout—even after making a selection—especially when their customer record lacks a configured default shipping method in NetSuite. Root Cause When processing an order, SuiteCommerce Advanced evaluates shipping method preferences in a hierarchical manner: Default Shipping Method defined on the item record. Customer-specific shipping… Continue reading Checkout Error: “Please Select Shipping Method” — Even After Selection
Issue in recognizing Node.js installed on the local system
While working in the local setup required for SuiteCommerce Advanced, there were four prerequisites to be met for setting up the environment required for running the SCA website: Node package manager(npm), Node version manager(nvm), gulp, Node JS and gulp. However, if Node.js is installed standalone , if the command ‘node -v’ is run in the… Continue reading Issue in recognizing Node.js installed on the local system
Summarizing the results in a saved search
While creating a saved search, it was observed that if a summary type, for example, count, sum, etc. is applied to any one of the results, only those results to which summary types are applied will be displayed when running the search; the unsummarized results won’t show up. Hence, it becomes necessary to apply summary… Continue reading Summarizing the results in a saved search
Create and Use Templates in NetSuite Email Merge
NetSuite’s email merge feature allows users to send personalized emails to multiple recipients using templates, saving time and ensuring consistent communication. To create a template, go to Documents > Templates > Email Templates > New. You can design the template using NetSuite’s rich text editor and insert dynamic fields (merge tags) like customer name, transaction… Continue reading Create and Use Templates in NetSuite Email Merge
Opportunity vs Quote in NetSuite
In NetSuite, Opportunities and Quotes are both part of the sales process but serve different purposes and stages in the sales cycle. An Opportunity represents a potential sale—it’s a preliminary record created when a lead shows interest in your product or service. It allows sales reps to track potential revenue, forecast sales, and monitor progress… Continue reading Opportunity vs Quote in NetSuite
Discount Items in NetSuite
In NetSuite, Discount Items are used to apply discounts to sales transactions like quotes, sales orders, or invoices. These items can be set up to offer either a fixed amount or a percentage off the total or line item prices. To create a discount item, go to Lists > Accounting > Items > New, and… Continue reading Discount Items in NetSuite
Best Practices for Managing Multi-Location Inventory in NetSuite
Managing inventory across multiple locations in NetSuite requires proper setup and consistent processes to ensure accurate stock visibility, fulfillment efficiency, and cost control. Start by enabling Multi-Location Inventory in your account under Setup > Company > Enable Features > Items & Inventory. Then, define each location clearly in Setup > Company > Locations, assigning attributes… Continue reading Best Practices for Managing Multi-Location Inventory in NetSuite