Scenario In some situations, User creates a custom field on Sales Order form to track orders besides NetSuite’s standard Order Number/ID field. If the value in this field is entered manually and there is no mechanism to auto populate this field, there is a possibility that it may have duplicate values. Following saved search enables… Continue reading Create Saved Search to Track Duplicate Sales Order with Same Custom Field values
Tag: saved search criteria
How to get the partner details of a customer using “Saved Search”.
To get the partner details of a customer using “Saved Search” navigate to Lists –> Search –> Saved Search –> New. Now follow as per the screenshots added below. Step 1: Step 2: Step 3: Now Save and Run the Saved Search for the result.
Search criteria to find the sales order which do not have the back ordered quantity
If a user need to create a transaction search to list out the sales orders which do not have any back ordered quantity in the line items, use the formula given below. case when {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0) > 0 then 1 else 0 endEnter 0