Report needed for Average number of PO lines on an Invoice

Sort:
You are not authorized to post a reply.
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member
    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
    Posts: 28
    Advanced Member
      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
      Posts: 1162
      Veteran Member
        Take a look at AP295. It has a total for matched lines for the date range you enter.
        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        JonA
        Veteran Member
        Posts: 1162
        Veteran Member
          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.
          Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
          You are not authorized to post a reply.