• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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.