• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Total number of PO Lines By Vendor

 4 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
SCMaster-jk2
Veteran Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 1163
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