Our client would like to have an Approval process fire when a user tries to close a Production Order that has a variance. I have looked in the tables and the variance view but I'm not sure how to create a query to analyze it when closing a Production Order.
Has anyone done anything like this or have a working query that calculates variance at a given time?