• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

AP Productivity Query

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Billi
New Member Send Private Message
Posts: 1
New Member
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
Send Private Message
Posts: 3351
2/17/2012 5:03 PM
Like this?
https://www.danalytics.com/Portals/1/images/products/da215.jpg

Thanks for using the LawsonGuru.com forums!
John
Robert Spurr
Veteran Member Send Private Message
Posts: 130
Veteran Member
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