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

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

SuiteFlow Error: Failed to Create or Assign a Workflow Instance for Record

User created a Workflow containing a Transform Record action to transform a Customer record into a Vendor record. When the Customer record is saved the following error is received: Failed to create or assign a workflow instance for record. (Workflow type = 2, Record type = -3, Record key = 1234). Note: Workflow type and Record key are just sample numbers Solution A common cause for… Continue reading SuiteFlow Error: Failed to Create or Assign a Workflow Instance for Record

GraphQL Mutations: Basics and Usage

GraphQL mutations allow clients to modify server-side data by creating, updating, or deleting records. Unlike queries, which only read data, mutations enable write operations while still allowing you to specify what data you want returned. What Are Mutations • Mutations are operations that change data (CRUD: Create, Read, Update, Delete). • Use the mutation keyword… Continue reading GraphQL Mutations: Basics and Usage

Checkout Error: “Please Select Shipping Method” — Even After Selection

Problem Overview Customers encounter the error message “Please select shipping method” at checkout—even after making a selection—especially when their customer record lacks a configured default shipping method in NetSuite. Root Cause When processing an order, SuiteCommerce Advanced evaluates shipping method preferences in a hierarchical manner: Default Shipping Method defined on the item record. Customer-specific shipping… Continue reading Checkout Error: “Please Select Shipping Method” — Even After Selection

Prevent record deletion

You can use the methods below to prevent record deletion: Role Level – Removing the record’s FULL permission level in the role (Role record > Permissions). You can assign a lower permission (View, Create, or Edit). – Easiest method, but restrict all roles from deleting the record. No additional parameters for deletion can be set… Continue reading Prevent record deletion