X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=manufacturing%2Fincludes%2Fdb%2Fwork_orders_quick_db.inc;h=3700fa35cd3248719ba59db1536a18a07dee075c;hb=de09a35c9e55aceaf1c71052cbb40f44e4b3bbc7;hp=1534e277a076920f6305684f63b1af0f9f8bab1e;hpb=46c5f7a65a7659a44ae8254c63152074363d3987;p=fa-stable.git

diff --git a/manufacturing/includes/db/work_orders_quick_db.inc b/manufacturing/includes/db/work_orders_quick_db.inc
index 1534e277..3700fa35 100644
--- a/manufacturing/includes/db/work_orders_quick_db.inc
+++ b/manufacturing/includes/db/work_orders_quick_db.inc
@@ -66,12 +66,29 @@ function add_work_order_quick($wo_ref, $loc_code, $units_reqd, $stock_id, $type,
         db_query($sql, "The work order requirements could not be added");
 
 		// insert a -ve stock move for each item
+		// Chaitanya: Updated to record price and cost as std_cost for work order issued item
+		$UnitCost = get_standard_cost($bom_item["component"]);
 		add_stock_move(ST_WORKORDER, $bom_item["component"], $woid,
-			$bom_item["loc_code"], $date_, $wo_ref, -$item_quantity, 0);
+			$bom_item["loc_code"], $date_, $wo_ref, -$item_quantity, $UnitCost, 0, 1, $UnitCost);
+	}
+	
+	// -------------------------------------------------------------------------
+	//Negative Stock Handling
+	$qoh = get_qoh_on_date($stock_id);
+	$cost_adjust = false;
+	if ($qoh < 0)
+	{
+		if ($qoh + $units_reqd >= 0)
+			$cost_adjust = true;
 	}
-
 
 	// -------------------------------------------------------------------------
+	
+	//Negative Stock Handling First; Prior to add_stock_move
+	if ($cost_adjust)
+		adjust_deliveries($stock_id, get_standard_cost($stock_id), $date_);
+		
+	// -------------------------------------------------------------------------	
 
 	// insert a +ve stock move for the item being manufactured
 	add_stock_move(ST_WORKORDER, $stock_id, $woid,	$loc_code, $date_,
@@ -80,8 +97,8 @@ function add_work_order_quick($wo_ref, $loc_code, $units_reqd, $stock_id, $type,
 	// -------------------------------------------------------------------------
 
 	work_order_quick_costs($woid, $stock_id, $units_reqd, $date_, 0, $costs, $cr_acc, $labour, $cr_lab_acc);
-
-	// -------------------------------------------------------------------------
+		
+	//--------------------------------------------------------------------------
 
 	add_comments(ST_WORKORDER, $woid, $date_, $memo_);
 
@@ -103,9 +120,10 @@ function work_order_quick_costs($woid, $stock_id, $units_reqd, $date_, $advanced
 
 	// credit all the components
 	$total_cost = 0;
+	//Chaitanya : capture the exact i.e. non-rounded cost to avoid rounding error amplification
+	$total_material_cost = 0;
 	while ($bom_item = db_fetch($result))
 	{
-
 		$bom_accounts = get_stock_gl_code($bom_item["component"]);
 
 		$bom_cost = $bom_item["ComponentCost"] * $units_reqd;
@@ -116,16 +134,27 @@ function work_order_quick_costs($woid, $stock_id, $units_reqd, $date_, $advanced
 			$memo = $date_.": ".$memo; 
 			update_wo_requirement_issued($woid, $bom_item['component'], $bom_item["quantity"] * $units_reqd); 			
 			// insert a -ve stock move for each item
+			// Chaitanya: Updated to record price and cost as std_cost for work order issued item
+			$UnitCost = get_standard_cost($bom_item["component"]);			
 			add_stock_move(ST_MANURECEIVE, $bom_item["component"], $advanced,
-				$bom_item["loc_code"], $date_, "", -$bom_item["quantity"] * $units_reqd, 0);
+				$bom_item["loc_code"], $date_, "", -$bom_item["quantity"] * $units_reqd, $UnitCost, 0, 1, $UnitCost);
 		}
-		$total_cost += add_gl_trans_std_cost(ST_WORKORDER, $woid, $date_, $bom_accounts["inventory_account"], 0, 0,
+		
+		//Chaitanya : Compatibility for Service Items
+		if (!is_service($bom_accounts["mb_flag"]))
+			$ivaccount = $bom_accounts["inventory_account"];
+		else
+			$ivaccount = $bom_accounts["cogs_account"];
+		$total_cost += add_gl_trans_std_cost(ST_WORKORDER, $woid, $date_, $ivaccount, 0, 0,
 			$memo, -$bom_cost);
-
+		$total_material_cost += $bom_cost;
 	}
 	if ($advanced)
 	{
-		$wo = get_work_order($woid);
+		//Chaitanya: Material cost added at time of production as per BOM at the time and in adjustment mode.
+		add_material_cost($stock_id, $units_reqd, $date_, true, $woid);	
+	
+		// $wo = get_work_order($woid);
 		// also take the additional issues
 		// moved to work_order_issues_db.inc
 		/*
@@ -144,10 +173,13 @@ function work_order_quick_costs($woid, $stock_id, $units_reqd, $date_, $advanced
 		if ($issue_total != 0)
 			add_issue_cost($stock_id, $units_reqd, $date_, $issue_total);
 		*/	
+		
+		// Logic moved to work_order_costs.php
+		/*
 		$lcost = get_gl_wo_cost($woid, WO_LABOUR);
 		add_labour_cost($stock_id, $units_reqd, $date_, $lcost * $units_reqd / $wo['units_reqd']);
 		$ocost = get_gl_wo_cost($woid, WO_OVERHEAD);
-		add_overhead_cost($stock_id, $units_reqd, $date_, $ocost * $units_reqd / $wo['units_reqd']);
+		add_overhead_cost($stock_id, $units_reqd, $date_, $ocost * $units_reqd / $wo['units_reqd']); */
 	}
 	// credit additional costs
 	$item_accounts = get_stock_gl_code($stock_id);
@@ -190,6 +222,13 @@ function work_order_quick_costs($woid, $stock_id, $units_reqd, $date_, $advanced
  		$memo = $date_.": ".$memo;
     add_gl_trans_std_cost(ST_WORKORDER, $woid, $date_, $item_accounts["inventory_account"],
         0, 0, $memo, -$total_cost);	
+		
+	//Chaitanya : Update cost of the manufactured item in stock moves table
+	if (!$advanced)
+	{
+		$UnitWOCost = ($total_material_cost + $costs + $labour)/$units_reqd;
+		update_stock_move(ST_WORKORDER, $woid, $stock_id, $UnitWOCost);	
+	}	
 }
 
 //--------------------------------------------------------------------------------------