I’ll start putting together screen shots. The basic steps in the SQL job are below. @Rick_Bird It runs a time phase for each job material on released jobs, so somewhat like multilevel pegging. Then compares the available quantity on the material due date for that material. If the quantity is negative then it gets the next PO that will fulfill the entire shortage, not necessarily the next PO of any quantity.
I don’t look at supply jobs, but I think the theory would be the same as POs.
Another thing I recently did was an idea from @Beth to add a soft link on the make to stock tab for the order this make to stock is fulfilling. If the component jobs held a list of jobs they were supplying that could also be used for an alert that job X that supplies job Y has a new due date past the material required date of job Y. The sql job would only get this once per day, but a link could be used in a real time alert.
Greg
