From 3beb53d9d87b5667c306dc4abd6cd6c0165ad852 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 12 Dec 2004 08:34:36 +0000 Subject: [PATCH] fix customer status display for some cases with suspended accounts --- FS/FS/cust_main.pm | 1 + 1 file changed, 1 insertion(+) 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 ) ) "; } -- 2.11.0