X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_trans.inc;h=5b559d33987a094334242f3620f30f066c3c45a3;hb=29bfc95a3b218ab90694535a0e94acd380b738b5;hp=d80dfe4789c1b627386a55041678fce79732f223;hpb=2383d33373d6ddec06906658a0ed6398077c1147;p=fa-stable.git

diff --git a/gl/includes/db/gl_db_trans.inc b/gl/includes/db/gl_db_trans.inc
index d80dfe47..5b559d33 100644
--- a/gl/includes/db/gl_db_trans.inc
+++ b/gl/includes/db/gl_db_trans.inc
@@ -215,7 +215,7 @@ function get_balance($account, $dimension, $dimension2, $from, $to, $from_incl=t
 	if ($from_incl)
 		$sql .= " tran_date >= '$from_date'  AND";
 	else
-		$sql .= " tran_date > IF(balance_sheet>0 AND balance_sheet<".CL_INCOME.", '0000-00-00', '$from_date') AND";
+		$sql .= " tran_date > IF(ctype>0 AND ctype<".CL_INCOME.", '0000-00-00', '$from_date') AND";
 	$to_date = date2sql($to);
 	if ($to_incl)
 		$sql .= " tran_date <= '$to_date' ";