Error: All rows failed with error: Cannot insert the value NULL into column 'MEMBERSHIPAMOUNT', table 'xxxxx.dbo.BATCHMEMBERSHIPDUES'; column does not allow nulls. INSERT fails. when running credit card processing

SQL error is getting thrown for revenue records when running the generate payment process. Looking at the exception report after running the process see message, Error: All rows failed with error: Cannot insert the value NULL into column 'MEMBERSHIPAMOUNT', table 'xxxxx.dbo.BATCHMEMBERSHIPDUES'; column does not allow nulls. INSERT fails.
We are currently evaluating this issue for a fix in a future service pack.

Steps to Duplicate

1. Click Revenue tab
2. Click EFT
3. Click Generate payments
4. Select and run the process
5. See Error message in the exception report, Error: All rows failed with error: Cannot insert the value NULL into column 'MEMBERSHIPAMOUNT', table 'xxxxx.dbo.BATCHMEMBERSHIPDUES'; column does not allow nulls. INSERT fails.

Environment

 Blackbaud CRM
 4.0
 4.0.173

Was this article helpful?