Error: Cannot insert the value NULL into column 'CREDITCARDPARTIALNUMBER', table 'dbo.RECURRINGGIFTAMENDMENT' - when using batch to update the payment method of a recurring gift

I'm trying to update the payment method of a recurring gift and I'm getting Error:  Cannot insert the value NULL into column 'CREDITCARDPARTIALNUMBER', table 'dbo.RECURRINGGIFTAMENDMENT'; column does not allow nulls. 

When selecting Credit Card as the payment method a full credit card number must be entered.  This info is then sent to BBPS.  

If you will not be entering a credit card number or entering a partial number select credit card - last 4 digits as the payment method.

Steps to Duplicate

1.  Select Constituent search from the Constituents functional area
2.  Search for and select a constituent
3.  Select Add a recurring gift from the tasks menu
4.  Amount = 100
5.  Designation = Library books
6.  Payment method = none
7.  Click save
9.  Select Batch entry from the Revenue functional area
10.  Click add
11.  Batch template = revenue update batch
12.  Projected # = 1
13.  Project amount = 100
14.  Click save
15.  Search for and select the recurring gift that was added
16.  Payment method = credit card
17.  Validate



 

Environment

 Blackbaud CRM
 4.0

Was this article helpful?