Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

Crystal links between ICTRANS and ITEMMAST

 1 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
nwhitacre
New Member
Posts: 4
New Member
11/13/2013 4:28 PM
    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
    Posts: 3353
    11/13/2013 6:23 PM
      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