projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
[0004216] Print Work Orders: database error fixed when voided WO is in selected range.
[fa-stable.git]
/
reporting
/
rep302.php
diff --git
a/reporting/rep302.php
b/reporting/rep302.php
index bfb515f1257ef238fdb0bb74b746eb3aa5fb148f..cdfd0e9a21e89d81a92422c3d063453f77f6d2ae 100644
(file)
--- a/
reporting/rep302.php
+++ b/
reporting/rep302.php
@@
-36,7
+36,7
@@
function getTransactions($category, $location)
item.stock_id,
item.description, item.inactive,
IF(move.stock_id IS NULL, '', move.loc_code) AS loc_code,
item.stock_id,
item.description, item.inactive,
IF(move.stock_id IS NULL, '', move.loc_code) AS loc_code,
- SUM(IF
NULL(move.stock_id, 0
)) AS qty_on_hand
+ SUM(IF
(move.stock_id IS NULL, 0, move.qty
)) AS qty_on_hand
FROM (".TB_PREF."stock_master item,"
.TB_PREF."stock_category category)
LEFT JOIN ".TB_PREF."stock_moves move ON item.stock_id=move.stock_id
FROM (".TB_PREF."stock_master item,"
.TB_PREF."stock_category category)
LEFT JOIN ".TB_PREF."stock_moves move ON item.stock_id=move.stock_id