SQL - View 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
	)



SQL - Update / View transactions with more than 2 decimals in Evolution

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)