[Web-erp-svn] SF.net SVN: web-erp:[5430] trunk

[<te...@us...>]

Revision: 5430
          http://web-erp.svn.sourceforge.net/web-erp/?rev=5430&view=rev
Author:   tehonu
Date:     2012-06-07 08:04:05 +0000 (Thu, 07 Jun 2012)
Log Message:
-----------
Correct rounding for different currency decimalpalces

Modified Paths:
--------------
    trunk/AgedDebtors.php
    trunk/AgedSuppliers.php

Modified: trunk/AgedDebtors.php
===================================================================
--- trunk/AgedDebtors.php	2012-06-07 00:49:31 UTC (rev 5429)
+++ trunk/AgedDebtors.php	2012-06-07 08:04:05 UTC (rev 5430)
@@ -91,7 +91,7 @@
 					holdreasons.dissallowinvoices,
 					holdreasons.reasondescription
 				HAVING
-					ABS(SUM(debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount - debtortrans.alloc)) >0.005";
+					ROUND(ABS(SUM(debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount - debtortrans.alloc)),currencies.decimalplaces) > 0";
 
 	} elseif ($_POST['All_Or_Overdues']=='OverduesOnly') {
 

Modified: trunk/AgedSuppliers.php
===================================================================
--- trunk/AgedSuppliers.php	2012-06-07 00:49:31 UTC (rev 5429)
+++ trunk/AgedSuppliers.php	2012-06-07 08:04:05 UTC (rev 5430)
@@ -56,7 +56,7 @@
 						paymentterms.terms,
 						paymentterms.daysbeforedue,
 						paymentterms.dayinfollowingmonth
-				HAVING SUM(supptrans.ovamount + supptrans.ovgst - supptrans.alloc) <>0";
+				HAVING ROUND(ABS(SUM(supptrans.ovamount + supptrans.ovgst - supptrans.alloc)), currencies.decimalplaces) > 0";
 
 	} else {
 

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