diff options
| author | Mark Wells <mark@freeside.biz> | 2014-02-28 12:47:31 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2014-02-28 12:47:31 -0800 |
| commit | 308c73858741a153c8e10aecaf7f00e534824013 (patch) | |
| tree | ba1f7ee5bea9cb408b4fbf8893971e645452fba5 /httemplate/search/report_tax.cgi | |
| parent | e24da2a00485cfe81e34731ebebb6d69d4b0eab9 (diff) | |
report fixes, #25899
Diffstat (limited to 'httemplate/search/report_tax.cgi')
| -rwxr-xr-x | httemplate/search/report_tax.cgi | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/httemplate/search/report_tax.cgi b/httemplate/search/report_tax.cgi index 111f22d3d..916d44bce 100755 --- a/httemplate/search/report_tax.cgi +++ b/httemplate/search/report_tax.cgi @@ -274,7 +274,8 @@ if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) { $where .= ' AND cust_main.agentnum = '. $agent->agentnum; } -my $nottax = 'cust_bill_pkg.pkgnum != 0'; +my $nottax = + '(cust_bill_pkg.pkgnum != 0 OR cust_bill_pkg.feepart IS NOT NULL)'; # one query for each column of the report # plus separate queries for the totals row |