Who's On?

	Membership:
	Latest: navav4
	Past 24 Hours: 2
	Prev. 24 Hours: 0
	Overall: 5208

	People Online:
	Visitors: 403
	Members: 0
	Total: 403

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Crystal Report

1 Replies

0 Subscribed to this topic

38 Subscribed to this forum

Sort:

Author

Messages

LisaLisa

New Member

Posts: 0

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

MVP

New Poster

Engaged Reader

Avid Reader

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.