Here's the work around we've had to do which is horrible, but works: Create a job (Java, Apex, whatever language etc.) to do the following: Query Go Cardless API "events" endpoint looking for type = "transferred". This will return a list of Go Cardless Mandate IDs Query Go Cardless API "mandates" endpoint looking for the related bank account IDs to the list of those mandate IDs (you may just want to query the full list of mandates for efficiency) Query Go Cardless API "customer_bank_accounts" endpoint looking for Go Cardless's representation of the bank account number and sort code Query Zuora using Export ZOQL on SELECT Id, TokenId FROM PaymentMethod WHERE BankTransferAccountType = "DirectDebitUK" - this will return all payment methods from Zuora. The "TokenId" on the PaymentMethod object is actually Go Cardless's Id for the Mandate, that's the link. You can only get it through Export ZOQL, because Zuora don't surface the TokenId on the PaymentMethod in their API (Zuora, please can you provide this to save our devs having to do export ZOQL?) Either create a custom field on the PaymentMethod in SFDC or create your own DD object in SFDC (we use our own), and create a field called "GoCardlessBankAccountNumber" (also do one for the sort code), then use SFDC Bulk API to update those values from all that hard work you've just done. We're literally had to develop this work around, it's horrible, and time consuming. Update: this solution would work except that the Go Cardless API does not return sort codes, only the last 2 digits of the bank account. So therefore we can't even have a work around that's accurate.
... View more
Thanks for the input on this frustrating use case. We are planning to add support for credit memos and some enhancements to payment operations to the product within the next few months. We expect these enhancements to address more effectively use cases that we currently handle by adjusting invoices and invoice items today. As such, we are unlikely to invest in further enhancements to other invoice adjustment mechanisms.
Stay tuned for more info on these new capabilities.
... View more