[Web-erp-svn] SF.net SVN: web-erp:[6865] trunk/CopyBOM.php

[<dai...@us...>]

Revision: 6865
          http://sourceforge.net/p/web-erp/reponame/6865
Author:   daintree
Date:     2014-09-06 03:14:43 +0000 (Sat, 06 Sep 2014)
Log Message:
-----------
Bob Thomas and Andrew Galuski: Fix CopyBOM.php missing fields following changes for bin and sequence

Modified Paths:
--------------
    trunk/CopyBOM.php

Modified: trunk/CopyBOM.php
===================================================================
--- trunk/CopyBOM.php	2014-09-05 02:19:24 UTC (rev 6864)
+++ trunk/CopyBOM.php	2014-09-06 03:14:43 UTC (rev 6865)
@@ -134,18 +134,18 @@
 		$result = DB_query($sql, $db);
 
 		if($NewOrExisting == 'N') {
-			$sql = "INSERT INTO locstock (
-			            loccode,
-			            stockid,
-			            quantity,
-			            reorderlevel
-			        )
-		      SELECT loccode,
-					'".$NewStockID."' AS stockid,
-					0 AS quantity,
-					reorderlevel
-				FROM locstock
-				WHERE stockid='".$StockID."'";
+			$sql = "INSERT INTO locstock (loccode,
+								            stockid,
+								            quantity,
+								            reorderlevel,
+								            bin )
+				      SELECT loccode,
+							'".$NewStockID."' AS stockid,
+							0 AS quantity,
+							reorderlevel,
+							bin
+						FROM locstock
+						WHERE stockid='".$StockID."'";
 
 			$result = DB_query($sql, $db);
 		}