[Web-erp-svn] SF.net SVN: web-erp:[7564] trunk/Z_CheckGLTransBalance.php

[<dai...@us...>]

Revision: 7564
          http://sourceforge.net/p/web-erp/reponame/7564
Author:   daintree
Date:     2016-07-03 06:58:29 +0000 (Sun, 03 Jul 2016)
Log Message:
-----------
add check that the GL accounts have not been deleted to orphan transactions

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

Modified: trunk/Z_CheckGLTransBalance.php
===================================================================
--- trunk/Z_CheckGLTransBalance.php	2016-06-29 06:28:42 UTC (rev 7563)
+++ trunk/Z_CheckGLTransBalance.php	2016-07-03 06:58:29 UTC (rev 7564)
@@ -21,9 +21,10 @@
 			gltrans.typeno,
 			periodno,
 			SUM(amount) AS nettot
-		FROM gltrans,
-			systypes
-		WHERE gltrans.type = systypes.typeid
+		FROM gltrans
+			INNER JOIN chartmaster ON
+			gltrans.account=chartmaster.accountcode
+			INNER JOIN systypes ON gltrans.type = systypes.typeid
 		GROUP BY gltrans.type,
 			systypes.typename,
 			typeno,