X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=httemplate%2Fsearch%2Fcust_credit_bill_pkg.html;h=c6995470dc5775b57a6c431d5c33c7af8b422f08;hb=386e5631dd76e01faaad23a15d5977e13587b135;hp=f34603508c5969b7d5d3589bb1c36da5ca077d9c;hpb=636dd1f25af52d35efe7a323a5765ff5adeadf83;p=freeside.git diff --git a/httemplate/search/cust_credit_bill_pkg.html b/httemplate/search/cust_credit_bill_pkg.html index f34603508..c6995470d 100644 --- a/httemplate/search/cust_credit_bill_pkg.html +++ b/httemplate/search/cust_credit_bill_pkg.html @@ -347,17 +347,15 @@ my $join_pkg; 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') ) { - $join_pkg .= ', billpkgtaxlocationnum )'; + $join_cust_bill_pkg .= ', billpkgtaxlocationnum )'; push @where, "billpkgtaxratelocationnum IS NULL"; } else { - $join_pkg .= ' )'; + $join_cust_bill_pkg .= ' )'; push @where, "billpkgtaxratelocationnum IS NULL"; } - )'; - if ( $cgi->param('nottax') ) { $join_pkg = ' LEFT JOIN cust_pkg USING ( pkgnum )