SQL report for PO20.1 form

Sort:
You are not authorized to post a reply.
Author
Messages
HDAustin13
Advanced Member
Posts: 31
Advanced Member
    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
      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.
      You are not authorized to post a reply.