projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Bug in presenting ST_JOURNAL in AR/AP Reports.
[fa-stable.git]
/
sales
/
includes
/
db
/
customers_db.inc
diff --git
a/sales/includes/db/customers_db.inc
b/sales/includes/db/customers_db.inc
index 3b6ac6315cd0f86fce9f4fe26413520e8318f040..bc1dcbd90f4cf93214570a9bce83f4176773fb4d 100644
(file)
--- a/
sales/includes/db/customers_db.inc
+++ b/
sales/includes/db/customers_db.inc
@@
-70,7
+70,7
@@
function get_customer_details($customer_id, $to=null, $all=true)
$past1 = get_company_pref('past_due_days');
$past2 = 2 * $past1;
// removed - debtor_trans.alloc from all summations
$past1 = get_company_pref('past_due_days');
$past2 = 2 * $past1;
// removed - debtor_trans.alloc from all summations
- $sign = "IF(`type` IN(".implode(',', array(ST_CUSTCREDIT,ST_CUSTPAYMENT,ST_BANKDEPOSIT
,ST_JOURNAL
))."), -1, 1)";
+ $sign = "IF(`type` IN(".implode(',', array(ST_CUSTCREDIT,ST_CUSTPAYMENT,ST_BANKDEPOSIT))."), -1, 1)";
if ($all)
$value = "IFNULL($sign*(trans.ov_amount + trans.ov_gst + trans.ov_freight + trans.ov_freight_tax + trans.ov_discount),0)";
else
if ($all)
$value = "IFNULL($sign*(trans.ov_amount + trans.ov_gst + trans.ov_freight + trans.ov_freight_tax + trans.ov_discount),0)";
else