I need to set up an alert when safety stock falls below onhand. How do I do this? My safety stock is in PartPlant and my onhand stock is in PartWhse.
Two ways to do this.
1: create a data bpm that is based on the partwhse table and then (using code) read all the partwhse records that are in your site and add up all the on hand qty, and then compare to the safety stock in partplant. If less then throw an alert.
2: BUT the system will automatically calculate this when you run MRP. You can then creat a BAQ to find all partdtl records that have a reason of below safety.
3 Likes
You can try this as a starting point. It’s an in-transaction to check when the on-hands go below safety, then enables a standard directive to send the email.
I’ve put about 30 seconds of thought into this so “starting point” is the key phrase here. At the very least you should move it to be a method directive.
This might work fine according to your post, but there are some “ifs, ands, or buts” that come with it. An example is that you would want to check if the on hand qty was already below safety before firing this, or else you may get multiple emails for the same part.
2 Likes
Is this correct? And how can I send notifications when the stock level falls below the safety level?
1 Like
make a standard directive. Put a condition that it has been enabled from the in-transaction directive. Use the send email widget in the standard directive.
1 Like
1 Like