Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the CHECK constraint CK_SB7RECORDAUTOPAYEES_AMOUNT". "

When saving an organization record after creating an automatic payment plan, the following error may occur:
Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the CHECK constraint
"CK_SB7RECORDAUTOPAYEES_AMOUNT". The conflict occurred in database "iowa", table "dbo.SB7RECORDAUTOPAYPAYEES", column 'AMOUNT'.
Native Error: 547
Error: General ODBC Error: [Microsoft][ODBC SQL Server]The statement has been terminated.
Native error: 3621

This occurs when a payment plan is distributed on the Student Billing Detail tab to multiple records, and there is no amount distributed to one record as that particular record owes a fraction (ex. $0.02 compared to $2952.91 of the other record) and the percentage calculation results in a blank entry for the first record.  To resolve the error,
1. Select the Student Billing Detail tab of the payment plan.
2. If any record has a blank Apply this amount column, either highlight and delete this row if payments should not be distributed to this record, OR enter a value in this field ($0 is accepted).

Environment

 7.82.104.0018

Was this article helpful?