Prev
Next
Forums Lawson S3 Supply Chain

Total number of PO Lines By Vendor

Sort:
You are not authorized to post a reply.
Author
Messages
SCMaster-jk2
Veteran Member
Posts: 100
Veteran Member
6/23/2016 7:29 PM

    I'm trying to run a report on the total number of PO lines for particular vendor. Is there any way to do this other than dumping full PO history and counting the lines?

    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
    6/23/2016 7:52 PM
      PO54 will sum it up at the top of the inquire result - PO Count, Line Count and Extended Totals.
      David Williams
      Veteran Member
      Posts: 1127
      Veteran Member
      6/23/2016 8:45 PM
        You can run your query by the PO header records for their vendor and the lines total there.
        David Williams
        SCMaster-jk2
        Veteran Member
        Posts: 100
        Veteran Member
        6/24/2016 5:12 PM
          Hey David - not sure exactly what you mean. When I query the PURCHORDER table using VENDOR and NBR-LINES, I sort of get what I want but it still separates it out by PO, so I get a ton of rows instead of just one line per vendor and their total PO lines.

           

          @Kat - PO54 has exactly what I want, except I'd like it to be exported to Excel with every single vendor and their aggregate line totals.

          JonA
          Veteran Member
          Posts: 1162
          Veteran Member
          6/27/2016 1:22 PM
            If you have Crystal use David's method. Query PURCHORDER and group by vendor. Add a summation for NBR-LINES to the group. Then you can export that to Excel.
            Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
            You are not authorized to post a reply.