E9.05.701 Material Tags printed from MES

Epicor ERP 9
1

I am just going to throw this out there to see if anyone would have a suggestion on how to get the Employee ID / Name printed on the Material tag generated from Report quantity in MES. We have had a request to somehow get this information on the tag, but I am struggling with how to create the relationship in the RDD.
Any ideas / suggestions?

Thanks much!
Carol

2

Since they are printing while in the job - I added the Labor Detail to the Material tag. That is how I get the Employee’s name on the Material tag.

3

Cathy,

Good morning and thank you!

I haven’t worked with RDD’s that much, so may I ask how you created your relationship to the Labor Detail?

Thanks much!
Carol

4

Cathy,
I added the Labor Detail to the Material Tag, but it is pulling in a different employee name, not the one who is working on the job at that time and printing the tag.

Where do you have your join?

Thanks
Carol

5

In the Report Data Definition - it is linked by:

1 Company Company
2 JobNum JobNum
3 AsmSeq AssemblySeq

Then in Report Data Definition > Report Table > Criteria -

ActiveTrans - is constant with RValue = True.

6

Good morning Cathy,

In the Report Data Definition I had the Labor Detail table linked as per your example.
I have never added criteria to a table previously, but I did create the criteria as you described.
However, I am not seeing where you set the RValue to true.
[cid:image001.png@01D2BF2E.D250B0B0]

I hope I am not asking a stupid question…

Thanks

Carol

image001.png1334×142 8.04 KB

7

Cathy …
I tried it with the Constant Bool checked (my guess this sets it to True) and it worked like a charm.
Thank you so much for your help!!

Carol

8

Cathy,

This works wonderfully … I thank you so much for you help and input. I took this one step further and tried to add the current operation to the material tag. This also works great, however, if by some chance the operator is logged in to the same job but 2 operations. Let’s say grind and bench (op’s 10 & 25). If he reports quantity to op 25 it pulls in op 10 as the current operation because that is his first active transaction.
Do you have a suggestion that would tie the current op to the line selected?

image.png758×64 2.94 KB

I tried a few other criteria variations, but it breaks the RDD.
Anyone out there have any suggestions?
Thanks
Carol