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
/
rep303.php
diff --git
a/reporting/rep303.php
b/reporting/rep303.php
index d9904bfc101b368d51663183b24f306e65438e1d..a7beebc1988b1ba5b0a39a83b44acc6a18be8b63 100644
(file)
--- a/
reporting/rep303.php
+++ b/
reporting/rep303.php
@@
-41,7
+41,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)