Unearned Income Report
Posted: 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
************** 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