X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Finquiry%2Fgl_trial_balance.php;h=969cfcca0dd6c8030c6877e3afe950de87456d16;hb=4d5c386a745f07e2f937c5a3fcfffdb431551cc5;hp=b3dee997d722db482fe18f4b376840f60d91a780;hpb=c09be0dad6b05131e240349a375af7a4b7bf3444;p=fa-stable.git

diff --git a/gl/inquiry/gl_trial_balance.php b/gl/inquiry/gl_trial_balance.php
index b3dee997..969cfcca 100644
--- a/gl/inquiry/gl_trial_balance.php
+++ b/gl/inquiry/gl_trial_balance.php
@@ -99,6 +99,7 @@ function display_trial_balance()
 
 	$k = 0;
 
+	$totprev = $totcurr = 0.0;
 	$accounts = get_gl_accounts();
 
 	while ($account = db_fetch($accounts))
@@ -108,7 +109,7 @@ function display_trial_balance()
 		else
 		{
 			$begin = begin_fiscalyear();
-			if ($_POST['TransFromDate'] < $begin)
+			if (date1_greater_date2($begin, $_POST['TransFromDate']))
 				$begin = $_POST['TransFromDate'];
 			$begin = add_days($begin, -1);
 		}
@@ -117,6 +118,8 @@ function display_trial_balance()
 		$curr_balance = get_balance($account["account_code"], $_POST['TransFromDate'], $_POST['TransToDate']);
 		if (check_value("NoZero") && !$prev_balance && !$curr_balance)
 			continue;
+		$totprev += $prev_balance;
+		$totcurr += $curr_balance;
 		alt_table_row_color($k);
 
 		$url = "<a href='$path_to_root/gl/inquiry/gl_account_inquiry.php?" . SID . "TransFromDate=" . $_POST["TransFromDate"] . "&TransToDate=" . $_POST["TransToDate"] . "&account=" . $account["account_code"] . "'>" . $account["account_code"] . "</a>";
@@ -129,6 +132,12 @@ function display_trial_balance()
 		display_debit_or_credit_cells($prev_balance + $curr_balance);
 		end_row();
 	}
+	start_row("class='inquirybg'");
+	label_cell("<b>" . _("Ending Balance") ." - ".$_POST['TransToDate']. "</b>", "colspan=2");
+	display_debit_or_credit_cells($totprev);
+	display_debit_or_credit_cells($totcurr);
+	display_debit_or_credit_cells($totprev + $totcurr);
+	end_row();
 
 	end_table(1);
 	div_end();