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

Report needed for Average number of PO lines on an Invoice

3 Replies

1 Subscribed to this topic

39 Subscribed to this forum

Sort:

Author

Messages

Bev Edwards

Veteran Member

Posts: 366

New Poster

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

New Poster

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: 1163

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: 1163

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.