To create a valid certificate for OAuth 2.0 M2M (Machine-to-Machine) authentication in NetSuite, you need to generate a public/private key pair (certificate), upload the public key to NetSuite, and use the private key securely in your application or integration setup. Step-by-Step Certificate Creation Generate Key Pair Use OpenSSL to generate the keys by running: openssl… Continue reading Creating Valid Certificates for NetSuite OAuth 2.0 M2M Integrations
Month: August 2025
Create a Saved Search to Show Changes Made to a Role
Scenario A user wants to create a Saved Search to show the all the changes made to a role. Solution Navigate to Lists > Search > Saved Searches > New Search Type: Click Role Click Criteria Click Standard Filter: Select Custom Custom: Select Yes Click Set 5. Click Results 6.Click Columns Field: Select Name Select Permission Change Select Permission Change Level Select Permission Change Date 7.Click Available Filters Filter: Select Permission Change Date Show in Filter… Continue reading Create a Saved Search to Show Changes Made to a Role
Set preferences for Gift certificate authentication code
Go to Setup > Accounting > Preferences > Accounting Preferences. 2.Click the Items/Transactions subtab. 3.In the Other Item Preferences section, in the Gift Certificate Auth Code Generation field, select one of the following: System Generated – NetSuite generates an authentication code when a gift certificate is sold, requiring no manual tracking of codes. These codes can be long, but this is… Continue reading Set preferences for Gift certificate authentication code
suiteQL query to get invoices by a date range
The SuiteQL query below returns all customer invoices issued in the past 30 days. SELECT Transaction.ID AS Invoice, Transaction.TranID AS InvoiceNumber, Transaction.TranDate AS InvoiceDate, Transaction.Entity AS Customer, BUILTIN.DF( Transaction.Entity ) AS CustomerName, Transaction.OtherRefNum AS CustomerPONumber, TransactionLine.CreatedFrom AS SalesOrder, BUILTIN.DF( TransactionLine.CreatedFrom ) AS SONumber, Transaction.Employee AS SalesRep, BUILTIN.DF( Transaction.Employee ) AS SalesRepName, Transaction.ForeignTotal AS TotalAmount, REPLACE(… Continue reading suiteQL query to get invoices by a date range
Troubleshooting Gulp command failures in an SCA project
While working on a SuiteCommerce Advanced (SCA) project, we often use gulp commands such as gulp extension:fetch or gulp extension:deploy to manage and deploy extensions. However, a common issue that can arise is Gulp appearing to be installed, yet failing to execute properly—throwing errors like “Local gulp version unknown”. Uninstall the current Node.js version Remove… Continue reading Troubleshooting Gulp command failures in an SCA project
How to Email the saved searches and reports to specific role users or dynamic Groups
Overview By default, NetSuite does not support role-based emailing in Saved Searches or Reports. Additionally, dynamic groups are not supported in standard saved search email distribution. To overcome this limitation, we can use a SuiteScript Map/Reduce script to generate and send search results to users belonging to specific roles or groups. Solution Approach We achieve… Continue reading How to Email the saved searches and reports to specific role users or dynamic Groups
How to Remove the Remove Link from the child record
When a sublist on a record is based on a custom record and the sublist is set to be editable, you may notice that in the view mode of the parent record, a “Remove” link appears next to each line of the sublist. This happens because the relationship between the parent record and the sublist… Continue reading How to Remove the Remove Link from the child record
Steps to Create a Dynamic Group in NetSuite
Steps to Create a Dynamic Group in NetSuite Navigate to Group Creation Go to: Lists > Relationships > Groups > New Choose Group Type Select either Employee, Customer, Vendor, or Partner depending on who you want in the group. Since you want users of a certain role → choose Employee. Select Group Type = Dynamic… Continue reading Steps to Create a Dynamic Group in NetSuite
Adding a Custom HTML Button Near a Body Field in NetSuite Using UserEvent Script
This article will guide you through the process of adding a custom HTML button near a body field in NetSuite using a UserEvent script. This technique is useful for adding custom functionality to NetSuite forms without modifying the core UI. Understanding the Use Case In NetSuite development, you may often need to add custom buttons… Continue reading Adding a Custom HTML Button Near a Body Field in NetSuite Using UserEvent Script
Exclude special or drop ship orders from the workflow
Purpose This article describes how to implement a Workflow Action Script in NetSuite to exclude special or drop ship orders from progressing through a workflow. The script checks if any item line in a transaction has the “Create PO” checkbox selected. If none are selected, the workflow bypasses the state meant for purchase order creation. Script Code /** * Workflow Action Script to check if any item line has “Create PO” checked.… Continue reading Exclude special or drop ship orders from the workflow