From 6100a63fb3e7f6eb0990f4561587070363ddccf2 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Fri, 11 Jan 2019 08:29:58 +0100 Subject: [PATCH] Rerun of Update Material Cost Function. $notrinos. --- manufacturing/includes/db/work_order_costing_db.inc | 8 ++------ 1 file changed, 2 insertions(+), 6 deletions(-) diff --git a/manufacturing/includes/db/work_order_costing_db.inc b/manufacturing/includes/db/work_order_costing_db.inc index 48cb7f3b..5d39a8a9 100644 --- a/manufacturing/includes/db/work_order_costing_db.inc +++ b/manufacturing/includes/db/work_order_costing_db.inc @@ -103,12 +103,8 @@ function update_material_cost($stock_id, $qty, $unit_cost, $date) write_journal_entries($cart); } - 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); - } + if ($qty > 0 && ($qoh != -$qty)) + $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)." WHERE stock_id=".db_escape($stock_id); -- 2.30.2