Unearned Income Report

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
Hersheydmd
Posts: 703
Joined: Sun May 03, 2009 9:12 pm

Unearned Income Report

Post by Hersheydmd » Thu Apr 05, 2012 8:28 am

What is the "unearned income report" and why does OD crash when I try to run it using the "Total Liability" option. (OD v 7.9.17.0)
************** Exception Text **************
MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SUM(SplitAmt) Amount FROM paysplit,patient,definition WHERE paysplit.PatNum=pati' at line 1
Robert M Hersh DMD, FAGD
Univ. of Penn 1982
Brooklyn, NY 11234
https://www.facebook.com/pages/Robert-M ... 1471599429

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

Re: Unearned Income Report

Post by jordansparks » Thu Apr 05, 2012 9:18 am

On the reports page,
http://www.opendental.com/manual/reports.html
there is a link that tells what the report is for. Thanks for telling us about the error. But we can't duplicate it in the current version, so we're not going to take any action on it unless a user on the current version is able to get the error.
Jordan Sparks, DMD
http://www.opendental.com

User avatar
Hersheydmd
Posts: 703
Joined: Sun May 03, 2009 9:12 pm

Re: Unearned Income Report

Post by Hersheydmd » Fri Apr 06, 2012 4:01 pm

OK, no problem.
I am off this week and planning to update anyway.
Robert M Hersh DMD, FAGD
Univ. of Penn 1982
Brooklyn, NY 11234
https://www.facebook.com/pages/Robert-M ... 1471599429

Post Reply