Prev
Next
Forums Lawson S3 Supply Chain

Crystal Report

Sort:
You are not authorized to post a reply.
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.
      You are not authorized to post a reply.