Material tags report

Epicor ERP 10
, , , ,
1

I am trying to add new field in material tag report but doesn’t pull the information in ssrs why?

When i click on print tag does not appear in the packslip label any idea why?

I created report data definition,

image
image840×335 18.8 KB

image
image789×573 21 KB

image
image806×486 20 KB

="SELECT
T1.AsmSeq,
T1.TagNum,
T1.BCAsmSeq,
T1.BCBinNum,
T1.BCJobNum,
T1.BCLotNum,
T1.BCOprSeq,
T1.BCPartNum,
T1.BCWhseCode,
T1.BinNum,
T1.ItemQty,
T1.JobNum,
T1.LaborNote,
T1.LotNum,
T1.NCComment,
T1.NonConfTranID,
T1.OpCode,
T1.OprSeq,
T1.PartNum,
T1.PartDesc,
T1.POLine,
T1.PONum,
T1.PORel,
T1.Reason,
T1.ReasonDesc,
T1.ResGrpID,
T1.Revision,
T1.TagFormat,
T1.TagTitle,
T1.UM,
T1.VendID,
T1.VendName,
T1.WhseCode,
T1.QtyNum,T3.InsLot_c

FROM MtlTags_"

  • Parameters!TableGuid.Value + " T1
    LEFT OUTER JOIN LaborDtl_" + Parameters!TableGuid.Value + " T2
    ON T1.JobNum = T2.JobNum AND T1.OprSeq = T2.OprSeq AND T1.AsmSeq = T2.AssemblySeq
    LEFT OUTER JOIN LaborDtl_UD_" + Parameters!TableGuid.Value + " T3
    ON T2.SysRowID = T3.ForeignSysRowID
    "

image
image374×544 29.6 KB

Any advise why did not showing up in the packing slip label?

2

Isn’t the UD fields on the normal table? I’ve never had to add the _UD table to get to UD fields.

3

it is in normal table too labordtl
can you provide me updated query?

4

I removed Ud table but still not getting information.

5

well stock MtlTags RDD doesn’t have LaborDtl so let me check

image
image187×165 2.54 KB

6

I added LaborDtl to our custom RDD for MtlTags and the UDs on that came came in;

image
image1215×528 31.1 KB

7

here is mine

image
image958×571 28.6 KB

8

what is the next step i should follow?

9

Make sure you also have the relationship fields also included: JobNum, OprSeq, AssemblySeq plus the ones you want to display.

10

image
image991×439 25.7 KB

="SELECT
T1.AsmSeq,
T1.TagNum,
T1.BCAsmSeq,
T1.BCBinNum,
T1.BCJobNum,
T1.BCLotNum,
T1.BCOprSeq,
T1.BCPartNum,
T1.BCWhseCode,
T1.BinNum,
T1.ItemQty,
T1.JobNum,
T1.LaborNote,
T1.LotNum,
T1.NCComment,
T1.NonConfTranID,
T1.OpCode,
T1.OprSeq,
T1.PartNum,
T1.PartDesc,
T1.POLine,
T1.PONum,
T1.PORel,
T1.Reason,
T1.ReasonDesc,
T1.ResGrpID,
T1.Revision,
T1.TagFormat,
T1.TagTitle,
T1.UM,
T1.VendID,
T1.VendName,
T1.WhseCode,
T1.QtyNum,T2.InsLot_c

FROM MtlTags_"

  • Parameters!TableGuid.Value + " T1
    LEFT OUTER JOIN LaborDtl_" + Parameters!TableGuid.Value + " T2
    ON T1.JobNum = T2.JobNum AND T1.OprSeq = T2.OprSeq AND T1.AsmSeq = T2.AssemblySeq

"

here is my ssrs
still not showing up why?

the Print Tags window pops up immediately as part of the same “session” as End Activity click
InsLot_c field does not show up when i click on print tag and try to print label

11

Some versions of Epicor also needed to have the SysRev and SysRow to be included. Did you make sure you changed your Report Style to use this RDD?

13

i did still doesn’t work any thoughts?

14

image
image789×573 21 KB

Change your relationship from MtlTag-LaborDtl to:

  • MtlTag.JobNum = JobNum
  • MtlTag.RefAsmSeq = AssemblySeq
  • MtlTag.OprSeq = OprSeq
15

tried it, doesnt work.

16

Ok, what is it you’re trying to do? Thinking about this more, you can have multiple labor transactions (LaborDtl) to a part. If you can link these two you’re going to end up with the potential of multiple labels for a MtlPart.