Further changes in manufacturing, added unit_cost in issues and requirements
[fa-stable.git] / reporting / rep308.php
index 53f8195eecdb1b57db556fc89e809c4fd312efaa..08b8e89806914046e52c25bdb642b90cd1bac28d 100644 (file)
@@ -67,7 +67,7 @@ function fetch_items($category=0)
                                stock.category_id,units,
                                cat.description
                        FROM ".TB_PREF."stock_master stock LEFT JOIN ".TB_PREF."stock_category cat ON stock.category_id=cat.category_id
-                               WHERE mb_flag <> 'D'";
+                               WHERE mb_flag <> 'D' AND mb_flag <> 'F'";
                if ($category != 0)
                        $sql .= " AND cat.category_id = ".db_escape($category);
                $sql .= " ORDER BY stock.category_id, stock_id";