SF.net SVN: ledger-smb: [2067] trunk/LedgerSMB/AA.pm

[..hidden..]

Revision: 2067
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2067&view=rev
Author:   einhverfr
Date:     2008-01-30 15:10:38 -0800 (Wed, 30 Jan 2008)

Log Message:
-----------
Correcting issue with AP Outstanding Report showing apparently paid invoices when roundoff errors occur.

Modified Paths:
--------------
    trunk/LedgerSMB/AA.pm

Modified: trunk/LedgerSMB/AA.pm
===================================================================
--- trunk/LedgerSMB/AA.pm	2008-01-30 20:25:16 UTC (rev 2066)
+++ trunk/LedgerSMB/AA.pm	2008-01-30 23:10:38 UTC (rev 2067)
@@ -816,7 +816,7 @@
 		          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|


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.