Error - Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, < subquery is used as an expression. Native error: 512

When running a General Ledger Report in the General Ledger, then filter it on a specific department, we may receive this error : 

Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, < subquery is used as an expression. Native error: 512

[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared. Native error: 16945

We are currently investigating this issue and will update this article.

Steps to Duplicate

1. Login to The Financial Edge, go to General Ledger.
2. Go to Reports, Account Reports, General Ledger Report.
3. Click new report and go to the filters tab.
4. Go to department and click all and change to selected.
5. Choose one department and click ok.
6. Click preview and see the error.

Was this article helpful?