Re: [WebERP-developers] Copy BOM fails - Solution

[Phil D. <ph...@lo...>]

Thanks committed these changes

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 05/09/14 06:23, rfthomas wrote:
> Andrew,
>
> Bin was also missing from the locstock SQL.  We have made the following
> changes:
>
> 		$sql = "INSERT INTO bom
> 					SELECT '".$NewStockID."' AS parent,
> 							sequence,
> 							component,
> 							workcentreadded,
> 							loccode,
> 							effectiveafter,
> 							effectiveto,
> 							quantity,
> 							autoissue
> 					FROM bom
> 					WHERE parent='".$StockID."';";
> 		$result = DB_query($sql, $db);
>
> 		if($NewOrExisting == 'N') {
> 			$sql = "INSERT INTO locstock
> 		      SELECT loccode,
> 					'".$NewStockID."' AS stockid,
> 					0 AS quantity,
> 					reorderlevel,
> 					bin
> 				FROM locstock
> 				WHERE stockid='".$StockID."'";
>
> 			$result = DB_query($sql, $db);
> 		}
>
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Re-Copy-BOM-fails-Solution-tp4657618p4657619.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Slashdot TV.
> Video for Nerds.  Stuff that matters.
> http://tv.slashdot.org/
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>