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

[..hidden..]

Revision: 3111
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3111&view=rev
Author:   einhverfr
Date:     2011-01-06 18:07:15 +0000 (Thu, 06 Jan 2011)

Log Message:
-----------
Correcting fractional cent handling with outstanding report

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

Modified: trunk/LedgerSMB/AA.pm
===================================================================
--- trunk/LedgerSMB/AA.pm	2010-12-22 23:28:05 UTC (rev 3110)
+++ trunk/LedgerSMB/AA.pm	2011-01-06 18:07:15 UTC (rev 3111)
@@ -818,7 +818,8 @@
 		          min(a.duedate) as duedate, 
 		          sum(a.netamount) as netamount, 
 		          sum(a.amount) as amount, 
-		          sum(a.amount) - sum(acs.amount) AS paid,
+		          sum(a.amount::numeric(20,2)) 
+                             - sum(acs.amount::numeric(20,2)) AS paid,
 		          vce.name, vc.meta_number,
 		          a.entity_id, 
 		          d.description AS department, 
@@ -844,7 +845,9 @@
         } else {
             $query = qq|
 		   SELECT a.id, a.invnumber, a.ordnumber, a.transdate,
-		          a.duedate, a.netamount, a.amount, a.amount - sum(acs.amount) AS paid,
+		          a.duedate, a.netamount, a.amount, 
+                          a.amount::numeric(20,2) 
+                          - sum(acs.amount::numeric(20,2)) AS paid,
 		          a.invoice, a.datepaid, a.terms, a.notes,
 		          a.shipvia, a.shippingpoint, 
 		          vce.name, vc.meta_number,


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