• Search Forums
    Advanced Search Topics Posts
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
New Member Send Private Message
Posts: 0
New 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 Send Private Message
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.