diff options
| -rw-r--r-- | FS/FS/cust_main.pm | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm index 27f97f30e..34ca9d4af 100644 --- a/FS/FS/cust_main.pm +++ b/FS/FS/cust_main.pm @@ -2917,6 +2917,7 @@ sub susp_sql { " AND 0 = ( SELECT COUNT(*) FROM cust_pkg WHERE cust_pkg.custnum = cust_main.custnum AND ( cust_pkg.susp IS NULL OR cust_pkg.susp = 0 ) + AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 ) ) "; } |