Who's On?

	Membership:
	Latest: sakkatan
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 5216

	People Online:
	Visitors: 19
	Members: 0
	Total: 19

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
Chesca	1042

AP Productivity Query

2 Replies

0 Subscribed to this topic

44 Subscribed to this forum

Sort:

Author

Messages

Billi

New Member

Posts: 1

2/17/2012 4:29 PM

We are looking for a query that can pull how many invoices and lines have been keyed by employee for a given time period. I am having a bit of a hard time trying to figure out fields I can pull to get this information? Any thought?
Thanks.

John Henley

Posts: 3364

New Poster

Engaged Reader

Avid Reader

2/17/2012 5:03 PM

Like this?
https://www.danalytics.com/Portals/1/images/products/da215.jpg

Robert Spurr

Veteran Member

Posts: 130

New Poster

2/17/2012 6:28 PM

If you were looking for and SQL option this should get you start. Groups and counts by Company,Year,Month,Operator

select apv.company as Company,
to_char(apv.create_date, 'MONTH') as Month,
to_char(apv.create_date, 'YYYY') as Year,
apv.operator as Clerk,
count(*) as Invoice_Qty
from lawson.apinvoice apv
group by apv.company, to_char(apv.create_date, 'MONTH'),
to_char(apv.create_date, 'YYYY'), apv.operator