I've been tasked with creating a SQL report that reports on actual prod order consumption vs expected consumption. This is basically a variance report but instead of on the dollars, the actual quantities.
What is the best way to go about doing this? Comparing the ILE's with the Prod_ Order Component lines?
We have found that people are finishing prod orders differently, some people are adjusting the Production Journal to post actual usage and some people are changing the "Qty Per" on the Prod Order Components. So using the "Remaining Qty" column in the Prod_ Order Component line won't work.
Is there another place/way I can find the actual vs expected component consumption?