X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_bank_trans.inc;h=8c63f64573bf3bdfd5ac7f1f1e76a22d7177c5d4;hb=497ea6033084a0ee18eabdccdd533d54a5ffba96;hp=5ffa2d0cf0acd52f8f5eabead63a537971f4abe9;hpb=c23ac0e7ff87228e01c3f84ba72aac9084b7c88e;p=fa-stable.git diff --git a/gl/includes/db/gl_db_bank_trans.inc b/gl/includes/db/gl_db_bank_trans.inc index 5ffa2d0c..8c63f645 100644 --- a/gl/includes/db/gl_db_bank_trans.inc +++ b/gl/includes/db/gl_db_bank_trans.inc @@ -188,7 +188,7 @@ function check_bank_account_history($delta_amount, $bank_account, $date=null, $u $balance += $delta_amount; - $sql = "SELECT sum(amount) as amount, trans_date + $sql = "SELECT sum(amount) as amount, trans_date, trans_no, type FROM ".TB_PREF."bank_trans WHERE bank_act=".db_escape($bank_account); if ($date) @@ -202,7 +202,7 @@ function check_bank_account_history($delta_amount, $bank_account, $date=null, $u while ($trans = db_fetch($history)) { $balance += $trans['amount']; - if ($balance < 0) + if (round2($balance, user_price_dec()) < 0) { $trans['amount'] = $balance; return $trans;