Editing Relationship CRM Error: Cannot insert the value NULL into column 'SOURCECONSTITUENDID', table 'Alethia.dbo.REVENUERECOGNITIONDEFAULT'; column does not allow nulls. INSERT fails

This CRM error may occur when editing a foundations relationship. 
We are currently evaluating this issue for a fix in a future service pack 

Steps to Duplicate

1. Within CRM go to a Foundation relationship from Match gift ind. to Former Match gift ind
2. That will take you to the proper constituent and you can edit the organization to  change the relationship
3. Then you’ll get the following error Cannot insert the value NULL into column 'SOURCECONSTITUENDID', table 'Alethia.dbo.REVENUERECOGNITIONDEFAULT'; column does not allow nulls.  INSERT fails

Environment

 Blackbaud CRM
 4.0
 4.0.170.0

Was this article helpful?