X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_tax_exempt_pkg.cgi;h=7b4a6d0cde86aa5d87e6436f189433248f2ef836;hp=382dbc4761438b507a02591f6e7754ad29b4b786;hb=1fc8addc56f8daf12397da568eb1ac1b27fd3984;hpb=df1ebf662a9fc3f89503036e0dbf6833c1b95f9e diff --git a/httemplate/search/cust_tax_exempt_pkg.cgi b/httemplate/search/cust_tax_exempt_pkg.cgi index 382dbc476..7b4a6d0cd 100644 --- a/httemplate/search/cust_tax_exempt_pkg.cgi +++ b/httemplate/search/cust_tax_exempt_pkg.cgi @@ -107,7 +107,6 @@ my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi); if ( $beginning || $ending ) { push @where, "_date >= $beginning", "_date <= $ending"; - #"payby != 'COMP'; } if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) { @@ -144,6 +143,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)".