link new tax report to cust_credit_bill_pkg for credits, RT#12332

diff --git a/httemplate/search/cust_credit_bill_pkg.html b/httemplate/search/cust_credit_bill_pkg.html
index 291034c..c699547 100644 (file)
--- a/httemplate/search/cust_credit_bill_pkg.html
+++ b/httemplate/search/cust_credit_bill_pkg.html
@@ -347,12 +347,12 @@ my $join_pkg;
 
 my $join_cust_bill_pkg = 'LEFT JOIN cust_bill_pkg USING ( billpkgnum';
 if ( $cgi->param('iscredit') eq 'rate' ) {
 
 my $join_cust_bill_pkg = 'LEFT JOIN cust_bill_pkg USING ( billpkgnum';
 if ( $cgi->param('iscredit') eq 'rate' ) {

-  $join_pkg .= ', billpkgtaxratelocationnum )';
+  $join_cust_bill_pkg .= ', billpkgtaxratelocationnum )';

 } elsif ( $conf->exists('tax-pkg_address') ) {
 } elsif ( $conf->exists('tax-pkg_address') ) {

-  $join_pkg .= ', billpkgtaxlocationnum )';
+  $join_cust_bill_pkg .= ', billpkgtaxlocationnum )';

   push @where, "billpkgtaxratelocationnum IS NULL";
 } else {
   push @where, "billpkgtaxratelocationnum IS NULL";
 } else {

-  $join_pkg .= ' )';
+  $join_cust_bill_pkg .= ' )';

   push @where, "billpkgtaxratelocationnum IS NULL";
 }
 
   push @where, "billpkgtaxratelocationnum IS NULL";
 }