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

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

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

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

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

Modified: trunk/InventoryQuantities.php
===================================================================
--- trunk/InventoryQuantities.php	2010-11-06 12:18:25 UTC (rev 4147)
+++ trunk/InventoryQuantities.php	2010-11-06 12:35:06 UTC (rev 4148)
@@ -154,7 +154,7 @@
 	echo "<option value='Multiple'>" . _('Only Parts With Multiple Locations');
 	echo '</select></td></tr>';
 
-	$SQL="SELECT categoryid, categorydescription FROM stockcategory ORDER BY categorydescription";
+	$SQL="SELECT categoryid, categorydescription FROM stockcategory where stocktype<>'A' ORDER BY categorydescription";
 	$result1 = DB_query($SQL,$db);
 	if (DB_num_rows($result1)==0){
 		echo '</table></td></tr>

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-11-06 12:18:25 UTC (rev 4147)
+++ trunk/doc/Change.log.html	2010-11-06 12:35:06 UTC (rev 4148)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></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>
 <p>06/11/10 Tim: InventoryValuation.php - Ensure fixed assets dont get shown in valuation report</p>
 <p>06/11/10 Tim: FixedAssetItems.php - Fixed typo preventing Item code being shown</p>


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