diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2013-02-17 16:26:50 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2013-02-17 16:26:50 -0800 |
| commit | 1a887c2d93bb897bf19362a4eff3cf41b834a617 (patch) | |
| tree | 7229a47bb943e499278bec649e41ef81067e86e8 | |
| parent | 741b6bf4e2532238860bc5f968bd24c6698d5c5f (diff) | |
fix istax line item search with tax-pkg_address on, RT#21459
| -rw-r--r-- | httemplate/search/cust_bill_pkg.cgi | 7 |
1 files 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; |