Hello,
I have a database with the following fields:
brand
Model
photo
total number
minimum stock
available
failure
with hooks wanted to handle the computation of the material and this is not a problem.
example:
total number of 100
minimum stock 20
available 18
failure 82
but I wanted to know if someone could help me to create code to send an email alert when the material reaches the reorder point (so you have to do a background check from the materials available and the minimum stock).
Email: ATTENTION material "Make and Model" has reached the minimum stock of 20 pieces!
Can anyone help me?
Thank you in advance ...