SELECT * FROM (
        SELECT
        CONCAT(c.LASTNAME,', ',c.FIRSTNAME,' ',c.MIDDLENAME) AS Name,
        DATE(s.POSTDATE) POSTDATE,
        s.STATUS,
        DATE(s.START_DATE) TERMINATION_DATE,
        IF(b.BALANCE IS NULL, 0, b.BALANCE) BALANCE
        FROM
        `status` AS s
        INNER JOIN customers c ON c.CUSTOMER_ID = s.CUSTOMER_ID
        LEFT JOIN (
                SELECT
                i.CUSTOMER_ID,
                convert(Sum(i.AMOUNT),decimal(10,2)) AS BALANCE
                FROM
                invoices i
                INNER JOIN customers c ON c.CUSTOMER_ID = i.CHARGETO_CUSTOMER_ID
                WHERE
                i.VOIDEDINVOICE = 0 AND
                i.PAYMENT_ID < 1 
                GROUP BY
                i.CHARGETO_CUSTOMER_ID
        ) b ON b.CUSTOMER_ID = s.CUSTOMER_ID
        WHERE
        s.STATUS = 'TERMINATE' AND
        DATE(s.POSTDATE) = '{STARTDATE}' AND
                DATE(s.START_DATE) <= 
                CONCAT(
                        IF(
                                MONTH(DATE_ADD('{STARTDATE}',INTERVAL 1 MONTH)) = 1,
                                YEAR('{STARTDATE}')+1,
                                YEAR('{STARTDATE}')
                        ),
                        '-',
                        MONTH(DATE_ADD('{STARTDATE}',INTERVAL 1 MONTH)),
                        '-01')
)r
WHERE
r.BALANCE > 0