By using this website, you agree to our Terms of Use (click here)
At the AUGForums.com Live https://www.augforums.com/live11/ , @ryanxbyte asked how we could find production order operations on a routing that have no transactions entered. This can be accomplished using a left join between the AMProdOper DAC which contains the routing, and the AMMTran table that contains the transactions.
After linking the two classes on the ProdOrdID, OrderType, and OperationID fields, then we can search for records where a key field in the child table (e.g. AMMTran.ProdOrdID) is empty.
See attached XML export with the final results.
This GI will return all operations that have not been started, including that have not been "skipped" but are simply later in the routing. To extend this and look for the skipped operations only will be the subject of another future post 🙂
- Laura
Online Members
