From 1a887c2d93bb897bf19362a4eff3cf41b834a617 Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Sun, 17 Feb 2013 16:26:50 -0800 Subject: [PATCH] fix istax line item search with tax-pkg_address on, RT#21459 --- httemplate/search/cust_bill_pkg.cgi | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/httemplate/search/cust_bill_pkg.cgi b/httemplate/search/cust_bill_pkg.cgi index df040fff6..4308e247e 100644 --- a/httemplate/search/cust_bill_pkg.cgi +++ b/httemplate/search/cust_bill_pkg.cgi @@ -650,8 +650,11 @@ if ( $cgi->param('nottax') ) { } elsif ( $conf->exists('tax-pkg_address') ) { - $join_pkg .= ' LEFT JOIN cust_bill_pkg_tax_location USING ( billpkgnum ) - LEFT JOIN cust_location USING ( locationnum ) '; + $join_pkg .= ' + LEFT JOIN cust_bill_pkg_tax_location USING ( billpkgnum ) + LEFT JOIN cust_location ON cust_bill_pkg_tax_location.locationnum + = cust_location.locationnum + '; #quelle kludge, somewhat false laziness w/report_tax.cgi s/cust_pkg\.locationnum/cust_bill_pkg_tax_location.locationnum/g for @where; -- 2.20.1