X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=purchasing%2Fincludes%2Fdb%2Fsuppalloc_db.inc;h=b67708cd471267ecf1cd07f3617774bf09aa11f3;hb=9a4dbbda763486152d2e98485a7a2a699426141d;hp=228f7b1c4a72335b4dfc9604c5c625fe613cf8ba;hpb=ee0dff4cdf462ac0476531181ad61ff7f9db1c6c;p=fa-stable.git diff --git a/purchasing/includes/db/suppalloc_db.inc b/purchasing/includes/db/suppalloc_db.inc index 228f7b1c..b67708cd 100644 --- a/purchasing/includes/db/suppalloc_db.inc +++ b/purchasing/includes/db/suppalloc_db.inc @@ -52,12 +52,13 @@ function get_supp_trans_allocation_balance($trans_type, $trans_no) // function update_supp_trans_allocation($trans_type, $trans_no, $person_id) { + $dec = user_price_dec(); $sql = "UPDATE `".TB_PREF.($trans_type==ST_PURCHORDER ? 'purch_orders' : 'supp_trans')."` trans, (SELECT person_id, sum(amt) amt from ".TB_PREF."supp_allocations WHERE person_id=".db_escape($person_id)." AND ((trans_type_to=".db_escape($trans_type)." AND trans_no_to=".db_escape($trans_no).") OR (trans_type_from=".db_escape($trans_type)." AND trans_no_from=".db_escape($trans_no)."))) allocated SET - trans.alloc=IFNULL(allocated.amt, 0) + trans.alloc=IFNULL(ROUND(allocated.amt, $dec), 0) WHERE trans.supplier_id=person_id AND " . ($trans_type==ST_PURCHORDER ? "trans.order_no=".db_escape($trans_no) : "trans.type=".db_escape($trans_type)." AND trans.trans_no=".db_escape($trans_no));