Crystal links between ICTRANS and ITEMMAST

Sort:
You are not authorized to post a reply.
Author
Messages
nwhitacre
New Member
Posts: 4
New Member
    ICTRANS has all the data I need but the DESCRIPTION from the ITEMMAST. Every time I try to link in Crystal, I lose my data from the ICTRANS. Can anyone tell me what I need to link in order to make this work? Thanks
    nfw
    John Henley
    Senior Member
    Posts: 3348
    Senior Member
      What field(s) are you using for the join? Ideally, you need to join thru ICCOMPANY to get the item group in addition to joining from ICTRANS to ITEMMAST on the ITEM field.
      I'm guessing you only have one item group, and you are joining directly from ICTRANS to ITEMMAST on just ITEM.
      If that's the case, make sure it's a left outer join.
      Thanks for using the LawsonGuru.com forums!
      John
      You are not authorized to post a reply.