X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep307.php;h=aee04a26db9231d8d90921acb1d194b07e1b4b6d;hb=41bdd7820211334cef5c087889e6cd5e6e45af86;hp=19db40997a4ba6b9485a043a695be1afe9548f91;hpb=a9d55e1c13cbd6a6305b9322ec8621a06516f9f3;p=fa-stable.git diff --git a/reporting/rep307.php b/reporting/rep307.php index 19db4099..aee04a26 100644 --- a/reporting/rep307.php +++ b/reporting/rep307.php @@ -37,7 +37,7 @@ function fetch_items($category=0) 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";