Notifications
Announcements
No record found.
I'm pretty new to GP and have an employee asking if I can generate a report listing all items with their machine IDs. Which tables should I be looking at?
Thanks in advance
PD
*This post is locked for comments
Assuming you are referring to machines in Manufacturing module, then you might start with the Machine Master table (MM010032).
David
This is great. Now, which table holds the items that have been assiged (routing) to these machine IDs?
Thank you
I can think of two places you might want to look depending on whether you are looking for active routings or planning routings. Active routings are those already assigned to an MO, whereas planning routings are independent of an MO:
--Active Routings
select MACHINEID_I, * from WR010130
--Planning Routings
select MACHINEID_I, * from RT010130
That did it. Thank you very much. I have found my new source for GP learning. This is a brand new company with a brand new GP install. Lots to learn from my part.
Thanks again
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
