GP Total invoiced quantity per item, per customer

SELECT
m.CUSTNMBR, d.ITEMNMBR,
d.ITEMDESC, SUM(d.QUANTITY) AS 'Total_QTY'
FROM SOP30200 m
inner Join SOP30300 d on m.SOPNUMBE = d.SOPNUMBE
WHERE Year(m.docdate) = 2007 AND m.SOPTYPE = 3
GROUP BY
m.CUSTNMBR, d.ITEMNMBR, d.ITEMDESC