Link IM Item Table to JC Job Transaction Detail Report Work Table?

SOLVED

Hello,

Has anyone found a way to link IM_Item Table to the JC Job Transaction Detail Report Work Table?

We are looking to get an item description included along with a part number on the report when we view for material pricing purpose.

I am sure that it might take several jumps with UDFs between tables, but I cannot seem to find a path to get IM Item associated with the Job Trans Detail Report Wrk table.

Any help would be appreciated.

Thanks,

Jacob

  • +1
    verified answer

    I think you'll need to do a subreport (unless you can fiddle with the SQL linkage) using a mid-string from the Comment field to the CI_Item.ItemCode field. I know I've done it but can't find one handy to tell you exactly what the location of the item in the Comment field is.

  • 0 in reply to bethbowers

    Just wanted to say that after some messing around, this was the solution. We used a formula to extract the relevant item info and then used a subreport to link the return of that formula to the CI_Item.ItemCode value. Works like a charm.

    Appreciate the nudge in the right direction.