X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fincludes%2Fdb%2Fsuppalloc_db.inc;h=b67708cd471267ecf1cd07f3617774bf09aa11f3;hb=d07b6ec5fd2bbfbd24335406131fc30f7862dbeb;hp=228f7b1c4a72335b4dfc9604c5c625fe613cf8ba;hpb=3218c355d9455506febbd3a8a7d9bd61fc9a0a34;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));