GP Customer Balance

SELECT distinct(T143.DOCNUMBR) AS Doc_No,T141.CUSTNMBR AS Customer_ID, T143.DOCDATE AS Doc_Date,T141.SLPRSNID, T143.POSTDATE AS Posting_Date,
CASE WHEN RMDTYPAL = 8 OR RMDTYPAL = 9 OR RMDTYPAL = 7 THEN CAST(T143.CURTRXAM * - 1 AS NUMERIC(19, 5)) ELSE CAST(T143.CURTRXAM * 1 AS NUMERIC(19, 5)) END AS AMOUNT,
T143.CURNCYID AS Curr_ID, T143.BCHSOURC AS Doc_Type FROM RM00101 AS T141 LEFT OUTER JOIN RM20101 AS T143 ON T141.CUSTNMBR = T143.CUSTNMBR AND T143.RMDTYPAL <> 6 AND T143.RMDTYPAL <> 2 AND
T143.VOIDSTTS = 0 LEFT OUTER JOIN RM20201 AS T150 ON T143.RMDTYPAL = T150.APTODCTY AND T143.DOCNUMBR = T150.APTODCNM LEFT OUTER JOIN RM00103 AS T161 ON T141.CUSTNMBR = T161.CUSTNMBR
WHERE (T143.RMDTYPAL <> 6 OR T143.RMDTYPAL IS NULL) AND (T143.RMDTYPAL <> 2 OR T143.RMDTYPAL IS NULL) AND (T143.VOIDSTTS = 0 OR T143.VOIDSTTS IS NULL) AND
(T143.CURTRXAM <> 0) ORDER BY T143.DOCNUMBR,Customer_ID