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 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)". |