End Activity Print Tag show original Operation and Next Operation

I am trying to create a Material Tag Label that will be printed from the MES - End Activity.

We have AMM and currently Epicor prints out the NextJobAsm and NextJobOpr in the MtlTag dataset for SSRS.

I need to show the both the “From” and the “To” on the label.

I tried setting the CallContextBpmData.Number01 using a preprocess BPM off of the Labor.EndActivity method. If i create a message in the Bpm i can see the correct information (the current Operation). However that CallContextBpmData.Nu0mber01 does not appear to be making it to the print Tag.

Anyone done this before? any Suggestions appreciated?
DaveO

1 Like

can you join JobOper to the report data definition?

Cause if you can do that I think you can do this.

Mr. Utah: Thank you for the suggestion.
I believe i need both the Assembly Seq and the OpSeq of the FromJobAsm.
I might be able to “Dump” the JobOper table and then try to figure it out in SSRS but that seems like a long way to go. If i could just get the Asm and Opr Seq of the operation i am performing the EndActivity - I would be good.

DaveO

There are several threads on here about pass CallContextBPMData to SSRS… I’ve never done it, personally. But there may be enough for you to piece it together.

1 Like

Mr. David: Thank you for the link. I did struggle earlier with SSRS Dataset. I needed to capitalize the C in CallContextBpmData and the “pm” in BPM is lower case.

That is working now - however, all of the CallContextBpmData fields are blank. It feels like the CallContextBpmData is for the PrintLabel and not for the Labor.EndActivity. I have not found the link to print part tag.

DaveO

What if you tried to add LaborDtl as a relationship in the RDD?

The active LaborDtl record would have your JobNum, AssemblySeq, & OprSeq.

image

Give that a shot. I was able to add that relationship in the RDD, add the below to my query:

Was able to get this sloppily thrown onto my label printed from End Activity:
image

I was currently ending activity on Assembly 0, Op 10:

image

You’ll need to test if that will work across various operation sequences, but it seems to work at first glance.

Mr. David: Thank you so much for the suggestion – for a minute there I thought you had the answer.
However, my only concern is that we would be joining by the Job number and ASM and NOT the Operation Seq.

I believe if you do not have AMM the Sequence number is the same as the operation you ending activity on. However, with AMM the Sequence number is the Next JobOprSeq.

Thank you for the suggestion – I had not even thought of making that join.

DaveO

I would do it like this using end activity and not receipt entry.

I have AMM and the result was the operation i was ending activity on. I’ll test it further in the AM.

Mr. David: Wondering if the qty is complete for your setup. My system shows the next Asm-OprSeq