In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
#AcumaticaTnT Finding production order operations that have NO transactions
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 🙂