X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_tax_exempt_pkg.cgi;h=ba3f2758c6b01ebad9463da0f5b08237a3e6e636;hb=85c78d955fbc2fd6c3991156b387d37c185b9f64;hp=382dbc4761438b507a02591f6e7754ad29b4b786;hpb=ac01b85bf09d058d3cda097dffbf4e8fce5f4305;p=freeside.git diff --git a/httemplate/search/cust_tax_exempt_pkg.cgi b/httemplate/search/cust_tax_exempt_pkg.cgi index 382dbc476..ba3f2758c 100644 --- a/httemplate/search/cust_tax_exempt_pkg.cgi +++ b/httemplate/search/cust_tax_exempt_pkg.cgi @@ -144,6 +144,10 @@ if ( $cgi->param('classnum') =~ /^(\d+)$/ ) { push @where, "COALESCE(part_pkg.classnum,0) = $1"; } +# no reason ever to show the negative exemptions created by credits. +# they'll just confuse people. +push @where, "creditbillpkgnum IS NULL"; + my $where = scalar(@where) ? 'WHERE '.join(' AND ', @where) : ''; my $count_query = "SELECT COUNT(*), SUM(amount)".