Changed balance_sheet field in account class to ctype and fixed class editing.

[fa-stable.git] / gl / includes / db / gl_db_trans.inc

diff --git a/gl/includes/db/gl_db_trans.inc b/gl/includes/db/gl_db_trans.inc
index d80dfe4789c1b627386a55041678fce79732f223..5b559d33987a094334242f3620f30f066c3c45a3 100644 (file)
--- 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' ";