[Web-erp-svn] SF.net SVN: web-erp:[6502] trunk/StockCounts.php

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

Revision: 6502
          http://sourceforge.net/p/web-erp/reponame/6502
Author:   daintree
Date:     2013-12-18 08:10:33 +0000 (Wed, 18 Dec 2013)
Log Message:
-----------
New stock take counts by category was excluding raw materials cats

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

Modified: trunk/StockCounts.php
===================================================================
--- trunk/StockCounts.php	2013-12-14 18:43:48 UTC (rev 6501)
+++ trunk/StockCounts.php	2013-12-18 08:10:33 UTC (rev 6502)
@@ -95,8 +95,7 @@
 						FROM stockcategory INNER JOIN stockmaster
 							ON stockcategory.categoryid=stockmaster.categoryid
 							INNER JOIN stockcheckfreeze
-							ON stockmaster.stockid=stockcheckfreeze.stockid
-						WHERE stocktype='F'",$db);
+							ON stockmaster.stockid=stockcheckfreeze.stockid",$db);
 
 	if (DB_num_rows($CatsResult) ==0) {
 		prnMsg(_('The stock check sheets must be run first to create the stock check. Only once these are created can the stock counts be entered. Currently there is no stock check to enter counts for'),'error');