diff options
| author | Mark Wells <mark@freeside.biz> | 2015-01-06 13:03:18 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2015-01-06 13:07:39 -0800 |
| commit | db72d963d3acd790df17fee77830b3742c75c3e7 (patch) | |
| tree | 98027e4d531582fc9d4faa68ba12650b8dc10c00 /httemplate/search/cust_tax_exempt_pkg.cgi | |
| parent | 18a1b36c6f9d66385ecfd96154b923bd544843c2 (diff) | |
tax report fix for monthly exemptions + credits, #27698
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)". |