projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Fixed comment for crm_contacts table in init sql files.
[fa-stable.git]
/
reporting
/
rep309.php
diff --git
a/reporting/rep309.php
b/reporting/rep309.php
index 6b769bf322a37ca822eb846aa9d51c11a28351ae..67f4a07c35333ab18d937ad24834ee8231365b74 100644
(file)
--- a/
reporting/rep309.php
+++ b/
reporting/rep309.php
@@
-38,7
+38,7
@@
function getTransactions($category, $from, $to)
item.stock_id,
item.description,
line.unit_price * trans.rate AS unit_price,
item.stock_id,
item.description,
line.unit_price * trans.rate AS unit_price,
- SUM(
line.quantity) as
quantity
+ SUM(
IF(line.debtor_trans_type = ".ST_CUSTCREDIT.", -line.quantity, line.quantity)) AS
quantity
FROM ".TB_PREF."stock_master item,
".TB_PREF."stock_category category,
".TB_PREF."debtor_trans trans,
FROM ".TB_PREF."stock_master item,
".TB_PREF."stock_category category,
".TB_PREF."debtor_trans trans,