• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Crystal Reports - Link ICTRANS with APVENMAST

 3 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Alicia
New Member Send Private Message
Posts: 0
New Member
10/6/2014 7:16 PM
I have a Crystal Report which consists of ICTRANS fields.  I need to pull in the Vendor Number and Vendor Name associated with the ICTRANS Item Number.  The APVENMAST table contains the Vendor data that I need.  Is it possible to link ICTRANS with APVENMAST (or some other table) to get the Vendor Number and Name?  FYI, currently, the Crystal Report consists of the following tables:  ICITLUF, ICMXVAL, ICTRANS, ITEMLOC, ITEMMAST.
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
10/6/2014 10:17 PM
You're on the right track. Try adding ITEMSRC (connect to ITEMLOC) . Connect APVENMAST to ITEMSRC.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
Alicia
New Member Send Private Message
Posts: 0
New Member
10/7/2014 1:35 PM
Ok, I will give it a try.  Thanks, Jon!
Alicia
New Member Send Private Message
Posts: 0
New Member
10/7/2014 7:32 PM
Thanks again, Jon!  I was able to get the link to work as you suggested.