From 69b7b85a2f35062008efe5fc73e7769eef92ab11 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 15 Apr 2011 23:33:50 +0000 Subject: fix new tax report w/FS::tax_rate_location->location_sql, RT#12332 --- httemplate/search/report_newtax.cgi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate') diff --git a/httemplate/search/report_newtax.cgi b/httemplate/search/report_newtax.cgi index 0961bbb4c..5b8604b1d 100755 --- a/httemplate/search/report_newtax.cgi +++ b/httemplate/search/report_newtax.cgi @@ -121,7 +121,7 @@ foreach my $t (qsearch({ table => 'cust_bill_pkg', my $payby_itemdesc_loc = " payby != 'COMP' ". - "AND itemdesc = ? OR ? = '' AND itemdesc IS NULL ". + "AND ( itemdesc = ? OR ? = '' AND itemdesc IS NULL ) ". "AND ". FS::tax_rate_location->location_sql( map { $_ => $t->$_ } @taxparams ); -- cgit v1.2.1