When working with sales orders, we might notice that the “Available Quantity on Sales Order” doesn’t always match the “Available Quantity” listed directly on the Item Record. Rather than pulling the number straight from the Item Record, the system calculates the Available Quantity on Sales Order using a specific formula. The Available Quantity on Sales… Continue reading Available Quantity on Sales Orders
Month: March 2025
Method to calculate the Reverse Discount item amount to omit certain line items having tax codes
When a reverse discount item is added to a custom item, the reverse discount item should also contain the tax code of the custom item so that the tax amount applied is reversed. If the functionality is only adding a single reverse discount item for all the Custom items added, it won’t help in reversing… Continue reading Method to calculate the Reverse Discount item amount to omit certain line items having tax codes
Update Customer Contact roles using csv import in SCA
To update the contact role of a contact associated to a customer record via CSV import, the following steps should be followed: Create a CSV File with the following columns: Customer ID Contact Name Navigate to Import CSV Records: Go to Setup > Import/Export > Import CSV Records. Scan & Upload CSV File Page: Import Type:… Continue reading Update Customer Contact roles using csv import in SCA
Inventory Item Showing “On Hand” but Not “Available”
In NetSuite, an issue was recently observed while reviewing an inventory item record. The system indicated a “Quantity on Hand” for the item at a specific location, yet the “Quantity Available” field remained empty. Upon further investigation, it became clear that no physical stock of the item existed at the location. Initially, identifying the root… Continue reading Inventory Item Showing “On Hand” but Not “Available”
What are the Smart Count SuiteApp ?
The Smart Count SuiteApp allows users to conduct real-time inventory counts during business hours without stopping operations. During the counting process, the SuiteApp captures and records current on-hand inventory and quantities for a specific item and notifies the counter if the count is off, as well as specific actions to remedy the issue. Additionally, you… Continue reading What are the Smart Count SuiteApp ?
What are the main benefits of SuiteSuccess Methadology
NetSuite SuiteSuccess is a total solution designed to manage all aspects of a business in a single system. By packaging the experience and learnings gained from tens of thousands of deployments worldwide over two decades into a set of leading practices, NetSuite SuiteSuccess gets you up and running quickly. KPIs, workflows, reports and value-driven dashboards… Continue reading What are the main benefits of SuiteSuccess Methadology
Inventory Statuses in NetSuite
The Inventory Status feature is a core function of NetSuite that allows you to associate attributes to items to drive internal processes. In today’s fast workplace environment, effective inventory management is the key to success. For those using NetSuite, understanding how to utilize inventory statuses can significantly enhance operational efficiency. Throughout this post, we will… Continue reading Inventory Statuses in NetSuite
NetSuite Advanced with AI for SuiteAnswers
Finding solutions in SuiteAnswers just got easier with NetSuite Expert, an AI-powered upgrade in the 2024.2 release. Instead of searching by keywords and clicking through multiple articles, you can now ask questions in natural language and get direct, summarized answers instantly. Powered by retrieval-augmented generation (RAG), NetSuite Expert analyzes your query, pulls relevant information from… Continue reading NetSuite Advanced with AI for SuiteAnswers
Printing Labels From Transactions
To print labels for items on a purchase order or item fulfillment: View the purchase order or item fulfillment you want to print a label for. Click the print icon, and select Print Labels. NetSuite opens the labels in the Adobe®application. Click the printer button in the Adobe application. Specify the number of copies on the… Continue reading Printing Labels From Transactions
Using Formula Expression CONCAT to Join 2 Fields and Character “&” in Between Gives Error Invalid Expression in Saved Search
Scenario When users use CONCAT to join multiple fields, the expression as below is used: Concat({fieldidAAA}, concat(concat(‘ ‘, {fieldidBBB}), concat(‘ ‘, {fieldidCCC}))) However, when the said expression is used to join a character, it gives an Invalid Expression. Sample formula that shows this problem: Concat({fieldidAAA}, concat(concat(‘ ‘, ‘&’}), concat(‘ ‘, {fieldidBBB}))) Solution Sample formula that shows… Continue reading Using Formula Expression CONCAT to Join 2 Fields and Character “&” in Between Gives Error Invalid Expression in Saved Search