X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=httemplate%2Fsearch%2Fcust_tax_exempt_pkg.cgi;h=41b7b91928963d90b08048a699dd39c8c572daeb;hb=3f0e44be5d3d30ca99f169da7ca5622033f704b4;hp=267c9383a62a90c13e4472ba30ea58cbe849eedb;hpb=baf5cfb99275c060748ec1c212e646759af6e96b;p=freeside.git diff --git a/httemplate/search/cust_tax_exempt_pkg.cgi b/httemplate/search/cust_tax_exempt_pkg.cgi index 267c9383a..41b7b9192 100644 --- a/httemplate/search/cust_tax_exempt_pkg.cgi +++ b/httemplate/search/cust_tax_exempt_pkg.cgi @@ -163,6 +163,10 @@ if ( $cgi->param('out') ) { } +# 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)".