Error: Data could not be saved The INSERT statement conflicted with the CHECK constraint CK_EVENTREGISTRANTPAYMENT_VALIDAMOUNT". The conflict occurred in database "XXXX", table "dbo.EVENTREGISTRANTPAYMENT", column 'AMOUNT'." - when adding payment

The following error may be received when attempting to add an additional payment to an Event registration:
Error: Data could not be saved. The INSERT statement conflicted with the CHECK constraint "CK_EVENTREGISTRANTPAYMENT_VALIDAMOUNT". The conflict occurred in database "XXXX", table "dbo.EVENTREGISTRANTPAYMENT", column 'AMOUNT'.
Follow the steps below to resolve: 
  1. Go to the event. You can see that designations tab is showing a conflict icon.
  2. Go to the Designations tab. Click Edit and then click Distribute Evenly.
  3. Save and you will see that the conflict icon is gone.

Steps to Duplicate

  1. Go to the main Events page and search for and open the event
  2. Select the Registrations tab and open the registration for the constituent
  3. Select Add payment, enter a payment amount, highlight the registration, select Add, OK, and edit the Receipt amount so it matches the payment amount
  4. Attempt to save the payment and receive the error 

Environment

 3.15

Was this article helpful?