X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fincludes%2Fdb%2Fsuppalloc_db.inc;h=91b533964c02176e029a3fb2f1c4489b304bacc5;hb=6425de92749015d0e7ab29b5fd071a9d70cbb7d5;hp=3bcc2596dd2ad1ebb0aaaf440fbf6c5eb08b6024;hpb=818719f38b8327cdca616d58b13913dbd174d96a;p=fa-stable.git diff --git a/purchasing/includes/db/suppalloc_db.inc b/purchasing/includes/db/suppalloc_db.inc index 3bcc2596..91b53396 100644 --- a/purchasing/includes/db/suppalloc_db.inc +++ b/purchasing/includes/db/suppalloc_db.inc @@ -1,13 +1,13 @@ . + See the License here . ***********************************************************************/ //---------------------------------------------------------------------------------------- @@ -156,7 +156,7 @@ function get_allocatable_to_supp_transactions($supplier_id, $trans_no=null, $typ { if ($trans_no != null && $type!= null) { - $sql = get_alloc_supp_sql("amt", "trans.trans_no = alloc.trans_no_to + $sql = get_alloc_supp_sql("amt, supp_reference", "trans.trans_no = alloc.trans_no_to AND trans.type = alloc.trans_type_to AND alloc.trans_no_from=$trans_no AND alloc.trans_type_from=$type