X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep307.php;h=aee04a26db9231d8d90921acb1d194b07e1b4b6d;hb=4caf520181fb8539cb52079552b650aef81cb1cb;hp=214b5704feb62e353464d8aa5051d86524b7170b;hpb=8ffddf50ffbe93672c769e2cf0501d0f9125e2a0;p=fa-stable.git diff --git a/reporting/rep307.php b/reporting/rep307.php index 214b5704..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"; @@ -104,14 +104,11 @@ function inventory_movements() else $cat = get_category_name($category); -// if ($location == ALL_TEXT) -// $location = ''; if ($location == '') $loc = _('All'); else $loc = get_location_name($location); - //$cols = array(0, 100, 300, 365, 440, 540, 640, 715); $cols = array(0, 60, 220, 240, 310, 380, 450, 520); $headers = array(_('Category'), _('Description'), _('UOM'), _('Opening'), _('Quantity In'), _('Quantity Out'), _('Balance'));