Error: General ODBC Error: Subquery returned more than 1 value This is not permitted Native error - when displaying 1099 reports

When displaying 1099 reports, the 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 =, !=, <, <= , >, >= or when the subquery is used as an expression.
Native error:512 [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation.
Native error:8153 may occur

We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

  1. In Accounts Payable, go to Mail.
  2. Click Forms.
  3. Click 1099 Forms.
  4. Click New.
  5. Click Display Report.
  6. View error message.

Was this article helpful?