don't show 'N/A' statustext as a failed billing event

[freeside.git] / httemplate / search / cust_bill_event.cgi

diff --git a/httemplate/search/cust_bill_event.cgi b/httemplate/search/cust_bill_event.cgi
index df4dcbf..a21fb19 100644 (file)
--- a/httemplate/search/cust_bill_event.cgi
+++ b/httemplate/search/cust_bill_event.cgi
@@ -15,7 +15,9 @@ my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi);
 
 my $where = " WHERE cust_bill_event._date >= $beginning".
             "   AND cust_bill_event._date <= $ending";
-$where .= " AND statustext != '' AND statustext IS NOT NULL"
+$where .= " AND statustext != '' ".
+          " AND statustext IS NOT NULL ".
+          " AND statustext != 'N/A' "
   if $cgi->param('failed');
 
 my $sql_query = {