Lot Auto Numbering The Lot Auto Numbering SuiteApp enables to define lot and serial numbering formats and select items that require auto numbering. User can also configure additional information such as supplier lot number, sequence number, and manufactured date, and maintain this information in the inventory detail. Lot and Serial Number Formats: Lot and serial… Continue reading Lot Auto Numbering – SuiteApp
Month: July 2025
NetSuite Shopify Integration – Order Sync (Draft Order & PO# Metafield)
We’ve updated the Shopify to NetSuite Order Sync, enabling automatic creation of ‘Pending Fulfillment’ Sales Orders in NetSuite for every new order placed in Shopify. These synced orders include all essential details such as product name, quantity, customer information, payment status, and shipping address. Note: Any changes made to Shopify orders after fulfillment will not… Continue reading NetSuite Shopify Integration – Order Sync (Draft Order & PO# Metafield)
Generate Excel Reports with Item Images in NetSuite using Vue.js + ExcelJS
Sometimes business users need Excel reports with images, totals, and summaries—something NetSuite’s standard reporting doesn’t easily support. By combining Suitelets, Vue.js, and ExcelJS, we can generate fully customized Excel files directly from the browser. 🔧 What We Used Suitelet → serves a Vue.js frontend Vue.js → user interface and trigger ExcelJS → build styled Excel… Continue reading Generate Excel Reports with Item Images in NetSuite using Vue.js + ExcelJS
Smart BOM Cloning in NetSuite Based on Material Specs
In jewelry manufacturing, BOM duplication for alternate materials—like different gold qualities or diamond grades—is a repetitive yet critical task. To streamline this, we’ve developed a NetSuite Suitelet that allows users to duplicate existing Bill of Materials (BOM) Revisions while automatically substituting components based on selected material specs such as Metal Type, Diamond Color, and Color… Continue reading Smart BOM Cloning in NetSuite Based on Material Specs
Using the “Select Item” Checkbox to Pre-select Items on Item Fulfillment (IF) and Item Receipt (IR) Transactions
Overview In NetSuite, the Item Fulfillment (IF) and Item Receipt (IR) transactions allow users to mark which line items should be processed (fulfilled or received) by selecting a checkbox on each line. NetSuite provides a built-in field called Select Item that controls this behavior. This article explains how the Select Item checkbox works, how it… Continue reading Using the “Select Item” Checkbox to Pre-select Items on Item Fulfillment (IF) and Item Receipt (IR) Transactions
Show a Loading Spinner with UI Blur During Long-Running Actions
When performing long-running actions in a NetSuite Suitelet or Client Script — such as generating files, calling APIs, or triggering downloads — it’s good practice to show a loading indicator and block the UI to avoid user interaction. Here’s a reusable snippet that creates a full-screen blur overlay and centered loading GIF (spinner). Why Use… Continue reading Show a Loading Spinner with UI Blur During Long-Running Actions
Automating Item Receipt Creation Based on ‘Fulfilled/Received’ Preference in NetSuite
Overview: This article explains the logic and automation implemented to create Item Receipts from Purchase Orders (POs) in NetSuite only when items are marked as Fulfilled/Received. This ensures that receipts are not created for items that are not physically received or flagged for receipt. Business Requirement: When a new Purchase Order is created, the system… Continue reading Automating Item Receipt Creation Based on ‘Fulfilled/Received’ Preference in NetSuite
FIND NUMBER OF DAYS TILL DATE FROM A GIVEN DATE IN ANALYTICS
Suppose you have a field in a record which displays date for a perticular event/process. You are required to prepare a report using workbook in which one of the fields is days since the date given in the corresponding record. Say for example) In the sales order record, Order Date = 23-May-2025. I have to… Continue reading FIND NUMBER OF DAYS TILL DATE FROM A GIVEN DATE IN ANALYTICS
Correcting Website Name in Google Search Using JSON-LD in SuiteCommerce Microsites
The client operates multiple microsites under different domains. However, in Google Search results, the website name for some existing indexed microsites is incorrect, outdated, or inconsistent. This article outlines the issue, Google’s rendering behavior, and the implemented solution using JSON-LD structured data to ensure each microsite has accurate SEO metadata aligned with its domain and… Continue reading Correcting Website Name in Google Search Using JSON-LD in SuiteCommerce Microsites
Boomi for Integration and EDI SuiteApp
Boomi’s integration platform as a service (iPaaS) seamlessly extends the NetSuite platform by connecting any combination of cloud and on-premises applications to automate business processes – without software, appliances or coding. Integration, Master Data Management, API Management, ETL and EDI are all available from Boomi’s 100% cloud-based, scalable and easy to use platform. Find out… Continue reading Boomi for Integration and EDI SuiteApp