[Weberp-cvs] SF.net SVN: web-erp:[4150] trunk

[<tim...@us...>]

Revision: 4150
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4150&view=rev
Author:   tim_schofield
Date:     2010-11-06 15:50:51 +0000 (Sat, 06 Nov 2010)

Log Message:
-----------
Remove fixed assets from selections

Modified Paths:
--------------
    trunk/ReorderLevelLocation.php
    trunk/doc/Change.log.html

Modified: trunk/ReorderLevelLocation.php
===================================================================
--- trunk/ReorderLevelLocation.php	2010-11-06 15:33:31 UTC (rev 4149)
+++ trunk/ReorderLevelLocation.php	2010-11-06 15:50:51 UTC (rev 4150)
@@ -181,8 +181,9 @@
 	echo '</select></td></tr>';
 
 	$SQL="SELECT categoryid, categorydescription
-	      FROM stockcategory
-		  ORDER BY categorydescription";
+	    FROM stockcategory
+		WHERE stocktype<>'A'
+		ORDER BY categorydescription";
 
 	$result1 = DB_query($SQL,$db);
 

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-11-06 15:33:31 UTC (rev 4149)
+++ trunk/doc/Change.log.html	2010-11-06 15:50:51 UTC (rev 4150)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>06/11/10 Tim: ReorderLevelLocation.php - Remove fixed assets from selections</p>
 <p>06/11/10 Tim: ReorderLevel.php - Remove fixed assets from selections</p>
 <p>06/11/10 Tim: InventoryQuantities.php - Remove fixed assets from selections</p>
 <p>06/11/10 Tim: Selectproduct.php - Remove fixed assets from selections</p>


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.