RELATIONSHIPSETID Null When Organization is created and parent organization is selected at the same time

When adding a new organization and selecting a parent organization in the Add an organization window while creating the new organization, the RELATIONSHIPSETID value is Null. This does not occur if the Organization is added without selecting a parent organization and the parent organization is added under relationships after the new organization is created.
Download and install the latest Service Pack which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.  

Steps to Duplicate

1. Go to constituents\Add an Organization
2. In the Add an organization window that opens, enter in the name and select a Parent org from the search box
3. Add any other needed information and click save
4. Run this statement on the database:
select * from relationship where RELATIONSHIPCONSTITUENTID = 'GUID number of new organization that was just added-not parent org'
6. Note that the RELATIONSHIPSETID column is Null.



 Blackbaud CRM
 4.0, Service Pack 12

Was this article helpful?