X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_bank_accounts.inc;h=12238c4044472a40bb8aeda56394895143630d05;hb=eefe5267ed97b38ac66179141994fc8c9dd09ea8;hp=01feb5d1f165f5230858df4ec889940ee72851ca;hpb=4deaa6ba6e084655989c30cfb7d9dd307408c7dc;p=fa-stable.git diff --git a/gl/includes/db/gl_db_bank_accounts.inc b/gl/includes/db/gl_db_bank_accounts.inc index 01feb5d1..12238c40 100644 --- a/gl/includes/db/gl_db_bank_accounts.inc +++ b/gl/includes/db/gl_db_bank_accounts.inc @@ -308,7 +308,7 @@ function get_ending_reconciled($bank_account, $bank_date) function get_sql_for_bank_account_reconcile($bank_account, $date) { $sql = "SELECT bt.type, trans_no, ref, trans_date, - amount, person_id, person_type_id, reconciled, bt.id, c.memo_ + amount, charge, person_id, person_type_id, reconciled, bt.id, c.memo_ FROM ".TB_PREF."bank_trans bt LEFT JOIN ".TB_PREF."comments c ON c.type = bt.type AND c.id = bt.trans_no WHERE bank_act = ".db_escape($bank_account) . "