Great topic, AA. This is the classic bottleneck we see when companies start scaling up their purchasing.
We usually push for summarizing by Cost Code.
If you try to replicate the Sales Order line-for-line, you're just creating a data entry nightmare for AP. We try to teach PMs that a PO is a financial bucket, not a shopping list.
Using your ABC Supply example: If that order has 12 items but they all fall under "Roofing Material" and "Safety," the PO should just have those 2 lines.
As long as the Total $ matches the bill (within a small tolerance), AP processes it without flagging every 50-cent variance on a box of nails. Usually keeps the PMs happy because it's faster to enter, but keeps the costs hitting the right GL.
Hope that helps!
------------------------------
Raphael Merlo
Fractional CFO
Bond CFO
Birmingham MI
(313) 566-3254
------------------------------