Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 82
	Members: 0
	Total: 82

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

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

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

New Poster

Engaged Reader

Avid Reader

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.