X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_receivables.cgi;h=1fd7d03c7597a525fd3558bebbc23223c9b9038c;hp=f0274d02614e76b5f33b00f6d056ecc908ebd00d;hb=5a77da3b812de3d218edc3faba3aefc777e5ca71;hpb=1203c14b5b34bc848c3176899767a4fbc13f914a

diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi
index f0274d026..1fd7d03c7 100755
--- a/httemplate/search/report_receivables.cgi
+++ b/httemplate/search/report_receivables.cgi
@@ -12,8 +12,8 @@ select *,
                            ,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
                          )
 
@@ -33,8 +33,8 @@ select *,
                            ,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
                          )
 
@@ -55,8 +55,8 @@ select *,
                            ,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
                          )
 
@@ -77,8 +77,8 @@ select *,
                            ,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
                          )
 
@@ -98,8 +98,8 @@ select *,
                            ,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
                          )
 
@@ -121,8 +121,8 @@ where 0 <
                              ,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
                            )