Query on overdue pledge installments

Patty Driscoll 3

I currently report on pledge installments coming due and overdue from database view Mail>Reminders. I cannot seem to replicate this in NXT view query. Criteria: Gift status=active, Installment Due date<today, Installment Amount Due>$0. Results bring up all active pledges where installments were due in the past, but not those that were either not paid at all, or paid less than what was due. The results also do not show me how much of the installment is now overdue because NXT query is missing the installment balance field, even though it does appear if you look at the individual donor's pledge schedule. How can I get this information accurately in NXT Query?