Dynamics Community Forum Thread Details

I am working on MT940 bank statement import in Microsoft Dynamics 365 Finance & Operations using Electronic Reporting (ER) for Advanced Bank Reconciliation.

I am facing an issue where a single MT940 file contains multiple statement sequence blocks like below:

{1:F01########XXXXXX}{2:I940###########}{3:{108:############}}{4:
:20:######
:25:############
:28C:145/1
:60F:D######INR########,##

:61:######D#####,##NTRF####################
:86:CITY NAME
INF/NEFT/################/###########/REFERENCE########

:61:######D#####,##NTRF####################
:86:CITY NAME
INF/NEFT/################/###########/REFERENCE########

:62M:D######INR########,##
-}$


{1:F01########XXXXXX}{2:I940###########}{3:{108:############}}{4:
:20:######
:25:############
:28C:145/2
:60M:D######INR########,##

:61:######D#####,##NTRF####################
:86:CITY NAME
INF/NEFT/################/###########/REFERENCE########

:61:######D#####,##NTRF####################
:86:CITY NAME
INF/NEFT/################/###########/REFERENCE########

:62M:D######INR########,##
-}$


{1:F01########XXXXXX}{2:I940###########}{3:{108:############}}{4:
:20:######
:25:############
:28C:145/3
:60M:D######INR########,##

:61:######D#####,##NTRF####################
:86:CITY NAME
INF/NEFT/################/###########/REFERENCE########

:61:######D#####,##NTRF####################
:86:CITY NAME
INF/NEFT/################/###########/REFERENCE########

:62M:D######INR########,##
-}$

The bank splits one logical statement into multiple sequence parts (145/1, 145/2, 145/3) due to transaction volume.

Currently, D365 F&O ER is treating each :28C: block as a separate bank statement, which results in:

multiple opening balances
multiple closing balances
multiple statements being created during import

However, my requirement is:

✅ All :61: and :86: transaction entries should be imported as separate transaction lines in the bank statement.

BUT

✅ The complete MT940 file should be treated as ONE single bank statement only.

Expected behavior:

Take ONLY the first :60F: as the Opening Balance
Ignore intermediate :60M: balances
Take ONLY the final :62M: / :62F: as the Closing Balance
Import ALL :61: transaction lines separately
Map corresponding :86: narration for each transaction line
Do NOT create separate bank statements for 145/1, 145/2, 145/3
Treat 145/1, 145/2, 145/3 only as continuation sequence parts of the same statement

Expected result example:

Requirement	Expected Result
Opening balance	First `:60F:` only
Closing balance	Last `:62M:` / `:62F:` only
`:61:` lines	Separate transaction lines
`:86:` lines	Linked to related transaction
`145/1`, `145/2`, `145/3`	One consolidated statement

I would like guidance on:

Has anyone handled MT940 continuation sequence statements in D365 F&O ER?
What is the recommended ER model mapping/design approach for this scenario?
How can we consolidate multiple :28C: sequence blocks into one bank statement while still importing all transaction lines separately?
Is there any Microsoft best practice or standard ER approach for this?
Has anyone implemented a custom ER model mapping/format for this scenario?

Any help, sample logic, or implementation guidance would be greatly appreciated.

I'm also attaching a SS that how i get the values

I want single statement ID and in that all transactions lines,
Please guide me, if anyone have solution on this..