Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Supply Chain Management
Lawson S3 Supply Chain
Report needed for Average number of PO lines on an Invoice
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
NonnieBear1776
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5161
People Online:
Visitors:
291
Members:
0
Total:
291
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 Supply Chain
Report needed for Average number of PO lines on an Invoice
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
9/1/2015 9:05 PM
Is there a way to run a report out of Lawson that will capture the number of PO lines on invoices for the last 365 days?
Amanda Valcik
Advanced Member
Posts: 28
9/1/2015 9:25 PM
Not a straight canned report. You could probably use a MM280 but would have to export it and do some manual aggregation. Would probably be easier to use the MS AddIns to get the exact data you want and then do some aggregation from there.
JonA
Veteran Member
Posts: 1162
9/2/2015 12:16 PM
Take a look at AP295. It has a total for matched lines for the date range you enter.
JonA
Veteran Member
Posts: 1162
9/2/2015 12:33 PM
Although I just queried our MAINVDTL table in Crystal and only returned 12,300 matched PO lines for August while the AP295 report is giving me 23,300. So I'm not sure what AP295 is actually showing me.
You are not authorized to post a reply.