X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=httemplate%2Fsearch%2Freport_newtax.cgi;fp=httemplate%2Fsearch%2Freport_newtax.cgi;h=5b8604b1db917f54170184cefe1a28f086652326;hb=3dc4beeec7a92332c1c21ad621d489bf52362b86;hp=0961bbb4cabc9264470cad232275e5b03685dcb6;hpb=67c32759b3f821277033c2abcb8e5a13877a2ac7;p=freeside.git 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 );