Does anyone know how to setup an alert based on the quantity available field for inventory items? Specifically, if the qty available drops below 50 pcs.
I have a search created for items that have dropped below a certain quantity available. I can schedule this search to go out weekly, but the recipients would have to compare it to the prior week's list to see what items have been added to the list.
To simplify things, I figured I could notify customers for each item when it drops below 50 pcs. I tried the "Send Email Alerts When Records are Created/Updated" option and entered a sales order to reduce the qty available for a specific item. The e-mail alert did not go out but the item is now on the results of the search. Do the alerts only work when a user actually goes in to a record and keys in a change? The qty available is a system field that subtracts qty on order from qty on hand as orders are entered. Is it the act of saving a record/transaction that triggers the "Send Email Alerts When Records are Created/Updated" option? That would likely make this alert impossible.
If anyone knows a way around this, please help. The alternative would be to only list results of items that have dropped below 50 pcs available during the last week. This one seems even more complex, though.
Thanks!