🧠Overview: This article explains how to use a formula in a NetSuite Saved Search to flag when the total quantity sold of a specific item exceeds a set threshold. The formula returns 1 if the threshold is crossed, otherwise 0. 🧮 Formula: CASE WHEN SUM( CASE WHEN {item.name} = ‘Premium Laptop’ THEN {quantity} ELSE… Continue reading Using CASE Statements to Flag High Volume Sales of a Specific Item
Month: June 2025
Importing Data Using a Bank Connectivity Plug-in
Warning: The Bank Connectivity Plug-in interface is still functional but is no longer supported as of NetSuite 2020.1. To directly connect to a financial institution and automate bank data imports for matching and reconciliation, use the Financial Institution Connectivity Plug-in. For details, see Automating Imports for Bank Reconciliation. Follow this procedure to download files locally from… Continue reading Importing Data Using a Bank Connectivity Plug-in
QA: Path to Test cases and test results
Link https://jobinandjismi2021-my.sharepoint.com/personal/jj_jobinandjismi_com/_layouts/15/onedrive.aspx?id=%2Fpersonal%2Fjj%5Fjobinandjismi%5Fcom%2FDocuments%2FJ%20%26%20J%2FTest%20case%20documentation&CT=1750659055397&OR=OWA%2DNT%2DMail&CID=abe3b8c6%2Dac0f%2D595e%2D4190%2D054fbfb684a3&e=5%3A0d00b21cc41b4990872e63f3d74feba9&sharingv2=true&fromShare=true&at=9&FolderCTID=0x01200054EDD5E0296875459E9445DD4A8A7BFB
Animated Emission Effects with Procedural Noise in GLSL
Emissive materials are commonly used in real-time graphics to simulate glowing surfaces — whether it’s a flickering sci-fi interface, a magical rune, or an energy pulse moving through a forcefield. These materials not only enhance visual appeal but also serve functional purposes, like drawing the viewer’s attention or indicating interactivity. This article outlines how to… Continue reading Animated Emission Effects with Procedural Noise in GLSL
Configuring a Connection to a Financial Institution (Without a SuiteApp)
In a Bank Reconciliation format profile, you can configure a connection to a financial institution to automatically retrieve bank or credit card data, without using a SuiteApp. To accomplish this, create and configure your own financial institution record and a corresponding format profile that uses custom transaction parser and connectivity plug-in implementations. The following procedure… Continue reading Configuring a Connection to a Financial Institution (Without a SuiteApp)
Delete Inbound Shipment Records
Scenario: When attempting to delete an inbound shipment, a prompt message appears stating, “This record cannot be deleted because it has dependent records.” However, no dependent records are displayed, preventing their deletion. Solution: Possible dependent records linked to the inbound shipment may include WMS Open Tasks if the Warehouse Management System (WMS) is in use.… Continue reading Delete Inbound Shipment Records
Advanced PDF/HTML Template code for COO Calculation and Grouped Item Display in NetSuite PDFs
Key Functions: Item Processing: Parses transaction line items, skipping kit/group children to avoid duplication. Handles both item groups and kit structures properly. Amount Normalization: Converts formatted amount strings into usable numeric values (e.g., handling commas, decimals, symbols). COO Assignment: Calculates _computedCOO for each item using: custcolcountry_of_origin (if available), Previous COO for discount items, Defaults to… Continue reading Advanced PDF/HTML Template code for COO Calculation and Grouped Item Display in NetSuite PDFs
Resolving Misalignment and Text Wrapping Issues in Advanced PDF Templates
In NetSuite, advanced PDF/HTML templates offer a flexible way to customize transaction forms. However, during customization, developers may encounter issues such as misalignment of table cells and improper text wrapping—for example as shown below, with item names, dates, and other dynamic fields. These issues can manifest as unexpected spacing between letters or text overflow, which… Continue reading Resolving Misalignment and Text Wrapping Issues in Advanced PDF Templates
Unlocking the Locked Custom Item Field (Manually Created)
The Custom Item field is locked automatically when the field is used in the Commerce Website Setup in the SuiteCommerce Advanced. Solution: If the website is not in use or is inactive, we can remove it under the Field Set tab after confirming that it won’t have any impact. If the website is in use… Continue reading Unlocking the Locked Custom Item Field (Manually Created)
End Date is not showing on the Map/Reduce Script Status page
Scenario User have created a Map/Reduce Script, however, the End Date is not populating even though the script execution has already completed on the Map/Reduce Script Status Solution In the events that the Map/Reduce script is not showing its End Date on the Map/Reduce Script Status, this is because there is no Summarize stage on the… Continue reading End Date is not showing on the Map/Reduce Script Status page