Forums
Lawson S3 Procurement
how to run report in Lawson Addins
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
Senior Member
Posts: 3348
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
Senior Member
Posts: 3348
2/28/2023 10:16 PM
REQ-DESC should be the description field.