Tax included ption added.

[fa-stable.git] / reporting / rep104.php

diff --git a/reporting/rep104.php b/reporting/rep104.php
index e952eacbe60f5ed228f7a4cc25b2cf4ce8b44857..eabb5956881d0af33c9eba004ef1af0f3d1bb4b2 100644 (file)
--- 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,