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;
}
|
