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

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

Revision: 7466
          http://sourceforge.net/p/web-erp/reponame/7466
Author:   exsonqu
Date:     2016-03-09 01:54:37 +0000 (Wed, 09 Mar 2016)
Log Message:
-----------
03/09/16 Exson: Fixed the typo which make sql query failed in GLPostings.inc.

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

Modified: trunk/includes/GLPostings.inc
===================================================================
--- trunk/includes/GLPostings.inc	2016-03-02 23:23:45 UTC (rev 7465)
+++ trunk/includes/GLPostings.inc	2016-03-09 01:54:37 UTC (rev 7466)
@@ -60,7 +60,7 @@
 		LEFT JOIN chartdetails ON chartmaster.accountcode=chartdetails.accountcode 
 		AND periods.periodno=chartdetails.period 
 		WHERE (periods.periodno BETWEEN '" . $CreateFrom . "' AND '" . $CreateTo . "')
-		AND chartdetails.account code IS NULL ORDER BY accountcode,periodno";
+		AND chartdetails.accountcode IS NULL ORDER BY accountcode,periodno";
 	$ErrMsg = _('Failed to retrieve new account code and periods');
 	$NewPeriodResult = DB_query($sql,$ErrMsg);
 	if (DB_num_rows($result)>0){