Skip to Content
0
Aug 07, 2023 at 12:53 PM

Business One Production Order Variance Alert Query

65 Views

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?