summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-01-30 23:10:38 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-01-30 23:10:38 +0000
commit60efea9ce065418e38761923bc88a018861a3ebd (patch)
tree40858e7829a5ed21818835af91e7cb64be78a33c
parent4815ab592f3bfc992f25c0ea6c25929fbfa0ab4b (diff)
Correcting issue with AP Outstanding Report showing apparently paid invoices when roundoff errors occur.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2067 4979c152-3d1c-0410-bac9-87ea11338e46
-rw-r--r--LedgerSMB/AA.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/LedgerSMB/AA.pm b/LedgerSMB/AA.pm
index 0834d255..a8c712b8 100644
--- a/LedgerSMB/AA.pm
+++ b/LedgerSMB/AA.pm
@@ -816,7 +816,7 @@ sub transactions {
a.amount, a.terms, a.notes, a.shipvia, a.shippingpoint, vce.name,
vc.meta_number, a.entity_id, a.till, ex.$buysell, d.description,
a.ponumber, a.invoice, a.datepaid $acc_trans_fields
- HAVING sum(acs.amount)::numeric(15,2) <> 0|;
+ HAVING a.amount::numeric(15,2) <> (a.amount::numeric(15,2) - sum(acs.amount))::numeric(15,2) |;
} else {
$query = qq|