From 60efea9ce065418e38761923bc88a018861a3ebd Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Wed, 30 Jan 2008 23:10:38 +0000
Subject: 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
---
 LedgerSMB/AA.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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|
-- 
cgit v1.2.3