Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
Version 1
Next »
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)