X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_tax.cgi;h=8cf6bd7588162fc78aa96a9b5a163684f3d2285d;hb=ba50ec34aa882a14256550052a2b061d5c6fcb81;hp=601763bba29e8f77b5e941c60d8dfaee0efcc28e;hpb=a744e0eb79729b05563679fdf8ede6468621bc0f;p=freeside.git diff --git a/httemplate/search/report_tax.cgi b/httemplate/search/report_tax.cgi index 601763bba..8cf6bd758 100755 --- a/httemplate/search/report_tax.cgi +++ b/httemplate/search/report_tax.cgi @@ -125,7 +125,7 @@ foreach my $r ( my $named_tax = $r->taxname ? 'AND itemdesc = '. dbh->quote($r->taxname) - : "AND itemdesc IS NULL OR itemdesc = '' OR itemdesc = 'Tax'"; + : "AND ( itemdesc IS NULL OR itemdesc = '' OR itemdesc = 'Tax' )"; my $x = scalar_sql($r, \@taxparam, "SELECT SUM(cust_bill_pkg.setup+cust_bill_pkg.recur) $taxwhere ". "AND pkgnum = 0 $named_tax",