Report for ADA codes per clinic per provider

For users or potential users.
Post Reply
ForrestGumpDDS
Posts: 177
Joined: Fri Oct 14, 2011 3:31 pm

Report for ADA codes per clinic per provider

Post by ForrestGumpDDS » Wed Mar 24, 2021 9:13 am

Hello,
I was wondering how to adapt the current report to separate income generated by certain codes (or code groups) per clinic? We use a "Clinic" feature and want to see the report on one clinic separate from the other one.
The codes we are looking for on the report are:
a. How many D1110, D1120
b. How many D0150
c. How many D0120
d. How many D0140
e. How many D2740

If the codes are set up as a range, I can modify sql query myself, but for some reason I could not get a desired result with the existing query.

I'm using a query #1135. Can you suggest how to format the query to limit the patients assigned to only one clinic? That would be all I need I think.

joes
Posts: 239
Joined: Tue Aug 13, 2019 12:41 pm

Re: Report for ADA codes per clinic per provider

Post by joes » Thu Mar 25, 2021 8:36 am

An Open Dental technician may be able to help you find a similar query or assist you in submitting a custom query request. Please call 503-363-5432 or see our contact page for other ways to get in touch with a technician, https://www.opendental.com/contact.html.
Joe Sullivan
Open Dental Software
http://www.opendental.com

Post Reply