Hi guys sorry if this seems stupid but I'm a newbie to GP 2018
I'm trying to use a SQL Server 2012 query to view the actual items consumed by a MO versus the planned items to consume, during a test run of our production process.
The idea is to see what's consumed at each step of the production process, users will scan after each operation is finished, then I'll run the query to see what was consumed in that operation.
So far I've found these tables MOP1100 for master and MOP1110 for the detail, are these the correct tables?
Any help would be greatly appreciated.
Best regards
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156