X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fcust_main.pm;h=34ca9d4afafe43de0f11445562f367487b53f035;hb=3beb53d9d87b5667c306dc4abd6cd6c0165ad852;hp=27f97f30ebfd88231b921087fc568db4bd206327;hpb=0d1d2630e726ab4ce32bab9c3e4a889eee43fcb4;p=freeside.git

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 )
             )
 "; }