Running a SQL command help

[PeteNicholson]

Dear Forum,

Would someone be so kind as to assist me running a SQL command.

I wish to generate a report for a provider showing total production, total collection, list of all write offs (both insurance and from patients with the amounts), list of outstanding collections detailing whether it is insurance or other.

Your assistance would be greatly appreciated.

Cheers,

Peter

[joes]

Hello Peter, our Support Technicians can assist you with searching our existing reports and example queries. We also have a Query Team that can write a custom query if an existing one does not suite your needs. Please call 503-363-5432 to get in touch with a Support Technician, or see our website for other ways to contact support, https://opendental.com/contact.html. Below are links to our query examples page and our query request form.

Query Examples: https://opendentalsoft.com:1943/ODQuery ... yList.aspx
Query Request Form: https://opendentalsoft.com:1943/ODQuery ... tForm.aspx