Error: Cannot insert the value NULL into Column MATCHFACTOR, table dbo.REVENUERECOGNITONDEFAULT, Column doesnot allow nulls. Update fails.

The following error is encountered when committing or validating a Constituent Update Batch:

Error:  Cannot insert the value NULL into Column MATCHFACTOR, table dbo.REVENUERECOGNITONDEFAULT, Column doesnot allow nulls. Update fails.
We are currently evaluating this issue and will update this article when we have more information.

This error can occur if a batch template has business related field present, with the exception of Recognition credit match percent and Recognition Credit type fields.  In order to workaround this error message, add these additional fields to the batch template in question.

Environment

 3.0.512

Was this article helpful?