Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 196
	Members: 0
	Total: 196

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

Report needed for Average number of PO lines on an Invoice

3 Replies

1 Subscribed to this topic

38 Subscribed to this forum

Sort:

Author

Messages

Bev Edwards

Veteran Member Send Private Message

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 Send Private Message

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 Send Private Message

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 Send Private Message

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.