Resolution: Check the "status" field in the payment transaction log. Reference https://knowledgecenter.zuora.com/CD_Reporting_And_Analytics/D_Data_Sources_and_Exports/C_Data_Sourc...
The unexpected result is "status":"new". The expected response is "status":"verified" from Stripe.
Here is one example payment transaction log.
CCTransactionResult:GeneralTransactionError
CreatedOn: 06/18/2019 16:39:51 PDT
GatewayType:Stripe
TransactionType: Authorization
TransactionId: ba_1Emqu2JEXVnuRPnzuml12345
TenantId: 12345
PaymentMethodTransactionLogId: 2c92c0f96b695c71016b6cf607f12345
PaymentMethodId:
ResponseCode: 200
ResponseMsg: The bank account must be in verified status
RequestString:
{Check if Zuora PaymentMethod is being updated or created.}, {Request = [email=&metadata[phone]=], url = [https://api.stripe.com/v1/customers]}, {Request = [source[object]=bank_account&source[bank_name]=abc&source[account_number]=############&source[country]=US&source[currency]=USD&source[account_holder_name]=John Abc&source[routing_number]=#########&source[account_holder_type]=individual&metadata[AchAddress1]=12345&metadata[AchAddress2]=], url = [https://api.stripe.com/v1/customers/##################/sources]}
ResponseString:
[], [body={ "id": "cus_FHPjAc5tH12345", "object": "customer", "account_balance": 0, "address": null, "balance": 0, "created": 1560912345, "currency": null, "default_source": null, "delinquent": false, "description": null, "discount": null, "email": null, "invoice_prefix": "8E112345", "invoice_settings": { "custom_fields": null, "default_payment_method": null, "footer": null }, "livemode": false, "metadata": { }, "name": null, "phone": null, "preferred_locales": [ ], "shipping": null, "sources": { "object": "list", "data": [ ], "has_more": false, "total_count": 0, "url": "/v1/customers/cus_FHPjAc5tH12345/sources" }, "subscriptions": { "object": "list", "data": [ ], "has_more": false, "total_count": 0, "url": "/v1/customers/cus_FHPjAc5tH12345/subscriptions" }, "tax_exempt": "none", "tax_ids": { "object": "list", "data": [ ], "has_more": false, "total_count": 0, "url": "/v1/customers/cus_FHPjAc5tH12345/tax_ids" }, "tax_info": null, "tax_info_verification": null } , auth_status_code=200, error_boolean=, error_message=, error_type=, ], [body={ "id": "ba_1Emqu2JEXVnuRPnzuml12345", "object": "bank_account", "account_holder_name": "John Abc", "account_holder_type": "individual", "bank_name": "Test", "country": "US", "currency": "usd", "customer": "cus_FHPjAc5tH12345", "fingerprint": "YCOyV9uB6qQ12345", "last4": "6789", "metadata": { "AchAddress1": "12345" }, "name": "John Abc", "routing_number": "110001234", "status": "new" } ,
status=new, object=bank_account, auth_status_code=200, error_boolean=, error_message=, error_type=, error_param=, ]
You can update the account status to verified status on Stripe gateway or reach out to Stripe payment gateway team for further assistance. After the status is updated on Stripe end, you should be able to add the ACH payment method on Zuora successfully.
