web-erp-developers

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

[Andrew G. <aga...@re...>]

Add this code at line 124 (Between  'as parent,' and 'component'

	'sequence,'



Best Regards,
Andrew Galuski
ResMart LLC.
817.615.2038 (Office)
817.821.0544 (Cell)
www.resmart.com


-----Original Message-----
From: rfthomas [mailto:rf...@as...] 
Sent: Thursday, September 04, 2014 1:12 PM
To: web...@li...
Subject: [WebERP-developers] Copy BOM fails

The copy BOM is failing with the following error being displayed:

Database Error 1136 : 
Column count doesn't match value count at row 1 Database SQL Failure : The SQL that failed was INSERT INTO bom SELECT 'AA-100L-2GM' AS parent, component, workcentreadded, loccode, effectiveafter, effectiveto, quantity, autoissue FROM bom WHERE parent='AA-100L-2G';




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Copy-BOM-fails-tp4657617.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

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

[rfthomas <rf...@as...>]

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.

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
>