From bec96a5b94e6c2484a48ed2d4300a1294fa80de6 Mon Sep 17 00:00:00 2001 From: Mark Wells Date: Wed, 16 May 2012 15:45:40 -0700 Subject: fix prepaid income report SQL, #13289 --- httemplate/search/cust_bill_pkg.cgi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate') diff --git a/httemplate/search/cust_bill_pkg.cgi b/httemplate/search/cust_bill_pkg.cgi index fd215969a..a84f981e3 100644 --- a/httemplate/search/cust_bill_pkg.cgi +++ b/httemplate/search/cust_bill_pkg.cgi @@ -511,7 +511,7 @@ if ( $cgi->param('pkg_tax') ) { if ( $unearned ) { $count_query .= "SUM( $unearned_base ), SUM( $unearned_sql )"; } elsif ( $use_usage eq 'recurring' ) { - $count_query .= "SUM(setup + recur - usage)"; + $count_query .= "SUM(cust_bill_pkg.setup + cust_bill_pkg.recur - usage)"; } elsif ( $use_usage eq 'usage' ) { $count_query .= "SUM(usage)"; } elsif ( scalar( grep( /locationtaxid/, $cgi->param ) ) ) { -- cgit v1.2.1