PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 2/28/2023 10:16 PM by  John Henley
how to run report in Lawson Addins
 4 Replies
 0 Subscribed to this topic
 45 Subscribed to this forum
Sort:
You are not authorized to post a reply.
Author Messages
berban35
IT
Private
Basic Member
(19 points)
Basic Member
Posts:9


Send Message:

--
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
    Private
    Private
    Senior Member
    (9980 points)
    Senior Member
    Posts:3344


    Send Message:

    --
    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
    IT
    Private
    Basic Member
    (19 points)
    Basic Member
    Posts:9


    Send Message:

    --
    2/28/2023 2:42 PM
    Thank you
    berban35
    IT
    Private
    Basic Member
    (19 points)
    Basic Member
    Posts:9


    Send Message:

    --
    2/28/2023 3:56 PM
    i am Missing the ereq description in the report.
    John Henley
    Private
    Private
    Senior Member
    (9980 points)
    Senior Member
    Posts:3344


    Send Message:

    --
    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.