diff options
Diffstat (limited to 'httemplate/search/cust_tax_exempt_pkg.cgi')
| -rw-r--r-- | httemplate/search/cust_tax_exempt_pkg.cgi | 4 |
1 files changed, 4 insertions, 0 deletions
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)". |