Error: Data could not be saved. Subquery returned more than one value. This is not permitted when the subquery follows =, !=, <, <=, >, >+ or when the subquery is used as an expression. - when entering a back office credit card payment

When adding a payment from Add a payment, users may encounter this error after entering credit card payment information and clicking Save. 
Users should check the constituent's contact record to see if two primary addresses or phone numbers are listed. 

If so, delete one of the primary addresses and phone numbers and reprocess payment. 

Steps to Duplicate

1. From Constituents, click Constituent search.
2. Search for constituent
3. Click Add payment
4. Enter amount 
5. Enter Application
6. Choose event
7. Click Add to add application
8. Choose payment method: Credit card.
9. Enter credit card information
10. Click Save - receive error.

Was this article helpful?