Applies To
Product: Netsuite 2019.1
Scenario
User would like to create a saved search that will show all the items without sales for a specific period
Solution
1. Go to Lists > Search > Saved Searches > New
2. Select Item as the search type
3. Go to Criteria > Summary subtab and set the following:
-Summary Type=Maximum
-Field = Formula (Date)
-On the pop-up window:
Formula field, indicate: max(case when {transaction.type}='Sales Order' then {transaction.trandate} end)
On the Formula (Date field): not after relative years ago and assign number (i.e. 1 year ago)
-Click Set
4. Go to the Results > Columns subtab
- Field=Name, Summary Type=Group
- Field=On Hand, Summary Type=Maximum
- Field=Total Value, Summary Type=Maximum
5. Assign a title and hit Save & Run