Views:

Applies to Product - Dynamics 365 Finance
 

What’s happening?
Errors are encountered during the setup of direct debit collections, specifically validation errors during the 'Format mapping' run, which prevents payment generation.
 

Reason:
The underlying cause appears to be a mismatch between the bank account for the mandate and the bank account in the journal.
 

Resolution:
1- Review and Correct the Mandate:

  1. Navigate to the mandates section in customer account (Accounts receivable> Customers> All customers> Select the customer> Direct debit mandates tab) and locate the Mandate ID.
  2. Verify that the mandate details are correct and that the mandate status is set to Active.
  3. Ensure that the bank account linked to the mandate matches the details in the payment journal.
  4. If the bank account linked to the mandate is incorrect, edit the mandate to reflect the correct bank account.
2- Check Customer Setup:
  1. Open the customer account and navigate to the payment defaults tab.
  2. Ensure that the Method of payment is set to Direct Debit.
3- Validate the Journal:
  1. Open the journal where the payment is being generated.
  2. Ensure that the journal's bank account matches the mandate bank account.
  3. If there is no bank account, assign the correct bank account.
4- Validate the Direct Debit Format:
  1. Verify that the electronic reporting configuration for the Direct Debit format and defined in the method of payment is imported and active in Electronic reporting workspace> Reporting configurations.
  2. Check the mapping for errors in the format and ensure all required fields are correctly mapped to the appropriate data.
5- Test the Setup:
  1. Use the validate format option in electronic reporting to identify and fix mapping errors.
  2. Clear any failed payment generation attempts to avoid conflicts.
  3. Generate payments by navigating to the payments section and using the correct method of payment and mandate ID.
  4. Confirm that the payment file is generated without errors.
 
For detailed steps, refer to the official documentation on setting up SEPA direct debit mandates, the overview of SEPA direct debit in Dynamics 365 and the ER Generate electronic documents for payments using a format configuration.