- (SELECT sum(amt) amt from ".TB_PREF."supp_allocations
- WHERE (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)
- WHERE " . ($trans_type==ST_PURCHORDER ?
+ (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(ROUND(allocated.amt, $dec), 0)
+ WHERE trans.supplier_id=person_id AND " . ($trans_type==ST_PURCHORDER ?