91 day report

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
paulgordon
Posts: 8
Joined: Tue Jun 08, 2010 1:56 pm

91 day report

Post by paulgordon » Mon Aug 23, 2010 6:40 pm

Hello, I would like to know which patient accounts turn 91 days old to send to our collection process. I see a 30, 60 & 90 day field on the patient table, but is there a way to determine the date that the account turned the age (91 days in this case) from these fields?
thanks

User avatar
jordansparks
Site Admin
Posts: 5770
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: 91 day report

Post by jordansparks » Mon Aug 23, 2010 9:59 pm

All accounts in the +90 category. As you send to collections, make adjustments to zero out their accounts. Then, the next time you run the report, they will all be new.
Jordan Sparks, DMD
http://www.opendental.com

Post Reply