SELECT  CASE WHEN I.STATUS = 9 
	  THEN 'Invoice' 
	  ELSE 'Return' 
 	END AS DOCTYPE, 
       	I.ORDER_NO, I.ORDER_DATE,  
       	CASE WHEN I.STATUS = 9 
	  THEN SUM(X.QTY_SHIP) 
	  ELSE SUM(X.QTY_SHIP * -1) 
	END AS CARTONS,
       	CASE WHEN I.STATUS = 9 
	  THEN SUM(CASE WHEN (IT.SALE_MEAS = 'CARTON' or IT.SALE_MEAS = '8/25-PK') THEN X.QTY_SHIP * 10 ELSE X.QTY_SHIP * 5 END) 
	  ELSE -1 * SUM(CASE WHEN IT.SALE_MEAS = 'CARTON' THEN X.QTY_SHIP * 10 ELSE X.QTY_SHIP * 5 END) 
	END AS Packs,
	C.CUST_CODE, A.STATE
FROM INVOICES I WITH (NOLOCK)
INNER JOIN X_INVOIC X WITH (NOLOCK) ON I.DOC_NO = X.ORDER_NO AND I.STATUS = X.STATUS
INNER JOIN ITEMS IT WITH (NOLOCK) ON X.ITEM_CODE = IT.ITEMNO
INNER JOIN CUST C ON I.CUST_CODE = C.CUST_CODE
INNER JOIN ADDRESS A ON C.CUST_CODE = A.CUST_CODE
WHERE I.STATUS IN (9,12)
AND A.TYPE = 5
AND IT.CATEGORY IN ('CIGS','CIGSSPL','CIGS25')
AND (I.ORDER_DATE >= '01/01/2008') AND (I.ORDER_DATE < '1/01/2009')
GROUP BY I.ORDER_DATE, I.ORDER_NO, A.STATE, I.STATUS, C.CUST_CODE
ORDER BY I.ORDER_DATE, I.ORDER_NO

--- YOUR CURRENT JOIN CONDITION
INNER JOIN ADDRESS A
		ON  C.CUST_CODE = A.CUST_CODE
		
-- REPLACE IT WITH THIS
	INNER JOIN 
		( 
			SELECT 
				a.CUST_CODE, 
				MAX(a.STATE) AS STATE 
			FROM 
				ADDRESS a
			WHERE
				a.TYPE=5
			GROUP BY 
				a.CUST_CODE 
		) A
		ON  C.CUST_CODE = A.CUST_CODE