[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



Revision: 3127
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3127&view=rev
Author:   einhverfr
Date:     2011-03-12 00:38:19 +0000 (Sat, 12 Mar 2011)

Log Message:
-----------
Fixing erroneous detection of closed invoices in outstanding report

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

Modified: trunk/LedgerSMB/AA.pm
===================================================================
--- trunk/LedgerSMB/AA.pm	2011-03-12 00:13:48 UTC (rev 3126)
+++ trunk/LedgerSMB/AA.pm	2011-03-12 00:38:19 UTC (rev 3127)
@@ -847,7 +847,7 @@
 		          vc.meta_number, a.entity_id, vce.name, 
                           d.description --,
 		          --a.ponumber, a.invoice 
-		   HAVING abs(sum(a.amount) - (sum(a.amount) - sum(acs.amount))) > 0.000 |;
+		   HAVING abs(sum(acs.amount::numeric(20,2))) > 0.000 |;
         } else {
             $query = qq|
 		   SELECT a.id, a.invnumber, a.ordnumber, a.transdate,
@@ -879,7 +879,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, vce.name,
 		          a.ponumber, a.invoice, a.datepaid $acc_trans_fields
-		   HAVING abs(a.amount - (a.amount - sum(acs.amount))) > 0.000 |;
+		   HAVING abs(sum(acs.amount::numeric(20,$p))) > 0 |;
        } 
     } else {
         $query = qq|


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