Notification if inventory level drop
I have a calculated field that tracks inventory levels. "Instock" is calculated by subtracting what is out on jobs from how much we should always have (we don't sell stuff, we use it and return it to storage).
How could I script an If email notification that would send out notifications if instock levels drop below 15% of what we should always have instock?
Any and all ideas would be greatly appreciated.