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

When saving a new vendor this message is returned: 
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] The statement has been terminated.
Native error: 3621
Contact Support and reference this article.  A copy of your database may be needed to resolve this error.

Steps to Duplicate


1. While in Accounts Payable select Records.
2. Select Vendors and then add a new Vendor.
3. Enter the Vendor name and address and GL distribution.
4. Save the Vendor and note the error appears.

Environment

 7.82.104. patch 11

Was this article helpful?