X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=blobdiff_plain;f=manufacturing%2Fincludes%2Fdb%2Fwork_order_costing_db.inc;h=48cb7f3b2d811fdc18c478f26c5dc5f57801920e;hp=d3c96a5ffc625ecda474c816be4fd0a72a9d2cf6;hb=85cdc977a80b32727c13aae517f58437e908a033;hpb=edbd85d34374e87dcc0a0cc01d21ca4e4aabf1ac diff --git a/manufacturing/includes/db/work_order_costing_db.inc b/manufacturing/includes/db/work_order_costing_db.inc index d3c96a5f..48cb7f3b 100644 --- a/manufacturing/includes/db/work_order_costing_db.inc +++ b/manufacturing/includes/db/work_order_costing_db.inc @@ -105,9 +105,9 @@ function update_material_cost($stock_id, $qty, $unit_cost, $date) if ($qty > 0 && ($qoh != -$qty)) { if ($qoh == 0 && $avg_cost != 0) - $avg_cost = ($avg_cost + ($unit_cost*$qty_new)/$qty)/2; - else - $avg_cost = ($avg_cost*($qoh+$qty_delayed)+$unit_cost*$qty_new)/($qoh+$qty); + $avg_cost = ($avg_cost + ($unit_cost*$qty_new)/($qoh+$qty))/2; + else + $avg_cost = ($avg_cost*($qoh+$qty_delayed)+$unit_cost*$qty_new)/($qoh+$qty); } $sql = "UPDATE ".TB_PREF."stock_master SET material_cost=".db_escape($avg_cost)."