Editing Prospect and Primary Manager Assignments Fails to Update and Creates "End Date" and "CHECK Constraint" Errors

"Prospect manager's end date must be on or after the end date of the previous prospect manager" error message appears when trying to enter an end date for the Prospect Manager and Primary Manager relationship even after using a Start Date when replacing a new prospect manager that falls after the End Date field of a previous manager.
 
We are currently evaluating this issue for a fix in a future service pack.

Steps to Duplicate

 
1. On the constituent record, got to Prospect tab> Prospect Team> Prospect manager> Edit prospect manager. Update the prospect manager by putting an end date on the current manager and Save.
2. Click Replace prospect manager. Search and enter a new manager with Start date that falls after end date of the old Prospect manager.
3. Receive error message "Prospect manager's end date must be on or after the end date of the previous prospect manager".
4. Go to Manager History tab, delete any history of former prospect managers if there is a manager listed in the history. 
5. Repeat steps #2 & #3, the error message displaying "Prospect manager's end date must be on or after the end date of the previous prospect manager" still appears when trying to edit the start and end dates for primary and prospect managers
 
 

Environment

 Blackbaud CRM
 4.0
 4.0.170

Was this article helpful?