Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5205

	People Online:
	Visitors: 285
	Members: 0
	Total: 285

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

how to run report in Lawson Addins

4 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

berban35

Basic Member

Posts: 9

2/28/2023 1:55 PM

How to run a report in Addins that shows all req that shows all (NAme,req,descr,vendor,date)

John Henley

Posts: 3353

2/28/2023 2:38 PM

Using Lawson Excel query wizard, select query source "database tables", then your product line, system code RQ (requisitions), and REQHEADER as the table. You'll probably want fields COMPANY, REQ-LOCATION, REQUESTER, REQ-NUMBER, REQ-DEL-DATE, REQ-DESC, VENDOR, and VENDOR-NAME. Depending on your requirements, you will also want to include some selection criteria, such as a condition like "APPROVED" or something.

berban35

Basic Member

Posts: 9

2/28/2023 2:42 PM

Thank you

berban35

Basic Member

Posts: 9

2/28/2023 3:56 PM

i am Missing the ereq description in the report.

John Henley

Posts: 3353

2/28/2023 10:16 PM

REQ-DESC should be the description field.