Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

SQL report for PO20.1 form

 1 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
HDAustin13
Advanced Member
Posts: 31
Advanced Member
12/12/2018 4:55 PM
    Hello everyone,

    I am trying to create a sql report to get the data for PO and its contract info something like form PO20.
    I see there are fields from these tables: PURCHORDER, POLINE, MMDIST, REQHEADER, APVENMAST, APPPAYMENT, APPINVOICE, etc. but having difficulties in putting together with a query. Can any one please assist. Thanks in advance for your help!
    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
    12/14/2018 6:42 PM
      You need POLINESRC to connect PO Line to Requisition - and that's REQLINE - not header.

      To get from PO to Invoice you need MAINVDTL table.

      Welcome to Lawson.