Issue Resolution:

Resolution:

The check number field only has a 12-character limit. Remove some to have that amount, and it will save.

Resolution for Issue 'Error: UPDATE statement conflicted with the CHECK constraint “ck:lgract. nxtchk”. The confliction occurred in the database table “dbo.lgract, column nxtchk. The statement has been terminated when paying credit card' available: Yes (Solved).
Source: Sage Community forums.
Disclaimer: Accounting File Repair Support is an independant provider of database-related services and is not affiliated with Sage or Intuit.

Error: UPDATE statement conflicted with the CHECK constraint “ck:lgract. nxtchk”. The confliction occurred in the database table “dbo.lgract, column nxtchk. The statement has been terminated when paying credit card: this issue or error code is a known issue related to Sage accounting products. Support for this issue is available either by self-service or paid support options. Experts are available to resolve your Sage issue to ensure minimal downtime and continue running your business. First try to resolve the issue yourself by looking for a resolution described below. If you are experiencing too many issues, you may want to transition from Sage 50 to Quickbooks. See also: migrate from Sage 50 Quantum to Sage 50 Pro/Premium or how to downgrade from Sage. If it is a complex issue or you are unable to solve the issue, you may contact us by contacting Sage Repair or by using other support options.

Ad:
Support for column
Sage Repair will resolve it efficiently and affordably. Guaranteed resolution of your issue, or you pay nothing!

Additional Support Options: