Prev
Next
Forums Lawson S3 Procurement

how to run report in Lawson Addins

Sort:
You are not authorized to post a reply.
Author
Messages
berban35
Basic Member
Posts: 9
Basic Member
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: 3351
    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.
      Thanks for using the LawsonGuru.com forums!
      John
      berban35
      Basic Member
      Posts: 9
      Basic Member
      2/28/2023 2:42 PM
        Thank you
        berban35
        Basic Member
        Posts: 9
        Basic Member
        2/28/2023 3:56 PM
          i am Missing the ereq description in the report.
          John Henley
          Posts: 3351
          2/28/2023 10:16 PM
            REQ-DESC should be the description field.
            Thanks for using the LawsonGuru.com forums!
            John
            You are not authorized to post a reply.