' . MENU_JOURNAL_ENTRY_MANAGEMENT_RECONCILE . '

'; $query=mysql_query("SELECT CONCAT(account_codes,' · ',account_description) FROM chart_accounts WHERE id='" . $_POST['reconcile_coa_id'] . "'"); $data=mysql_fetch_array($query); $msg .= $data[0] . ', Period Ending ' . dateShort(@$dataReconcile['date']); echo $this->element('/print/header-report',array('msg'=>$msg)); ?>
0 " . $conditionCleared); $queryClearedDepositsCredits=mysql_query("SELECT * FROM general_ledgers gl INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id WHERE debit>0 " . $conditionCleared); $unclearedChecksPayments=0; $unclearedDepositsCredits=0; $conditionUncleared=" AND is_active=1 AND is_approve=1 AND company_id='" . $_POST['company_id'] . "' AND branch_id='" . $_POST['branch_id'] . "' AND chart_account_id='" . $_POST['reconcile_coa_id'] . "' AND ( reconcile_id IS NULL OR ( is_reconcile=1 AND reconcile_id!='" . $dataReconcile['id'] . "' AND date<='" . $dataReconcile['date'] . "' AND (SELECT date FROM reconciles WHERE id=reconcile_id)>(SELECT date FROM reconciles WHERE id='" . $dataReconcile['id'] . "') ) ) AND date<='" . $dataReconcile['date'] . "'"; $queryUnclearedChecksPayments=mysql_query("SELECT * FROM general_ledgers gl INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id WHERE credit>0 " . $conditionUncleared); $queryUnclearedDepositsCredits=mysql_query("SELECT * FROM general_ledgers gl INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id WHERE debit>0 " . $conditionUncleared); $newChecksPayments=0; $newDepositsCredits=0; $conditionNew=" AND is_active=1 AND is_approve=1 AND company_id='" . $_POST['company_id'] . "' AND branch_id='" . $_POST['branch_id'] . "' AND chart_account_id='" . $_POST['reconcile_coa_id'] . "' AND ( reconcile_id IS NULL OR ( is_reconcile=1 AND reconcile_id!='" . $dataReconcile['id'] . "' AND date<='" . $dataReconcile['date'] . "' AND (SELECT date FROM reconciles WHERE id=reconcile_id)>(SELECT date FROM reconciles WHERE id='" . $dataReconcile['id'] . "') ) ) AND date>'" . $dataReconcile['date'] . "'"; $queryNewChecksPayments=mysql_query("SELECT * FROM general_ledgers gl INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id WHERE credit>0 " . $conditionNew); $queryNewDepositsCredits=mysql_query("SELECT * FROM general_ledgers gl INNER JOIN general_ledger_details gld ON gl.id=gld.general_ledger_id WHERE debit>0 " . $conditionNew); ?>

Type	Date	Reference	Name	Clear	Amount	Balance
Beginning Balance
Cleared Transactions
Checks and Payments
Total Checks and Payments
Deposits and Credits
Total Deposits and Credits
Total Cleared Transactions
Cleared Balance
Uncleared Transactions
Checks and Payments
Total Checks and Payments
Deposits and Credits
Total Deposits and Credits
Total Uncleared Transactions
Register Balance as of
New Transactions
Checks and Payments
Total Checks and Payments
Deposits and Credits
Total Deposits and Credits
Total New Transactions
Ending Balance

element('report_footer'); ?>