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

When adjusting a posted payment, the following error may occur:

Error:  The UPDATE statment conflicted with the CHECK consraint 'CK_REVENUESCHEDULE_NEXTTRANSACTIONDATEVALID'.  The conflict occurred in database 'database name', table 'dbo.REVENUESCHEDULE'.
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 2.91.1535
 2.91.1535, patch 84

Was this article helpful?