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
Go to Memberships > add a membership
Under Who is paying for this? Enter in constituent not a member of a membership program
Under What are they paying for? Make sure Add a membership is selected .Enter your membership program, level and term
Under How are they paying? Select Other as a payment method, then select your Other method
Enter a reference number (any will do)
Enter a reference date: Any date
Reference: anything in this field
Enter any other relevant information and click Save.