Page 1 of 1

Unearned Income Report

Posted: Thu Apr 05, 2012 8:28 am
by Hersheydmd
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

Re: Unearned Income Report

Posted: Thu Apr 05, 2012 9:18 am
by jordansparks
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.

Re: Unearned Income Report

Posted: Fri Apr 06, 2012 4:01 pm
by Hersheydmd
OK, no problem.
I am off this week and planning to update anyway.