Error: Data could not be saved. The INSERT statement conflicted with the CHECK constraint "CK_RECURRINGGIFTAMENDMENT_DIRECTDEBITANDOTHER". The conflict occurred in database "xxx", table "dbo.RECURRINGGIFTAMENDMENT".- when adding a payment

When adding a membership for a Recurring membership program with a payment method of OTHER, you receive the following error:
 Error: Data could not be saved.  
The INSERT statement conflicted with the CHECK constraint "CK_RECURRINGGIFTAMENDMENT_DIRECTDEBITANDOTHER". The conflict occurred in database "XXXXX", table "dbo.RECURRINGGIFTAMENDMENT".
We are currently evaluating this issue and will inform you when we have an answer. Until then, removing the text in the reference line from the Add a Payment screen will allow you to sell the membership.

Steps to Duplicate

  1. Go to Memberships > add a membership
  2. Under Who is paying for this? Enter in constituent not a member of a membership program 
  3. Under What are they paying for? Make sure Add a membership is selected .Enter your membership program, level and term 
  4. Under How are they paying? Select Other as a payment method, then select your Other method User-added image
  5. Enter a reference number (any will do)
  6. Enter a reference date: Any date
  7. Reference: anything in this fieldUser-added image
  8. Enter any other relevant information and click Save.

Environment

 Altru Arts & Cultural

Was this article helpful?