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