Workaround for Bulk Download: 1. Copy Files to a Single Folder: To access the File Cabinet, go to Documents > Files > File Cabinet. Go to the folder that contains the files you want to copy. Click Copy Files. Check the box next to each file you want to copy. Under the Filters subtab, select… Continue reading Exporting the Files from File Cabinet: Important Tips
Category: NetSuite ERP
NetSuite ERP
Sending Email to Group of Recipients
In NetSuite’s standard behavior, when using email.send, we’re not allowed to send emails to more than 10 recipients at a time. If the recipient count exceeds 10, the system throws an error, and the email fails to send. To handle this scenario, we can send emails in batches, with each batch containing 10 recipients. This… Continue reading Sending Email to Group of Recipients
Multiple Active BOM Revisions
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
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
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
Saved Search for getting the Wave records associated to Sales orders
Search criteria: Search results: Saved Search Results after execution:
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
How to Make a NetSuite Sublist Field Read-Only Using jQuery (LIST Type)
In NetSuite, when using a LIST-type sublist in a Suitelet, setting a field as disabled prevents updates even from scripts like setSublistValue. However, there are cases where you want a field to appear read-only to the user but still update it via script. Here’s a simple JavaScript function that makes a specific sublist field read-only… Continue reading How to Make a NetSuite Sublist Field Read-Only Using jQuery (LIST Type)