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

[..hidden..]

Revision: 2782
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2782&view=rev
Author:   aurynn_cmd
Date:     2009-11-05 23:17:48 +0000 (Thu, 05 Nov 2009)

Log Message:
-----------
Update to adjust the HAVING statements in transactions to 0.000 from 0.005.

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

Modified: trunk/LedgerSMB/AA.pm
===================================================================
--- trunk/LedgerSMB/AA.pm	2009-11-05 21:55:58 UTC (rev 2781)
+++ trunk/LedgerSMB/AA.pm	2009-11-05 23:17:48 UTC (rev 2782)
@@ -205,7 +205,7 @@
                 amount         => $amount{fxamount}{$i},
                 project_id     => $project_id,
                 description    => $form->{"description_$i"},
-		taxformcheck   => $form->{"taxformcheck_$i"},
+                taxformcheck   => $form->{"taxformcheck_$i"},
                 cleared        => $cleared,
                 fx_transaction => 0
               };
@@ -218,7 +218,7 @@
                     amount         => $amount,
                     project_id     => $project_id,
                     description    => $form->{"description_$i"},
-		    taxformcheck   => $form->{"taxformcheck_$i"},
+                    taxformcheck   => $form->{"taxformcheck_$i"},
                     cleared        => $cleared,
                     fx_transaction => 1
                   };
@@ -842,7 +842,7 @@
 		 GROUP BY 
 		          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.005 |;
+		   HAVING abs(sum(a.amount) - (sum(a.amount) - sum(acs.amount))) > 0.000 |;
         } else {
             $query = qq|
 		   SELECT a.id, a.invnumber, a.ordnumber, a.transdate,
@@ -872,7 +872,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.005 |;
+		   HAVING abs(a.amount - (a.amount - sum(acs.amount))) > 0.000 |;
        } 
     } else {
         $query = qq|


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