Skip to main content
Post a question

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id : NiLgJAtfvyN1egdvVJeJkZ
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / SEPA CAMT XML File Not...
Small and medium business | Business Central, N...
Suggested answer

SEPA CAMT XML File Not Containing Field ID Numbers?

Like (3) ShareShare
ReportReport
Posted on 31 Jan 2025 17:19:07 by NK-18111617-0 14

So I have a service to import bank transactions now, but it only goes back a few months. I need to import a bank account and couple credit cards into reconcile my accounts before going to my accountant for taxes. I've found the SEPA CAMT data exchange definition and export the .XML mapping file. Then looked at the field mapping under the SEPA CAMT data exchange definition. However, I'm lost at this point because I only find a couple of the field numbers when loading the XML file. What am I missing?

Not finding....

Field ID 5 (Posting Date)

Field ID 1221 (Payer Information)

Field ID 1222 (Transaction Information)

r/Dynamics365 - SEPA CAMT XML File Not Containing Field ID Numbers?
r/Dynamics365 - SEPA CAMT XML File Not Containing Field ID Numbers?
Categories:
Dynamics 365 Business Central
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,874 Super User 2025 Season 1 on 03 Feb 2025 at 00:37:57
    SEPA CAMT XML File Not Containing Field ID Numbers?
    If the standard cannot be done, it requires some simple customization. Hopefully the information below can give you some hints.
     
    Thanks.
    ZHU
  • Suggested answer
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri 726 Super User 2025 Season 1 on 01 Feb 2025 at 10:29:48
    SEPA CAMT XML File Not Containing Field ID Numbers?

    AI was used to create this answer
    Possible Reasons & Solutions:

    1. XML Structure Differences

      • The CAMT XML format contains hierarchical data, meaning some elements may be nested inside others.
      • Open your exported XML file in a text editor and search for the expected data fields (<PstngDt>, <Dbtr>, <RmtInf>, etc.).
      • Ensure that these elements are present in the file and properly structured.

    2. Incorrect XPath Mapping in Data Exchange Definition

      • Microsoft Dynamics uses XPath expressions to extract data from XML files.
      • Go to Data Exchange Definitions → Field Mapping and check if the correct XPath is assigned to these fields.
      • If necessary, manually adjust the XPath to match the structure of your XML file.

    3. Data Exchange Definition Schema Mismatch

      • If your bank provides a CAMT.053 or CAMT.054 file that differs from the default schema in Dynamics, some fields might not be mapped automatically.
      • Try re-importing the CAMT XML using a different CAMT schema version (e.g., 052, 053, 054) to see if fields appear.

    4. Field Data is Missing in the XML Preview

      • The preview only displays the first node from each schema element, meaning some transactions may not appear.
      • Import the XML fully into a temporary table and verify if the missing data is actually there.

    5. Data Type and Namespace Issues

      • Ensure that the field type in Dynamics matches the expected format in the XML file (e.g., Date, String).
      • If the XML uses namespaces, the XPath may need to include them.

    6. Enable Debugging to Check XML Parsing

      • Use event logs or enable debugging in the Data Exchange Definition to track errors during import.
      • If the import fails at a certain field, that could indicate why it's missing.

    Next Steps:

    • Open the XML file and verify the expected data exists.
    • Adjust the XPath mappings to match the correct structure.
    • Try different CAMT schema versions to see if that resolves the issue.
    • Test importing with logging enabled to capture missing data points.
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 8,777 Super User 2025 Season 1 on 01 Feb 2025 at 05:31:59
    SEPA CAMT XML File Not Containing Field ID Numbers?
  • Alexander Drogin Profile Picture
    Alexander Drogin 256 on 01 Feb 2025 at 00:27:53
    SEPA CAMT XML File Not Containing Field ID Numbers?
    Do you mean you can't find these fields in the mapping list or in the imported table after mapping?
    This screenshot is the XML map with data preview, it shows only the first node from each schema element and not supposed to show all data from the XML file.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans