Daily payments query

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
Jorgebon
Posts: 502
Joined: Mon Jun 18, 2007 2:25 pm
Location: Mayaguez, PR
Contact:

Daily payments query

Post by Jorgebon » Tue Oct 29, 2013 5:39 am

I've noticed that the queries for listing the daily payments made by patients and insurance companies do not take into account payments made that are not attached to a specific procedure. For example, a payment made by a patient for a broken appointment will not appear in the query results. Is there any query in the examples page that will show these payments along with the "procedure linked" payments?
Jorge Bonilla DMD
Open Dental user since May 2005

Post Reply