Create a Report to Call for Material

Hello, I have an application where 4 machines share 6 common material bins. There are hundreds of materials that could be used in these bins (one at a time). Each machine may use at a different rate. I currently have a Vision application that Sums the rate of usage at each bin.

I would like to take this to the next level and “Order Material” from our warehouse using the summed rates compared to a variable that has not been defined yet.

My vision of a solution would be similar to an Alarm history on a machine. As the current material usage is depleted to a Value (to be defined), a line in a table populates with data to request more of that material. We would also like to store these requests to report on in the future.

Has anyone created something similar to this that could share some ideas?