Error : Cannot insert the value NULL into column DATE, table dbo.FinancialTransaction; column does not allow nulls. Update fails.

Users may encounter the error : "Cannot insert the value NULL into column DATE, table dbo.FinancialTransaction; column does not allow nulls. Update fails." when committing an imported Direct Debit batch.
This issue is caused by having an incorrect Revenue ID in the import file. Review the import file and ensure that the Revenue ID being used corresponds to an individual installment record and not the pledge or recurring gift record.

Environment

 Blackbaud CRM
 4.0
 4.0.173.0

Was this article helpful?