Error: General ODBC error {MICROSOFT.EN_US} { ODBC SQL Server Driver} SQL Server Incorrect syntax near native error 102

Error: General ODBC error {MICROSOFT.EN_US} { ODBC SQL Server Driver} SQL Server Incorrect syntax near native error 102 occurs when adjusting a specific invoice to change.  Users are still able to enter the adjustment but the error occurs when saving the adjustment.
Contact Support and reference this article. 

Alternative solution:

If the invoice in question is paid via a credit Memo:
1. Unapply the credit memo.
2. Save and Close the Invoice.
3. Enter the adjustment.
4. Re-apply the credit memo to the invoice.
5. Save and close the invoice.

Environment

 7.80.94, patch 1 ; 7.75.259, patch 14

Was this article helpful?