Forum Discussion
KevinSlider
7 years agoQrew Trainee
Hello,
The requirement I am seeing here: Send notification when products reach a minimum level in a product table. (determined by some comparison of QTY vs Min QTY)
the easiest way would be to set each product with a minimum QTY, and create a report based on if the QTY<=Minimum QTY. Then have a daily subscription to that report.
This would provide a daily summary of products that have reached the threshold at the minimum, but would not be in real time.
A real time solution would require the use of an automation triggered by the use of the product via an edit operation. the automation could edit the product to trigger a notification if the qty threshold has been met for the minimum. I would need much more detail to help solution this process.
Let me know if this helps.
The requirement I am seeing here: Send notification when products reach a minimum level in a product table. (determined by some comparison of QTY vs Min QTY)
the easiest way would be to set each product with a minimum QTY, and create a report based on if the QTY<=Minimum QTY. Then have a daily subscription to that report.
This would provide a daily summary of products that have reached the threshold at the minimum, but would not be in real time.
A real time solution would require the use of an automation triggered by the use of the product via an edit operation. the automation could edit the product to trigger a notification if the qty threshold has been met for the minimum. I would need much more detail to help solution this process.
Let me know if this helps.