AnsweredAssumed Answered

Notification if inventory level drop

Question asked by erob on Feb 22, 2010
Latest reply on Feb 22, 2010 by philmodjunk

Title

Notification if inventory level drop

Post

hey all,

 

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.

Thanks!

Rob

Outcomes