web-erp-svn

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

[<te...@us...>]

Revision: 7320
          http://sourceforge.net/p/web-erp/reponame/7320
Author:   tehonu
Date:     2015-06-13 03:43:34 +0000 (Sat, 13 Jun 2015)
Log Message:
-----------
Use of company decimal numbers instead of fixed decimal numbers

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

Modified: trunk/Z_CheckGLTransBalance.php
===================================================================
--- trunk/Z_CheckGLTransBalance.php	2015-06-11 09:49:54 UTC (rev 7319)
+++ trunk/Z_CheckGLTransBalance.php	2015-06-13 03:43:34 UTC (rev 7320)
@@ -17,18 +17,19 @@
 echo $Header;
 
 $sql = "SELECT gltrans.type,
-		systypes.typename,
-		gltrans.typeno,
-		periodno,
-		SUM(amount) AS nettot
-	FROM gltrans,
-		systypes
-	WHERE gltrans.type = systypes.typeid
-	GROUP BY gltrans.type,
-		systypes.typename,
-		typeno,
-		periodno
-	HAVING ABS(SUM(amount))>0.01";
+			systypes.typename,
+			gltrans.typeno,
+			periodno,
+			SUM(amount) AS nettot
+		FROM gltrans,
+			systypes
+		WHERE gltrans.type = systypes.typeid
+		GROUP BY gltrans.type,
+			systypes.typename,
+			typeno,
+			periodno
+		HAVING ABS(SUM(amount))>= " . 1/pow(10,$_SESSION['CompanyRecord']['decimalplaces']) . "
+		ORDER BY gltrans.counterindex";
 
 $OutOfWackResult = DB_query($sql);
 
@@ -47,7 +48,7 @@
 	<td><a href="' . $RootPath . '/GLTransInquiry.php?TypeID=' . $OutOfWackRow['type'] . '&TransNo=' . $OutOfWackRow['typeno'] . '">' . $OutOfWackRow['typename'] . '</a></td>
 	<td class="number">' . $OutOfWackRow['typeno'] . '</td>
 	<td class="number">' . $OutOfWackRow['periodno'] . '</td>
-	<td class="number">' . locale_number_format($OutOfWackRow['nettot'],3) . '</td>
+	<td class="number">' . locale_number_format($OutOfWackRow['nettot'],$_SESSION['CompanyRecord']['decimalplaces']) . '</td>
 	</tr>';
 
 }

[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,

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

[<te...@us...>]

Revision: 7715
          http://sourceforge.net/p/web-erp/reponame/7715
Author:   tehonu
Date:     2017-01-02 00:40:32 +0000 (Mon, 02 Jan 2017)
Log Message:
-----------
Added date of transaction

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

Modified: trunk/Z_CheckGLTransBalance.php
===================================================================
--- trunk/Z_CheckGLTransBalance.php	2016-12-26 08:51:03 UTC (rev 7714)
+++ trunk/Z_CheckGLTransBalance.php	2017-01-02 00:40:32 UTC (rev 7715)
@@ -8,6 +8,7 @@
 echo '<table>';
 
 $Header = '<tr>
+			<th>' . _('Date') . '</th>
 			<th>' . _('Type') . '</th>
 			<th>' . _('Number') . '</th>
 			<th>' . _('Period') . '</th>
@@ -17,6 +18,7 @@
 echo $Header;
 
 $sql = "SELECT gltrans.type,
+			gltrans.trandate,
 			systypes.typename,
 			gltrans.typeno,
 			periodno,
@@ -46,6 +48,7 @@
 		$RowCounter++;
 	}
 	echo '<tr>
+	<td>' . ConvertSQLDate($OutOfWackRow['trandate']) . '</td>
 	<td><a href="' . $RootPath . '/GLTransInquiry.php?TypeID=' . $OutOfWackRow['type'] . '&TransNo=' . $OutOfWackRow['typeno'] . '">' . $OutOfWackRow['typename'] . '</a></td>
 	<td class="number">' . $OutOfWackRow['typeno'] . '</td>
 	<td class="number">' . $OutOfWackRow['periodno'] . '</td>