This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi, I need to setting up an alert when qty on hand for any item goes under 50. We have a saved search that shows items under 50. When we put an email alert on our current search, it is sending everything on this list but we need only the new items showing up on the list (items that go under 50 today). Please suggest.

You'd likely need a script to accomplish exactly what you are looking for.

Something that could look at the appropriate quantity field every day and then update a date field.

If it goes over 50 then it empties the date field. If it is under 50 and the field is blank it sends email and populates the date field.

This might work as a workflow now that I think about it, but would take some doing.

The search field `Last Quantity Available Change` _might_ help. It's not qty on hand though ¯\_(ツ)_/¯