X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fincludes%2Fpurchasing_db.inc;h=fbef5291d574d23415c026b317b298d455830eb3;hb=316007a1fa9cb1fd6d11460326160d4a60a0d943;hp=89c4d94b4d5097803047f44bd5bef820f9344985;hpb=95ff74b5722826544743a01daf527aa3c9efe11a;p=fa-stable.git diff --git a/purchasing/includes/purchasing_db.inc b/purchasing/includes/purchasing_db.inc index 89c4d94b..fbef5291 100644 --- a/purchasing/includes/purchasing_db.inc +++ b/purchasing/includes/purchasing_db.inc @@ -95,6 +95,8 @@ function get_purchase_data($supplier_id, $stock_id) function add_or_update_purchase_data($supplier_id, $stock_id, $price, $description="", $uom="") { $data = get_purchase_data($supplier_id, $stock_id); + + $description = substr($description, 0, 50); // FIXME: temporary constraint to avoid db errors on long descriptions, see [0005170] if ($data === false) { $sql = "INSERT INTO ".TB_PREF."purch_data (supplier_id, stock_id, price, suppliers_uom, @@ -213,7 +215,7 @@ function add_direct_supp_trans($cart) if ($cart->cash_account) { $pmt_no = write_supp_payment(0, $inv->supplier_id, $cart->cash_account, $inv->tran_date, $Refs->get_next(ST_SUPPAYMENT, null, $inv->tran_date), - $total, 0, _('Payment for:').$inv->supp_reference .' ('.$type_shortcuts[ST_SUPPINVOICE].$inv_no.')'); + $total, 0, _('Payment for:').$inv->supp_reference .' ('.$type_shortcuts[ST_SUPPINVOICE].$inv_no.')' . ' ' . $cart->Comments, $cart->dimension, $cart->dimension2); add_supp_allocation($total, ST_SUPPAYMENT, $pmt_no, ST_SUPPINVOICE, $inv_no, $inv->supplier_id, $inv->tran_date); update_supp_trans_allocation(ST_SUPPINVOICE, $inv_no, $inv->supplier_id); update_supp_trans_allocation(ST_SUPPAYMENT, $pmt_no, $inv->supplier_id);