Requirement: In the case of any comparison purpose in the script, how can we differentiate each line when there are multiple item lines with the same item? For that, we can create a saved search and include a Formula text column in the results using the expression {number}||’_’||{line}. Here, the {number} represents the document number… Continue reading How can we append the line number with the invoice number using a saved search?
Tag: saved search formula
Saved search formula to get the Items ready for fulfillment
Saved search formula to get the Items ready for fulfillment
How to display the quantity available in each location separately in the saved search
To display the quantity of an item in different locations separately in the Item Saved Search result, we can apply the Formula in the saved search as shown below. In this way we will get the quantity stored in each location separately.
Show only Parent Location of an Item in Item Saved Search
To show only Parent Location of an Item in Item Saved Search, use the following formula. Under Criteria Tab include, Filter: Formula (Text) Description: is 1 Formula: CASE WHEN {inventorylocation.name}={inventorylocation.namenohierarchy} THEN 1 ELSE 0 END
Show Child Matrix Item Name in Item Saved Search
When creating Item Saved Searches, the Name field displays the parent matrix item name before the matrix child, e.g. Parent Item : Matrix Child. To display the Child Matrix Item Name only, formula text can be used in the search: Under Column sub tab of Results tab, Field: Add Formula (Text) Formula: Enter case when {parent} is null then {name} else {feedname} end Now the search… Continue reading Show Child Matrix Item Name in Item Saved Search
Display Orders Due within the Next 4 Weeks
Requirement: Create a report in NetSuite that displays orders that are due within the next 4 weeks. This feature will help users easily identify and track orders that have upcoming due dates. Solution: Go to Lists -> Saved Searches -> Saved Searches -> New. On the New Saved Search page, select “Transaction” as the search… Continue reading Display Orders Due within the Next 4 Weeks
Using the FIRST_VALUE Function in NetSuite Saved Search
Overview: The FIRST_VALUE function in NetSuite’s Saved Search feature allows you to retrieve the first non-NULL value from a specified set of values. This article explains how to use the FIRST_VALUE function in a Saved Search. FIRST_VALUE: This is an analytical function in NetSuite that returns the first value in a specified set of values.… Continue reading Using the FIRST_VALUE Function in NetSuite Saved Search
Calculating Cumulative Sum with Partitioning
This article explains how to calculate a cumulative sum with partitioning in Saved Search Formula. The provided formula demonstrates how to achieve this using the SUM function along with the OVER clause. By partitioning the data based on specific columns, such as the month of a date and a sales representative, the cumulative sum can… Continue reading Calculating Cumulative Sum with Partitioning
Saved Search Formula: Date/Time Difference in Days – Hours – Minutes – Seconds format
DAYS TRUNC({date1}-{date2}) HOURS MOD(TRUNC(({date1}-{date2})*24),24) MINUTES TRUNC(60*((({date1}-{date2})*24)-TRUNC(({date1}-{date2})*24))) SECONDS ROUND(60*((((({date1}-{date2})*24)-TRUNC(({date1}-{date2})*24))*60)-TRUNC(((({date1}-{date2})*24)-TRUNC(({date1}-{date2})*24))*60)),0) Create a formulae text field and then concatenate all the above formula using || as a result column.
How to distingush between normal item and Matrix child item in a saved search?
To distingush between normal item and matrix child item, we can use Formula(Numeric) field in the result tab of item saved search. Before applying this formula, we need to display the ‘parent’ field in the result tab. Then on saving the search we will get the results i.e 4 and 1 accordingly.