We have a client that is requesting an alert once and item hits zero quantity on hand. NOT when an item is zero on hand but once it hits zero.
So not a daily inventory report showing items with zero on hand. A real time alert that item XXX has been depleted, is there something that exists that we can use to get this done? (script or other building block)
I thought I could get this done with a filter/trigger combo, but I'm struggling with the filter setup. If I filter for on hand qty of less than 1, I get everything that's at zero on hand currently, (so it's still an inventory report of 0 on hand SKUs).
Any thoughts on how we could achieve what our client is asking for?