From: ivan Date: Tue, 9 Nov 2004 09:13:38 +0000 (+0000) Subject: fix for correct reporting of generic taxes X-Git-Tag: freeside_1_4_2~22 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=a744e0eb79729b05563679fdf8ede6468621bc0f fix for correct reporting of generic taxes --- diff --git a/httemplate/search/report_tax.cgi b/httemplate/search/report_tax.cgi index e3d203eb3..601763bba 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 = ''"; + : "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",