Statement(s) Could Not Be Prepared. (SQL Error 37000)

Symptoms

"37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared" This error occurs when generating a report.

Cause

There is a comma in a Reference Code.

Resolution

SQL Server interprets the comma as a separator. Remove the comma from the Reference Code within your GL Package and then modify your report formats to avoid this error.

References