From b72c2a0476688017a61969cbc35dd7cffb4ed78e Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Thu, 30 Aug 2018 23:12:52 +0200 Subject: [PATCH] Rerun. Update material cost when quantity on hand is zero. @notrinos. --- manufacturing/includes/db/work_order_costing_db.inc | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/manufacturing/includes/db/work_order_costing_db.inc b/manufacturing/includes/db/work_order_costing_db.inc index 7671e7ba..7a0bd413 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)/($qoh+$qty))/2; - else - $avg_cost = ($avg_cost*($qoh+$qty_delayed)+$unit_cost*$qty_new)/($qoh+$qty); + $avg_cost = ($avg_cost + ($unit_cost*$qty_new)/$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)." -- 2.30.2