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 / 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?

(3) ShareShare
ReportReport
Posted on by NK-18111617-0 155

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
I have the same question (0)
  • Alexander Drogin Profile Picture
    Alexander Drogin 262 on at
    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.
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 20,448 Super User 2025 Season 2 on at
  • Suggested answer
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri 2,351 Super User 2025 Season 2 on at

    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
    YUN ZHU Profile Picture
    YUN ZHU 95,729 Super User 2025 Season 2 on at
    If the standard cannot be done, it requires some simple customization. Hopefully the information below can give you some hints.
     
    Thanks.
    ZHU

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans