When attempting to merge two records an error regarding relationships and matching gifts is given and the records are not merged, users may receive the error:
Data could not be saved. The UPDATE statement conflicted with the CHECK constraint "CK_RELATIONSHIP_MATCHINGGIFTRELATIONSHIPCOUNT"
Ensure the organization relationships set to match gifts on the constituent records set to be merged are set with the correct relationship types. The individual should have a relationship type of 'Employee' and the organization have a relationship type of 'Employer'
Steps to Duplicate
1. Go to Constituents > Duplicates > Merge two constituents 2. In the Source constituent choose the constituent 3. For the Target constituent choose the constituent 4. Select the Default Merge configuration 5. Click Merge