Sending notification based on minimum stock (safety stock)

Hi - I’m interested in this also - did you find a solution?

Hi @gianni.neves and @ChrisKnight ,

I know if you use MRP that an MRP message will appear in the action proposals telling you the Available Quantity < Safety Stock.  Your buyers would see this message in their MRP Action Proposals  Workbench.   

Another option would be to create a custom event that trigger on perhaps inventory transaction history when inventory reduced.  You could retrieve the total available inventory for the part and retrieve the safety stock and perform a check in the event action to so an email is sent when the available is less than safety stock.  

We have a trigger on the transaction history when a new entry is added.  The event action only fires when the SOURCE_REF_TYPE=PUR ORDER and TRANSACTION_CODE = ARRIVAL.

Regards,

William