WHERE stock_id=".db_escape($stock_id)." AND qty < 0 AND
trans_id>='$move_id' GROUP BY stock_id";
$result = db_query($sql, "The deliveries could not be updated");
WHERE stock_id=".db_escape($stock_id)." AND qty < 0 AND
trans_id>='$move_id' GROUP BY stock_id";
$result = db_query($sql, "The deliveries could not be updated");
$sql = "SELECT IF(type=".ST_SUPPRECEIVE." OR type=".ST_SUPPCREDIT.", price, standard_cost)
FROM ".TB_PREF."stock_moves
WHERE stock_id=".db_escape($stock_id)
." AND trans_id ='$move_id'";
$result = db_query($sql, "The deliveries could not be updated");
$sql = "SELECT IF(type=".ST_SUPPRECEIVE." OR type=".ST_SUPPCREDIT.", price, standard_cost)
FROM ".TB_PREF."stock_moves
WHERE stock_id=".db_escape($stock_id)
." AND trans_id ='$move_id'";
$result = db_query($sql, "The deliveries could not be updated");
WHERE stock_id=".db_escape($stock_id)." AND
trans_id<'$move_id' GROUP BY stock_id";
$result = db_query($sql, "The deliveries could not be updated");
WHERE stock_id=".db_escape($stock_id)." AND
trans_id<'$move_id' GROUP BY stock_id";
$result = db_query($sql, "The deliveries could not be updated");
$final_cost = $row[1] - $qoh[0]*$cost[0];
return array($qty,$final_cost);
$final_cost = $row[1] - $qoh[0]*$cost[0];
return array($qty,$final_cost);