diff options
| author | Mark Wells <mark@freeside.biz> | 2012-05-16 15:45:10 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2012-05-16 15:45:10 -0700 |
| commit | 27b6c1f10411eb95abec60d6e14a8a63b279cabd (patch) | |
| tree | 8c234684252d1fe616f5cca268cba6d34e20b178 /httemplate | |
| parent | 1f119bfc22ca45df1e3714444f41851fce503fb5 (diff) | |
fix prepaid income report SQL, #13289
Diffstat (limited to 'httemplate')
| -rw-r--r-- | httemplate/search/cust_bill_pkg.cgi | 2 |
1 files changed, 1 insertions, 1 deletions
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 ) ) ) { |