You’re offline. This is a read only version of the page.
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?
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;
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (