[Weberp-svn] SF.net SVN: weberp:[8994] trunk

[<tim...@us...>]

Revision: 8994
          http://weberp.svn.sourceforge.net/weberp/?rev=8994&view=rev
Author:   tim_schofield
Date:     2012-06-07 08:26:11 +0000 (Thu, 07 Jun 2012)
Log Message:
-----------
Pak Ricard: Correct rounding for different currency decimalpalces

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

Modified: trunk/AgedDebtors.php
===================================================================
--- trunk/AgedDebtors.php	2012-06-07 08:25:58 UTC (rev 8993)
+++ trunk/AgedDebtors.php	2012-06-07 08:26:11 UTC (rev 8994)
@@ -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.005";
 
 	} elseif ($_POST['All_Or_Overdues']=='OverduesOnly') {
 

Modified: trunk/AgedSuppliers.php
===================================================================
--- trunk/AgedSuppliers.php	2012-06-07 08:25:58 UTC (rev 8993)
+++ trunk/AgedSuppliers.php	2012-06-07 08:26:11 UTC (rev 8994)
@@ -56,7 +56,7 @@
 						paymentterms.terms,
 						paymentterms.daysbeforedue,
 						paymentterms.dayinfollowingmonth
-				HAVING SUM(supptrans.ovamount + supptrans.ovgst - supptrans.alloc) <>0";
+				HAVING ROUND(SUM(supptrans.ovamount + supptrans.ovgst - supptrans.alloc),currencie.decimalplaces) <>0";
 
 	} else {
 

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