X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep104.php;h=eabb5956881d0af33c9eba004ef1af0f3d1bb4b2;hb=c5dc92bf60148463852a81f74284117ce3fd1e92;hp=e952eacbe60f5ed228f7a4cc25b2cf4ce8b44857;hpb=d23b97ed26bc0608c9ba1037b66058c709e83765;p=fa-stable.git

diff --git a/reporting/rep104.php b/reporting/rep104.php
index e952eacb..eabb5956 100644
--- a/reporting/rep104.php
+++ b/reporting/rep104.php
@@ -38,7 +38,7 @@ function fetch_items($category=0)
 				".TB_PREF."stock_category.description
 			FROM ".TB_PREF."stock_master,
 				".TB_PREF."stock_category
-			WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id";
+			WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id AND NOT ".TB_PREF."stock_master.inactive";
 		if ($category != 0)
 			$sql .= " AND ".TB_PREF."stock_category.category_id = ".db_escape($category);
 		$sql .= " ORDER BY ".TB_PREF."stock_master.category_id,