Fixed bug in product average cost calculations.

diff --git a/manufacturing/includes/db/work_order_produce_items_db.inc b/manufacturing/includes/db/work_order_produce_items_db.inc
index 44c93b864d0392bf07dc5bca3562e4e70e4caf7b..c05bac96c7b2d214be113e23972643394e404e02 100644 (file)
--- a/manufacturing/includes/db/work_order_produce_items_db.inc
+++ b/manufacturing/includes/db/work_order_produce_items_db.inc
@@ -81,10 +81,11 @@ function work_order_produce($woid, $ref, $quantity, $date_, $memo, $close_wo)
 
                $unit_cost = $total_cost/($product['units_issued']+$quantity);
 
+               // first update material cost
+               update_material_cost($product['stock_id'], $product['units_issued']+$quantity, $unit_cost, $date_);
+
                add_stock_move(ST_WORKORDER, $product["stock_id"], $woid,
                        $product["loc_code"], $date_, $ref, $product['units_issued']+$quantity, $unit_cost);
-
-               update_material_cost($product['stock_id'], $product['units_issued']+$quantity, $unit_cost, $date_);
        }
 
        if ($memo)