web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Electronic Reporting c...
Finance | Project Operations, Human Resources, ...
Answered

Electronic Reporting configuration - D365FO

(1) ShareShare
ReportReport
Posted on by MP-14050322-0 4
Hi All, 
 
We have a requirement where we need to implement Electronic Reporting functionality configurations. We need to create EFT method of payments for UK legal entity where client is willing to generate the file in XML format to upload the payments in Bank portal.
 
Please let us know how we can setup this requirement in D365fo. 
 
Regards, 
Akbar
Categories:
Dynamics 365 Finance
I have the same question (0)
  • Anton Venter Profile Picture
    Anton Venter 20,345 Super User 2025 Season 2 on at
    Hi,
     
    There are out of the box ER configurations which could be used, and it's also possible to create configurations from scratch if necessary.
     
    There are many different document formats so can you be more specific about the requirements?
     
    Electronic reporting (ER) overview
     
  • Akbar Pasha Profile Picture
    Akbar Pasha 1,505 on at
    Thank you Anton for the links provided, we will go through these links. Thanks again for your help.
     
    Regards,
    Akbar
  • Akbar Pasha Profile Picture
    Akbar Pasha 1,505 on at
    Hi Anton,
     
    Could you kindly let us know if Microsoft supports faster payment methods for banks, specifically in the UK region? If so, please share any relevant links or documentation.

    Thank you in advance.

     
    Thank you in advance.
     
    Regards,
    Akbar
  • Suggested answer
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri 2,351 Super User 2025 Season 2 on at

    To implement Electronic Reporting (ER) for generating EFT payment files in XML format in Dynamics 365 Finance and Operations (D365FO),

    Step 1: Prerequisites

    1. Electronic Reporting Module Access:

      • Ensure you have the correct roles assigned to work with Electronic Reporting, such as the Electronic Reporting Developer role.

    2. Standard Configurations:

      • Download and use the standard configurations from Microsoft’s Global Repository for Electronic Reporting. This often includes templates for ISO20022 formats, which are commonly used for EFT payments in the UK.
      • Check if the required payment format (e.g., ISO20022 Credit Transfer) already exists in the repository.

    3. Legal Entity Setup:

      • Confirm that the Legal Entity (UK) is configured correctly, including currency, bank accounts, and other relevant details.

    Step 2: Create a Method of Payment

    1. Navigate to Cash and Bank Management > Payment Setup > Methods of Payment.
    2. Create a new method of payment:
      • Name: Give it a name (e.g., "EFT-UK").
      • Payment Type: Select Electronic Payment.
      • File Format: Leave this blank for now; the file format will be tied to the ER configuration.
    3. Assign the new method of payment to the appropriate vendor payment journal.

    Step 3: Configure Electronic Reporting Framework

    The Electronic Reporting (ER) framework will be used to create or customize the XML format for the EFT file.

    3.1 Access Electronic Reporting

    • Go to Workspaces > Electronic Reporting.

    3.2 Load or Import ER Configurations

    1. Check for Standard Configurations:

      • In the ER workspace, click Repositories.
      • Add Microsoft’s Global Repository if it isn’t already added.
      • Download the ISO20022 Credit Transfer configuration for vendor payments. This is often pre-configured for EFT files.

    2. Import Configurations:

      • Import the required configurations (e.g., Payment Model, ISO20022 Credit Transfer Format, etc.).
      • Validate that the format meets your client’s bank requirements. If not, you may need to customize it.

    Step 4: Customize the ER Format (If Required)

    If the standard configuration does not fully meet your client's requirements, you can customize it.

    4.1 Duplicate the Format

    1. In the Electronic Reporting workspace, select the imported format (e.g., ISO20022 Credit Transfer).
    2. Click Create Configuration > Add Derivative to create a new custom version.
    3. Provide a name for the new configuration and save it.

    4.2 Edit the Format

    1. Select your custom format and click Designer.
    2. Navigate through the Model Mapping and Format Components to customize fields, elements, and conditions as per the bank’s XML specification.
    3. Test your changes using sample data (you can generate sample XML files for verification).

    Step 5: Link ER Format to Method of Payment

    1. Go to Accounts Payable > Payment Setup > Payment Methods.
    2. Open the method of payment you created earlier (e.g., "EFT-UK").
    3. Under the File Formats tab:
      • Set the Export File Format to the custom ER configuration you created or the standard configuration if no customization is required.

    Step 6: Set Up Vendor Bank Accounts

    1. Navigate to Accounts Payable > Vendors > All Vendors.
    2. Select a vendor and go to Bank Accounts.
    3. Add the vendor’s bank account details, ensuring fields like IBAN, SWIFT, and account numbers are filled correctly.

    Step 7: Process and Generate EFT Files

    1. Create a payment journal:
      • Go to Accounts Payable > Payments > Payment Journal.
      • Create a new journal and select the method of payment (e.g., "EFT-UK").
      • Add vendor payment lines.
    2. Generate the payment:
      • Post the journal.
      • Click Generate Payments, select the method of payment, and set the Export File option.
      • The system will use the ER format configuration to generate the XML file.

    Step 8: Test and Validate

    1. Download the generated XML file and validate it against the bank’s schema using their test portal or tools.
    2. Adjust ER configurations as needed to meet specific bank requirements.

    Optional: Automate File Upload

    If your client’s bank supports APIs or automated uploads, you can integrate D365FO with the bank’s portal using Data Management Framework (DMF) or custom integrations. Otherwise, users can manually upload the XML files to the bank portal.

    Conclusion

    This process leverages standard Dynamics 365FO functionalities and the flexibility of the Electronic Reporting framework. The key steps are configuring the payment method, ensuring the correct ER format is used or customized, and generating XML files that align with the bank's specifications.

  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at
    Hi,
    You need to import actual configuration in regards to bank requirement from Dataverse repository (e.g. ISO20022 Credit Transfer , Pain001), Then you need to link this config to the EFT method of payment:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans