diff options
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/Report/Tax.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/FS/FS/Report/Tax.pm b/FS/FS/Report/Tax.pm index acf9f4428..713be02df 100644 --- a/FS/FS/Report/Tax.pm +++ b/FS/FS/Report/Tax.pm @@ -358,13 +358,13 @@ sub report_internal { SELECT 1 FROM cust_tax_exempt_pkg JOIN cust_main_county USING (taxnum) WHERE cust_tax_exempt_pkg.billpkgnum = cust_bill_pkg.billpkgnum - AND cust_main_county.taxname = '$taxname' + AND COALESCE(cust_main_county.taxname,'Tax') = '$taxname' ) AND NOT EXISTS( SELECT 1 FROM cust_bill_pkg_tax_location JOIN cust_main_county USING (taxnum) WHERE cust_bill_pkg_tax_location.taxable_billpkgnum = cust_bill_pkg.billpkgnum - AND cust_main_county.taxname = '$taxname' + AND COALESCE(cust_main_county.taxname,'Tax') = '$taxname' ) "; warn "\nOUTSIDE:\n$sql_outside\n" if $DEBUG; |