Machine IDs

(0) Share

Report

Posted on by Community Member

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

*This post is locked for comments

All responses (4)

Answers (2)

Community Member on at

Like (0)

Report

Re: Machine IDs

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

PD
Verified answer

GPDavid 2,250 on at

Like (0)

Report

Re: Machine IDs

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

David
Community Member on at

Like (0)

Report

Re: Machine IDs

This is great. Now, which table holds the items that have been assiged (routing) to these machine IDs?

Thank you
Verified answer

GPDavid 2,250 on at

Like (0)

Report

Re: Machine IDs

Assuming you are referring to machines in Manufacturing module, then you might start with the Machine Master table (MM010032).

David