X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fincludes%2Fpurchasing_db.inc;h=89c4d94b4d5097803047f44bd5bef820f9344985;hb=36813770129eae719452f8d02144be61bbcd1d48;hp=983085769894f972b327eda71eae97da4fc9dc34;hpb=19dce8c7be29e4cc8e7be92d044259348373d456;p=fa-stable.git diff --git a/purchasing/includes/purchasing_db.inc b/purchasing/includes/purchasing_db.inc index 98308576..89c4d94b 100644 --- a/purchasing/includes/purchasing_db.inc +++ b/purchasing/includes/purchasing_db.inc @@ -121,7 +121,8 @@ function get_po_prepayments($supp_trans) $allocations = array(); $line_ids = array(); foreach($supp_trans->grn_items as $item) - $line_ids[] = $item->po_detail_item; + if ($item->po_detail_item) + $line_ids[] = $item->po_detail_item; if (!count($line_ids)) return $allocations; @@ -130,7 +131,7 @@ function get_po_prepayments($supp_trans) FROM ".TB_PREF."supp_allocations allocs LEFT JOIN ".TB_PREF."purch_order_details line ON line.order_no=allocs.trans_no_to AND trans_type_to=".ST_PURCHORDER." WHERE line.po_detail_item IN(".implode(',', array_values($line_ids)).")"; -//_vd($sql); + $result = db_query($sql, "Cannot retrieve po prepayments"); while($dat = db_fetch($result)) @@ -196,7 +197,7 @@ function add_direct_supp_trans($cart) foreach($cart->line_items as $key => $line) { $inv->add_grn_to_trans($line->grn_item_id, $line->po_detail_rec, $line->stock_id, $line->item_description, $line->receive_qty, 0, $line->receive_qty, - $line->price, $line->price, true, get_standard_cost($line->stock_id), ''); + $line->price, $line->price, true, get_unit_cost($line->stock_id), ''); $total += round2(($line->receive_qty * $line->price), user_price_dec()); } $inv->tax_overrides = $cart->tax_overrides;