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?

Thanks.