projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Dimensions not utilized in Direct Invoice/Delivery
[fa-stable.git]
/
reporting
/
rep302.php
diff --git
a/reporting/rep302.php
b/reporting/rep302.php
index 75feef57e657d6cf1286dd100fbf1bfdcac86515..cdeae91dc7e4be8c7e5ca383afbdfa0a77635a25 100644
(file)
--- a/
reporting/rep302.php
+++ b/
reporting/rep302.php
@@
-40,7
+40,7
@@
function getTransactions($category, $location)
FROM (".TB_PREF."stock_master,
".TB_PREF."stock_category)
LEFT JOIN ".TB_PREF."stock_moves ON
FROM (".TB_PREF."stock_master,
".TB_PREF."stock_category)
LEFT JOIN ".TB_PREF."stock_moves ON
- (".TB_PREF."stock_master.stock_id=".TB_PREF."stock_moves.stock_id
OR ".TB_PREF."stock_master.stock_id IS NULL
)
+ (".TB_PREF."stock_master.stock_id=".TB_PREF."stock_moves.stock_id)
WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
AND (".TB_PREF."stock_master.mb_flag='B' OR ".TB_PREF."stock_master.mb_flag='M')";
if ($category != 0)
WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
AND (".TB_PREF."stock_master.mb_flag='B' OR ".TB_PREF."stock_master.mb_flag='M')";
if ($category != 0)