From: Ivan Kohler <ivan@freeside.biz>
Date: Fri, 23 Dec 2016 01:29:23 +0000 (-0800)
Subject: fix "missing FROM-clause entry for table cust_pkg" error pulling up credits from... 
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=58c17d959b59b61da9a5b6b752bb8c295d61fc63;ds=sidebyside

fix "missing FROM-clause entry for table cust_pkg" error pulling up credits from vendor tax report, RT#73852
---

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') ) {