REQUIREMENT: We need to support multiple active BOM revisions, allowing users to choose which revision to use. Currently, we’re trying to create revisions without specifying effective start and end dates. However, the system requires an effective date on the first revision before allowing new ones. In some cases, an assembly may have an approved alternative… Continue reading Multiple Active BOM Revisions
Month: September 2025
Retrieve User Subsidiaries Based on Role in NetSuite Using SuiteScript
When working with NetSuite in a multi-subsidiary environment, it’s often necessary to determine which subsidiaries a user has access to based on their role. This information is critical for filtering transactions, applying business logic, or enforcing access controls. In this article, I’ll walk you through a SuiteScript 2.x function that retrieves the subsidiaries accessible to… Continue reading Retrieve User Subsidiaries Based on Role in NetSuite Using SuiteScript
Deferred revenue
When businesses receive advance payments, they don’t immediately record this money as revenue—instead, they treat it as a liability until they deliver the promised goods or services. Called deferred revenue, this approach ensures financial statements accurately reflect what the company owes and what it has genuinely earned. In subscription-based industries with software services, prepaid service… Continue reading Deferred revenue
Filtering Sales Orders by Keyword in Document Number or PO# Using Formula (Text) in NetSuite
To filter Sales Orders in NetSuite using a formula that checks whether a given keyword appears in either the Document Number (i.e., tranid) or the PO# (i.e., otherrefnum) field, you can use a Formula (Text) filter in a saved search. Here’s how to structure it: Formula (Text) Filter CASE WHEN {tranid} LIKE ‘%keyword%’ OR {otherrefnum}… Continue reading Filtering Sales Orders by Keyword in Document Number or PO# Using Formula (Text) in NetSuite
Grouping Items into Inventory item, Non Inventory Item and Kit-Item using Celigo Branching from Source Netsuite into Destination Netsuite
What is item grouping in NetSuite via Celigo Item grouping is the process of categorizing products based on their type—such as inventory, non-inventory, or kit items in NetSuite. Using Celigo’s branching logic in the destination application, you can dynamically route each item to the correct NetSuite record type. Here I just used a source NetSuite… Continue reading Grouping Items into Inventory item, Non Inventory Item and Kit-Item using Celigo Branching from Source Netsuite into Destination Netsuite
Saved Search for getting the Wave records associated to Sales orders
Search criteria: Search results: Saved Search Results after execution:
Number of working days using a date field to get that months working day
CASE WHEN {date} IS NOT NULL THEN TO_NUMBER(TO_CHAR(LAST_DAY({date}), ‘DD’)) – (FLOOR( ( (TO_NUMBER(TO_CHAR(LAST_DAY({date}), ‘DD’)) + ( TO_NUMBER(TO_CHAR(TO_DATE(TO_CHAR({date}, ‘YYYY-MM’) || ‘-01’, ‘YYYY-MM-DD’),’DD’)) -1) ) / 7 ) ) * 2) ELSE 0 END
Using DECODE with Nested CASE WHEN in NetSuite Saved Search Formulas
In NetSuite saved searches, you can combine `DECODE` and `CASE WHEN` to handle both simple equality checks and complex conditional logic within a single formula column. This approach is especially useful when: * You need to treat different transaction types differently. * Some transaction types require additional conditional checks (dates, statuses, quantities, etc.). * You… Continue reading Using DECODE with Nested CASE WHEN in NetSuite Saved Search Formulas
Set Item Price Level to Zero Through Updating Price Level Record
Navigate to Setup > Accounting > Accounting Lists (Administrator) Filters: Set to Price Level Click the price level you want to edit. Click Edit. In the Price Level field, you can change the name of this price level. In the Markup/Discount % field, enter: -100.0% Check the Update Existing Prices field. Click Save. After you click Save, all Item prices for that specific… Continue reading Set Item Price Level to Zero Through Updating Price Level Record
Render HTML Markup on a Suitelet From an HTML File in File Cabinet
Scenario A user wants to create their own form/HTML page using a Suitelet. Instead of concatenating a string that represents HTML markup, the user would like to use an HTML file uploaded into their File Cabinet and render it onto a Suitelet. Solution This can be accomplished by using the write method of the ServerResponse object,… Continue reading Render HTML Markup on a Suitelet From an HTML File in File Cabinet