Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Crystal Report

 1 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
LisaLisa
Advanced Member
Posts: 31
Advanced Member
12/3/2014 6:08 PM

    I have a Crystal Report in which I need to include the following information:

    - Current Base UOM

    - (Item) Stocked Locally through the Current Distributor - Yes or No

    Do you know where (table, screen, etc.) I can find this data? 

    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    12/3/2014 6:17 PM
      Lisa: Generally speaking I'd go to whichever Lawson screen has the information... Preferably where you'd enter the information...
      Then position my cursor and do a Ctrl-Shift-O

      On the status bar you should see a 3-letter abbreviation for the table followed by the field name.

      If you have difficulties deciphering what the 3-letter abbreviations are.. go into Lawson Addins. Select 'Database Tables' Click Next
      Enter the 3-letter abbreviation into the 'Prefix' field and hit the tab key. The table and the system code to which it belongs (In parenthesis) will be displayed.