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).