AP Productivity Query

Sort:
You are not authorized to post a reply.
Author
Messages
Billi
New Member
Posts: 1
New Member
    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
    Senior Member
    Posts: 3348
    Senior Member
      Like this?
      https://www.danalytics.com/Portals/1/images/products/da215.jpg

      Thanks for using the LawsonGuru.com forums!
      John
      Robert Spurr
      Veteran Member
      Posts: 130
      Veteran Member
        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
        You are not authorized to post a reply.