projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
ack! count credits, not payments twice
[freeside.git]
/
httemplate
/
search
/
report_receivables.cgi
diff --git
a/httemplate/search/report_receivables.cgi
b/httemplate/search/report_receivables.cgi
index
f0274d0
..
1fd7d03
100755
(executable)
--- a/
httemplate/search/report_receivables.cgi
+++ b/
httemplate/search/report_receivables.cgi
@@
-12,8
+12,8
@@
select *,
,0
)
- coalesce(
,0
)
- coalesce(
- ( select sum(amount) from cust_
bill_pay
- where cust_bill.invnum = cust_
bill_pay
.invnum )
+ ( select sum(amount) from cust_
credit_bill
+ where cust_bill.invnum = cust_
credit_bill
.invnum )
,0
)
,0
)
@@
-33,8
+33,8
@@
select *,
,0
)
- coalesce(
,0
)
- coalesce(
- ( select sum(amount) from cust_
bill_pay
- where cust_bill.invnum = cust_
bill_pay
.invnum )
+ ( select sum(amount) from cust_
credit_bill
+ where cust_bill.invnum = cust_
credit_bill
.invnum )
,0
)
,0
)
@@
-55,8
+55,8
@@
select *,
,0
)
- coalesce(
,0
)
- coalesce(
- ( select sum(amount) from cust_
bill_pay
- where cust_bill.invnum = cust_
bill_pay
.invnum )
+ ( select sum(amount) from cust_
credit_bill
+ where cust_bill.invnum = cust_
credit_bill
.invnum )
,0
)
,0
)
@@
-77,8
+77,8
@@
select *,
,0
)
- coalesce(
,0
)
- coalesce(
- ( select sum(amount) from cust_
bill_pay
- where cust_bill.invnum = cust_
bill_pay
.invnum )
+ ( select sum(amount) from cust_
credit_bill
+ where cust_bill.invnum = cust_
credit_bill
.invnum )
,0
)
,0
)
@@
-98,8
+98,8
@@
select *,
,0
)
- coalesce(
,0
)
- coalesce(
- ( select sum(amount) from cust_
bill_pay
- where cust_bill.invnum = cust_
bill_pay
.invnum )
+ ( select sum(amount) from cust_
credit_bill
+ where cust_bill.invnum = cust_
credit_bill
.invnum )
,0
)
,0
)
@@
-121,8
+121,8
@@
where 0 <
,0
)
- coalesce(
,0
)
- coalesce(
- ( select sum(amount) from cust_
bill_pay
- where cust_bill.invnum = cust_
bill_pay.invnum
)
+ ( select sum(amount) from cust_
credit_bill
+ where cust_bill.invnum = cust_
credit_bill.invnum
)
,0
)
,0
)