Mute Duck

Reference column alias (in where clause)

SELECT
    *
FROM (
    SELECT
        (Invoice_Total - Payment_Total - Credit_Total) AS [Balance_Due]
    FROM Invoices AS [Invoice_Details]
) AS [Table_Name]

WHERE
    [Table_Name].Balance_Due > 0;