Import SEPA Bank Statement file with multiple Stmt

andrewt
Member Posts: 73
Hi all,
I am currently facing an issue regarding the import of bank statements based on the SEPA format camt.053.
The customer in charge recieves multiple bank statements from its eBanking portal all combinded in just one xml file. Thus, the file received contains multiple Stmt elements.
The SEPA CAMT setup and configuration has been applied from the DE demo company CRONUS AG. Through the processing codeunits, there's a check routine within CU 1262 which throws an error if the statement file contains mutiple statements:
The import with files containing only one single Stmt element just works fine as expected.
Has anyone out there already experienced similar issues with importing multiple bank statements combined in one file ? I would be interested in how this had been resolved. For instance, could we force the bank to provide individual bank statement files - or do we have to adjust NAV's processing CUs ?
Many thanks in advance
Andrew T.
I am currently facing an issue regarding the import of bank statements based on the SEPA format camt.053.
The customer in charge recieves multiple bank statements from its eBanking portal all combinded in just one xml file. Thus, the file received contains multiple Stmt elements.
The SEPA CAMT setup and configuration has been applied from the DE demo company CRONUS AG. Through the processing codeunits, there's a check routine within CU 1262 which throws an error if the statement file contains mutiple statements:
[b]CheckMultipleStatements(PostingExch : Record "Posting Exch.";StatementIdPathFilter : Text)[/b] IF HasPostExchFieldValue(PostExchFieldDetails,PostingExch."Entry No.",StatementIdPathFilter) THEN BEGIN StmtCount := 1; WHILE PostExchFieldDetails.READ DO StmtCount += 1; END; IF StmtCount > 1 THEN ERROR(MultipleStmtErr);
The import with files containing only one single Stmt element just works fine as expected.
Has anyone out there already experienced similar issues with importing multiple bank statements combined in one file ? I would be interested in how this had been resolved. For instance, could we force the bank to provide individual bank statement files - or do we have to adjust NAV's processing CUs ?
Many thanks in advance
Andrew T.
0
Comments
-
Hi andrewt,
How did you solve this issue, or did you solve it? We're having the same situation.0 -
Fortunately the customer's main bank responsible for their eBanking portal was able to provide individual statement files per bank account which the customer then imports separately into NAV. This way at least we were able to rely on the NAV standard process and didn't had to change it.
Cheers
Andrew0 -
Hi everyone,
I am facing the same problem.
Does anyone have a solution for this, rather than asking the bank to change the files?
Thanks in advance0 -
Same issue here, for dutch localization.... Anyone has a clue??0
-
We have the same issue for BE localization. Has someone solved it without forcing the bank to deliver individual statements ?0
-
I'm splitting the xml file in multiple xml files and import them one by one.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions