diff options
| -rwxr-xr-x | httemplate/search/report_receivables.cgi | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi index 108453d43..f42269f65 100755 --- a/httemplate/search/report_receivables.cgi +++ b/httemplate/search/report_receivables.cgi @@ -70,14 +70,14 @@ END ( select count(*) from cust_pkg where cust_main.custnum = cust_pkg.custnum and $recurring - and cancel = 0 or cancel is null + and ( cancel = 0 or cancel is null ) ) as uncancelled_pkgs, ( select count(*) from cust_pkg where cust_main.custnum = cust_pkg.custnum and $recurring - and cancel = 0 or cancel is null - and susp = 0 or susp is null + and ( cancel = 0 or cancel is null ) + and ( susp = 0 or susp is null ) ) as active_pkgs END |