In Banks, when posting adjustments to General Ledger, we may receive the error below:
Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] Conversion failed when converting the varchar value 'ment 17990' to data type int. Native error:245
This error may occur as a result of editing the system defined adjustment reference field on the adjustment record. For example:
System generated reference that will post without error: Adjustment created to offset amount of voided payment 12345 Edited reference that will not post: Correction - Adjustment created to offset amount of voided payment 17990
To resolve: Remove the change made to the reference to resolve the error message. If additional notes are needed, add the information in the Notes area. The number of characters in the reference should remain at 54 + the Payment number.
Steps to Duplicate
1. Select Banks from the navigation bar. 2. Click Post Adjustments to the General Ledger. 3. Press Validate. Note that the validation is successful. 4. Press Post Now and receive error.