Incident:

you were experiencing difficulty creating an advanced query on Collection status "Not disputed" and that you have tried different joins and filters but are unable to find any open customer invoices with the status "Not disputed".

Resolution:

While doing the investigation and consulting the engineering team, I made you aware that the issue determined is working as designed. This is based on two logical reasons : (a) Not disputed (status = 0) records are not stored in custDispute table (b ) Collection status is a dynamically calculated field of dataSource CustTrans, based on the condition that if custTrans.recID  is found in custDispute table then it displays its status from custDispute table and if not found then for those records it displays not disputed by default.