Error: The UPDATE statement conflicted with the CHECK constraint 'CK_REVENUESCHEDULE_NEXTTRANSACTIONDATEVALID'. The conflict occurred in database 'database name', table 'dbo.REVENUESCHEDULE'.

When a editing a posted pledge it's possible to change the designation splits.  Sometimes when editing a pledge, after changing the designations an error message is given regarding the revenue revenue schedule on the pledge record.
We're currently evaluating this issue for a fix in a future patch or service pack.  

Steps to Duplicate

1. Open the pledge
2. Click the Designation hyperlink
3. Highlight a row and delete
4. Click Distribute evenly which will place the entire amount in one designation
5. Click Yes to the message regarding paid installments
6. Click Yes to the message regarding recognition
7. Click Edit installment designations to verify that all installments are showing the proper designation
8. Fill out the adjustment fields
9. Save the pledge -- the error occurs


 Blackbaud CRM

Was this article helpful?