[Web-erp-svn] SF.net SVN: web-erp:[7693] trunk/CustomerAllocations.php

[<ex...@us...>]

Revision: 7693
          http://sourceforge.net/p/web-erp/reponame/7693
Author:   exsonqu
Date:     2016-12-02 08:48:17 +0000 (Fri, 02 Dec 2016)
Log Message:
-----------
02/12/16 Exson: Fixed the wrong balance in Customer Allocations when customer receipt is positive in CustomerAllocations.php.

Modified Paths:
--------------
    trunk/CustomerAllocations.php

Modified: trunk/CustomerAllocations.php
===================================================================
--- trunk/CustomerAllocations.php	2016-12-02 07:57:52 UTC (rev 7692)
+++ trunk/CustomerAllocations.php	2016-12-02 08:48:17 UTC (rev 7693)
@@ -577,7 +577,8 @@
 			$BalSQL= "SELECT SUM(ovamount+ovgst+ovfreight+ovdiscount-alloc) as total
 						FROM debtortrans
 						WHERE (type=12 OR type=11)
-						AND debtorno='" . $myrow['debtorno'] . "'";
+						AND debtorno='" . $myrow['debtorno'] . "'
+						AND ovamount<0";
 			$BalResult = DB_query($BalSQL);
 			$BalRow = DB_fetch_array($BalResult);
 			$Balance = $BalRow['total'];