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 --- FS/FS/cust_bill_pkg.pm | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'FS') diff --git a/FS/FS/cust_bill_pkg.pm b/FS/FS/cust_bill_pkg.pm index f196a0a22..6551ca829 100644 --- a/FS/FS/cust_bill_pkg.pm +++ b/FS/FS/cust_bill_pkg.pm @@ -1082,9 +1082,9 @@ and 'setuprecur' (set to "setup" or "recur" to limit to one or the other). sub owed_sql { my ($class, $start, $end, %opt) = @_; my $charged = - $opt{setuprecur} =~ /^s/ ? 'setup' : - $opt{setuprecur} =~ /^r/ ? 'recur' : - 'setup + recur'; + $opt{setuprecur} =~ /^s/ ? 'cust_bill_pkg.setup' : + $opt{setuprecur} =~ /^r/ ? 'cust_bill_pkg.recur' : + 'cust_bill_pkg.setup + cust_bill_pkg.recur'; if ( $opt{no_usage} ) { $charged .= ' - ' . $class->usage_sql; -- cgit v1.2.1