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... / Importing Bank account...
Small and medium business | Business Central, N...
Answered

Importing Bank account statements

(0) ShareShare
ReportReport
Posted on by ENKO-Felix 20

Hello everyone,

Unfortunately, importing bank account statements of German banks (Sparkasse) does not seem to work in BC365.
Currently we encounter a problem when we want to import a bank account statement into BC365. The error message "The bank account number was not found in the data to be imported." appears.

The statement is received in SEPA CAMT .xml format from a local bank in Germany (Sparkasse).
The bank details (Bank Account No, IBAN etc.) are correctly entered in Business Central.

Has anyone

Has anyone already had experience with this or a similar problem and knows how to solve this?
What is the most common way to perform such imports?

I have the same question (0)
  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 414 on at

    Hi,

    First of all check that is Bank Account of customer is linked to SEPA CAMT for import.

    Then check Import/Export Bank Data setup that which Data Exchange Definition is linked to SEPA CAMT for importing.

    Go to that Data Exchange Definition and verify that the file that you get from bank is correct or not.

    Regards,

    Bilal Haider

  • Verified answer
    Dirk Profile Picture
    Dirk on at

    Hello

    I suggest you ask your partner to raise a service request with Microsoft / if you are a partner please raise the service request directly.

    Thanks

  • ENKO-Felix Profile Picture
    ENKO-Felix 20 on at

    Apparently the problem lies within BC and the CodeUnit 1261 itself.

    With the help of Mr. Reeps we were able to modify the CodeUnit 1261 so that we could run a import of camt52 data successfully.

    Modification of the following Constants in CodeUnit 1261:

    StatementIDTxt: Label '/Document/BkToCstmrStmt/Stmt/Id', Locked = true;

    IBANTxt: Label '/Document/BkToCstmrAcctRpt/Rpt/Acct/Id/IBAN', Locked = true;

    BankIDTxt: Label '/Document/BkToCstmrStmt/Stmt/Acct/Id/Othr/Id', Locked = true;

    CurrencyTxt: Label '/Document/BkToCstmrStmt/Stmt/Bal/Amt', Locked = true;

    BalTypeTxt: Label '/Document/BkToCstmrAcctRpt/Rpt/Bal/Tp/CdOrPrtry/Cd', Locked = true;

    ClosingBalTxt: Label '/Document/BkToCstmrAcctRpt/Rpt/Bal/Amt', Locked = true;

    StatementDateTxt: Label '/Document/BkToCstmrAcctRpt/Rpt/CreDtTm', Locked = true;

    CrdDbtIndTxt: Label '/Document/BkToCstmrStmt/BkToCstmrAcctRpt/Rpt/CdtDbtInd', Locked = true;

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,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans