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
Basic Member
Posts: 14
Basic 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
    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
      Basic Member
      Posts: 14
      Basic Member
      10/7/2014 1:35 PM
        Ok, I will give it a try.  Thanks, Jon!
        Alicia
        Basic Member
        Posts: 14
        Basic Member
        10/7/2014 7:32 PM
          Thanks again, Jon!  I was able to get the link to work as you suggested.