Query – Patients who their “sum of Payments” is different from their “sum of Production fees”

[EFR]

Is there an existing query example (in https://opendentalsoft.com:1943/ODQuery ... yList.aspx) that shows, for a given date range,
a list of Patients whose “sum of Payments” (during the date range) is different from their “sum of Production fees” (for treatments they received during the date range).

I want to be able to identify patients that:
1. Paid for (old) outstanding payments
2. Did not pay the full amount for the treatments they received
3. Paid a “deposit” for an unearned future treatment

[joes]

I don't think we have any reports or queries that match your desired format. If you are interested in ordering a custom query, please fill out a Query Request Form here: https://opendentalsoft.com:1943/ODQuery ... tForm.aspx

[EFR]

Thanks for the prompt response. I'll check if I can apply for a custom query.