opendentalsupport.com is an independent community resource. We are NOT affiliated with, endorsed by, or sponsored by Open Dental Software, Inc. Open Dental® is a registered trademark of Open Dental Software, Inc.

Open Dental Answers. Instantly.

40+ guides, SQL queries, and troubleshooting articles for Open Dental users. Search for any topic below.

Browse by Category

Latest Articles

SQL Queries3/29/2026

Open Dental Broken Appointments Query

Need to track patient attendance? Use this open dental broken appointments query to quickly identify patients with broken appointments within a specific date range.

SQL Queries3/29/2026

Scheduled Production Query for Tomorrow

Need to know your daily goal? Use this open dental scheduled production query to instantly see the total production value for all appointments scheduled tomorrow.

SQL Queries3/29/2026

Patient Balance Report Query

Need to identify patients with high balances? Use this simple open dental patient balance query to pull a list of accounts owing over a specific amount today.

SQL Queries3/29/2026

Open Dental Write-offs by Carrier Query

Need to track insurance adjustments? Use this open dental writeoffs by carrier query to easily identify total write-offs per insurance company for your practice.

SQL Queries3/29/2026

Open Dental AR Aging Query

Need a custom report for patient balances? Use this open dental AR aging query to identify overdue accounts and manage your practice's cash flow effectively.

SQL Queries3/28/2026

Open Dental Production by Procedure Query

Need to track production by procedure code? Use this ready-to-use SQL query to pull detailed production data directly from your Open Dental database.

SQL Queries3/28/2026

Active Patients by Insurance Carrier

Need to see which active patients have specific insurance? Use this open dental patients by insurance query to generate a clean list for your practice.

SQL Queries3/28/2026

Track Insurance Payment Speed by Carrier

Use this open dental insurance payment speed query to identify which carriers are slow to pay, helping you optimize your practice's revenue cycle management.

SQL Queries3/28/2026

Hygiene Recare Overdue List with Phone Numbers

Need to contact overdue hygiene patients? Use this open dental recall list with phone query to quickly generate a list of active patients for your front desk.

SQL Queries3/28/2026

Case Acceptance Rate by Provider

Need to track treatment plan success? Use this open dental case acceptance rate query to see which providers are closing the most treatment plans in your office.