Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Enterprise Resource Planning & Manufacturing
Lawson S3 Procurement
SQL report for PO20.1 form
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jessica
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5164
People Online:
Visitors:
292
Members:
0
Total:
292
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 Procurement
SQL report for PO20.1 form
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
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
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.
You are not authorized to post a reply.