diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2016-12-22 17:29:24 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2016-12-22 17:29:24 -0800 |
| commit | acac1a271646cd2f9bfbb05a41372b360cbb5c8f (patch) | |
| tree | d8e2c2d09d2b31af6e28c2fd925bdcc45ba82b08 | |
| parent | 734745daedd3efc6728ebfdb48eac1af71960a06 (diff) | |
fix "missing FROM-clause entry for table cust_pkg" error pulling up credits from vendor tax report, RT#73852
| -rw-r--r-- | httemplate/search/cust_credit_bill_pkg.html | 2 |
1 files changed, 2 insertions, 0 deletions
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') ) { |