[Web-erp-svn] SF.net SVN: web-erp:[6580] trunk

[<ice...@us...>]

Revision: 6580
          http://sourceforge.net/p/web-erp/reponame/6580
Author:   icedlava
Date:     2014-02-17 00:39:38 +0000 (Mon, 17 Feb 2014)
Log Message:
-----------
SQL fixes for insert to bom and locstock tables - ensure column counts match values even when zero

Modified Paths:
--------------
    trunk/CopyBOM.php
    trunk/doc/Change.log

Modified: trunk/CopyBOM.php
===================================================================
--- trunk/CopyBOM.php	2014-02-15 15:04:53 UTC (rev 6579)
+++ trunk/CopyBOM.php	2014-02-17 00:39:38 UTC (rev 6580)
@@ -121,6 +121,7 @@
 
 		$sql = "INSERT INTO bom
 					SELECT '".$NewStockID."' AS parent,
+					        sequence,
 							component,
 							workcentreadded,
 							loccode,
@@ -133,7 +134,12 @@
 		$result = DB_query($sql, $db);
 
 		if($NewOrExisting == 'N') {
-			$sql = "INSERT INTO locstock
+			$sql = "INSERT INTO locstock (
+			            loccode,
+			            stockid,
+			            quantity,
+			            reorderlevel
+			        )
 		      SELECT loccode,
 					'".$NewStockID."' AS stockid,
 					0 AS quantity,

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2014-02-15 15:04:53 UTC (rev 6579)
+++ trunk/doc/Change.log	2014-02-17 00:39:38 UTC (rev 6580)
@@ -1,5 +1,6 @@
 webERP Change Log
 
+17/2/14 icedlava: CopyBOM.php - SQL fix for insert to bom and locstock tables - ensure column counts match values even when zero.
 16/2/14 icedlava: StockCounts.php - Enter by Category only counts and enters 10 items maximum - fix to allow any number that are input.
 15/2/14 Exson: Make perishable control available in WorkOrderReceive.php.
 15/2/14 Phil: Stock check comparison report now shows the bin location after the item code