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
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
    Posts: 3353
    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
      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