Search to pull list of items with a specific price level with zero or null values 1) Navigate to Lists > Search > Saved Searches > New > Item 2) On the Criteria tab > Standard sub tab > Select Formula (Numeric) > Formula=CASE WHEN NVL({pricelevel1},0)<=0 THEN 1 ELSE 0 ENDEqual to 1. **Pricelevel1 = where 1 is… Continue reading Search to pull list of items with a specific price level with zero or null values
Tag: saved search
Saved Search to fetch the recently created active custom record for an item
Requirement There is a custom record named “Bin Enhancement” associated with the inventory items. We can create multiple custom record for a single item. The custom record is used to store the bin number in a particular location from the item record. We have a scheduled script to automate the creation or updation of this… Continue reading Saved Search to fetch the recently created active custom record for an item
To get domain name from an email address using saved search
A formula(text) can be selected in the column field andSUBSTR({email}, INSTR({email}, ‘@’) + 1, INSTR({email}, ‘.’) – INSTR({email}, ‘@’) – 1)can be entered in the formula field. For example:If the email address is “test@gmail.com”By using the above-mentioned formula in saved search, we get “gmail” from the saved search results.
Generate Customer Price List with Additional Customer Information through Saved Search
There are instances when users want to use Saved Search to generate a Price List for their Customers. This is primarily important when they want to include additional Customer information on the results because the Generate Price List function on the Customer Record has limited information to display. Solution To create the Customer Saved Search: 1. Navigate to Lists > Search > Saved Searches > New 2. Search Type > Click Customers 3. Click Criteria 4. Click Standard 5. Filter: Note: For… Continue reading Generate Customer Price List with Additional Customer Information through Saved Search
Function to Search and Find the Available Items and Available Item Quantity in a Bin
Banket Purchase order and Purchase order Line Mapping Search
Within the Purchase Order record, there is currently no feature available to directly link and identify the corresponding item line within the Blanket Purchase Order. To address this, we can use a search method to determine the corresponding line number in the Blanket Purchase Order. In this particular search, the “Applied to Transaction Line ID”… Continue reading Banket Purchase order and Purchase order Line Mapping Search
Saved Search formula to filter all the item fulfillment Created in the account
The client would like to filter all the item fulfillment that are in shipped status(created through UI or through bulk processing etc)created in the account. We can use the saved search formula as below
Saved Search formula to filter the Item fulfillment with inventory items only
In the summary filter add the formula [“max(formulanumeric: CASE WHEN {item.type}!=’Inventory Item’ THEN 1 ELSE 0 END)”, “equalto”, “0”],
Getting Results of Saved Search using REST API
Scenario: One of my clients inquired if there is a method to retrieve results from a saved search in the REST API and couldn’t find any direct API that we can use to obtain results of the saved search in NetSuite. However, I was able to find an alternative method to accomplish this. We can… Continue reading Getting Results of Saved Search using REST API
Creating a custom field that pulls results from a saved search in NetSuite
First, we need to create a saved search that the field uses for the results. And then we will create a custom transaction body field on a Sales Order to show the total of quantity of all the items that is on that Sales Order. To create a saved search, we navigate to List> Search>… Continue reading Creating a custom field that pulls results from a saved search in NetSuite