jmcilhinney,
I don't mind returning the PK. I'll just ignore it. If I include the PK, it messes up the GROUP BY and I get all records returned. Is there a way around this? Here's the updated query:
SELECT ShippingID, CustomerID, SUM(PPA) AS 'CustomerPay', SUM(ABS) AS 'TechPay'...