If you see the following error message on the Transaction detail view in the administrator for a subsequent recurring donation or during the manual Create Lead process in the Transactions view, it is likely caused by one or more Salesforce Opportunity records with the same Subscription Id missing a value for the Recurring Donation record in the Salesforce Nonprofit Success Pack:
Salesforce Error: sbxd.sbx_DonationsRecurringPaymentLead: execution of AfterInsert caused by: System.QueryException: invalid ID field: null (sbxd)
To resolve this issue, find all Closed Won Opportunity records with a Subscription Id value that matches the subsequent recurring donation with the error. Review each and ensure all of them have a Recurring Donation record associated with it. If not, add the proper Recurring Donation value to the Opportunity or Opportunities missing it.
Once the data is updated in Salesforce, you can use the Create Lead button in the Transactions view for the affected subsequent recurring donation records to push them to Salesforce.
When does this issue commonly occur?
If you see that a given recurring donation in Soapbox that was successfully creating and converting subsequent recurring Lead records in Salesforce suddenly stop in a given month, it is likely because an Opportunity record was manually added to Salesforce with the same Subscription Id but wasn't associated with the proper Recurring Donation record. This likely would have been added between the last successful subsequent recurring Lead and the first failed subsequent recurring Lead.