[Web-erp-svn] SF.net SVN: web-erp:[7618] trunk/includes/SQL_CommonFunctions.inc

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

Revision: 7618
          http://sourceforge.net/p/web-erp/reponame/7618
Author:   exsonqu
Date:     2016-09-12 02:35:30 +0000 (Mon, 12 Sep 2016)
Log Message:
-----------
12/09/16 Exson: Add a filter to avoid tons of zero valued gl transaction records generated in SQL_CommonFunctions.inc.

Modified Paths:
--------------
    trunk/includes/SQL_CommonFunctions.inc

Modified: trunk/includes/SQL_CommonFunctions.inc
===================================================================
--- trunk/includes/SQL_CommonFunctions.inc	2016-09-10 09:07:58 UTC (rev 7617)
+++ trunk/includes/SQL_CommonFunctions.inc	2016-09-12 02:35:30 UTC (rev 7618)
@@ -221,7 +221,9 @@
 	$MyRow = DB_fetch_row($result);
 	$MaterialCost = $MyRow[0];
 	$Result = DB_Txn_Begin();
-	ItemCostUpdateGL($db, $Parent, $MaterialCost, $OldCost, $QOH);
+	if (abs($MaterialCost-$OldCost)>0) {
+		ItemCostUpdateGL($db, $Parent, $MaterialCost, $OldCost, $QOH);
+	}
 	$Result = DB_Txn_Commit();
 	return $MaterialCost;
 }