fix prepaid income report SQL, #13289

[freeside.git] / httemplate / search / cust_bill_pkg.cgi

diff --git a/httemplate/search/cust_bill_pkg.cgi b/httemplate/search/cust_bill_pkg.cgi
index fd21596..a84f981 100644 (file)
--- 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 ) ) ) {