SQL - Transactions out of balance by Audit Number

SELECT * FROM PostGL
	WHERE cAuditNumber IN (
		SELECT cAuditNumber FROM PostGL GROUP BY cAuditNumber HAVING ROUND(SUM(Debit-Credit),2) <> 0
	)


--And now transactions out by more than 1 cent.
SELECT cAuditNumber, * FROM PostGL
    WHERE cAuditNumber IN (
        SELECT cAuditNumber FROM PostGL GROUP BY cAuditNumber HAVING ABS(ROUND(SUM(Debit-Credit),2)) > 0.01
    )
    AND Period > 0 --excludes CB unreconciled tx from prior years.
    ORDER BY PostGL.cAuditNumber

  SELECT cAuditNumber, ROUND(SUM(Debit-Credit),2) FROM PostGL GROUP BY cAuditNumber HAVING ROUND(SUM(Debit-Credit),2) <> 0

select * from PostGL where ROUND(Debit+Credit,4) <> Round(debit+credit,2)

update PostGL set debit = round(debit,2), credit = round(credit,2) where ROUND(Debit+Credit,4) <> Round(debit+credit,2)