projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Fixed inventory reports that didn't know about our new Fixed Asset flag.
[fa-stable.git]
/
reporting
/
rep308.php
diff --git
a/reporting/rep308.php
b/reporting/rep308.php
index 53f8195eecdb1b57db556fc89e809c4fd312efaa..08b8e89806914046e52c25bdb642b90cd1bac28d 100644
(file)
--- a/
reporting/rep308.php
+++ b/
reporting/rep308.php
@@
-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
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";
if ($category != 0)
$sql .= " AND cat.category_id = ".db_escape($category);
$sql .= " ORDER BY stock.category_id, stock_id";