From 58c17d959b59b61da9a5b6b752bb8c295d61fc63 Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Thu, 22 Dec 2016 17:29:23 -0800 Subject: [PATCH] fix "missing FROM-clause entry for table cust_pkg" error pulling up credits from vendor tax report, RT#73852 --- httemplate/search/cust_credit_bill_pkg.html | 2 ++ 1 file changed, 2 insertions(+) diff --git a/httemplate/search/cust_credit_bill_pkg.html b/httemplate/search/cust_credit_bill_pkg.html index 0cdd8defd..4a14893e8 100644 --- a/httemplate/search/cust_credit_bill_pkg.html +++ b/httemplate/search/cust_credit_bill_pkg.html @@ -457,6 +457,8 @@ if ( $cgi->param('nottax') ) { push @where, "billpkgtaxratelocationnum IS NULL"; } + $join_pkg .= ' LEFT JOIN cust_pkg USING ( pkgnum ) '; + $join_pkg .= ' LEFT JOIN tax_rate_location USING ( taxratelocationnum ) '; } elsif ( $conf->exists('tax-pkg_address') ) { -- 2.11.0