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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.