Applies To
Product: Netsuite 2019.1
Scenario
User would like to create a saved search that will send email alerts when quantity available for a location is zeroed out
Solution
1. Lists > Search > Saved Searches > New > Transaction
2. Under Criteria tab > Standard subtab, enter the ff:
|
FILTER |
DESCRIPTION |
|
Item : Type |
Is Inventory Item |
|
Item : Inventory Location |
Is (Location desired) |
|
Item : Inactive |
Is false |
|
Item : Location Available |
Is 0 |
Note: Just search for Item Fields... which is at the bottom of the filter dropdown and then on the pop-up window, you may search for type, inventory location, etc.
3. Under Results tab > Column subtab, enter the ff:
|
FIELD |
SUMMARY TYPE |
FORMULA |
|
Item : Name |
Group |
|
|
Formula (Numeric) |
Maximum |
NVL({item.locationquantityavailable},0) |
4. Email subtab, check the Send Email Alerts When Records are Created/Updated. Add recipients and check Send on update.
5. Click on Save
6. Edit again the saved search
7. Under Results tab > Sort by dropdown field > choose Item : Name
8. Click Save & Run