MES Production Tab displaying Part number

Epicor ERP 9
1

Is there anyone out there using MES for labor transactions? If so, do you know of a way to pull in the part number in the grid view on the Production tab? It is a collection from the labor detail table. You can view Job number, resource, JC Dept, but neither Part number or Part description are available to check as visible. Our users have repeatedly requested that we add part number to the view, but to date I have not been able to do so.
Any suggestions?

2

it’s slightly more lame, but it requires no code and is fairly straight forward. Create a foreign key view i believe to the JobAsmbl table and link job/assemblyseq,to the dataview that controls active transactions (going from memory here) add a text box just above the grid and bind it to JobAsmbl.PartNum. If they are clocked in to more than one direct labor activity they can click on the row they want to display the part number for. This could solve it for you fairly simple, other solutions such as adding columns to the grid are very doable but require code and slow things down, or require replacing the standard grid with your own custom epidataview or baqview.

HTH

1 Like
3

Good morning Rob,

Thank you, I will certainly give that a try today.

If I have any questions, do you mind if I email you?

Thanks
Carol

4

Rob,

This worked great for regular production jobs, however, the request for this addition came from our Maintenance department and maintenance jobs are tied to Equip ID rather than part number. Therefore, I need to somehow connect to the MaintReq table. Any thoughts or suggestions on what I could use for a FKV?

I will continue to try a variety of things and see what I come up with. If I find a solution, before any suggestions, I will let you know.

Thanks

Carol

5

Rob,
Looking at this a little closer and I discovered that Equip ID was included in the Job Assembly table. Works great!!
Thanks so much for your help.
Carol

1 Like
6

awesome! Mark solved if you would :slight_smile:

7

Rob,
I am embarrassed to admit that I haven’t used the site extensively yet, so can you please tell me where I mark it as solved.

Thank you!!
Carol

8

Near where you have the like (heart) and reply there is a checkbox icon.

9

image.png848×397 33.9 KB

10

Thanks Chris,
The reason I wasn’t seeing it is because I was just viewing the responses. I guess it helps to Log In … (Geez … you would think it was a Monday!)

Happy Tuesday!!
Carol

1 Like