Z_CheckGLTransBalance.php

<?php

include('includes/session.php');
$Title=_('Check Period Sales Ledger Control Account');
include('includes/header.php');

echo '<table>';

$Header = '<tr>
			<th>' . _('Date') . '</th>
			<th>' . _('Type') . '</th>
			<th>' . _('Number') . '</th>
			<th>' . _('Period') . '</th>
			<th>' . _('Difference') . '</th>
		</tr>';

echo $Header;

$sql = "SELECT gltrans.type,
			gltrans.trandate,
			systypes.typename,
			gltrans.typeno,
			periodno,
			SUM(amount) AS nettot
		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,
			periodno
		HAVING ABS(SUM(amount))>= " . 1/pow(10,$_SESSION['CompanyRecord']['decimalplaces']) . "
		ORDER BY gltrans.counterindex";

$OutOfWackResult = DB_query($sql);


$RowCounter =0;

while ($OutOfWackRow = DB_fetch_array($OutOfWackResult)){

	if ($RowCounter==18){
		$RowCounter=0;
		echo $Header;
	} else {
		$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>
	<td class="number">' . locale_number_format($OutOfWackRow['nettot'],$_SESSION['CompanyRecord']['decimalplaces']) . '</td>
	</tr>';

}
echo '</table>';

include('includes/footer.php');
?>