Default report config not available for selection in Adv Bank Recon

(5) Share

Report

Posted on by CU12050152-0

225

I have sent up Lloyds MT940 format as default for model mapping in electronic reporting . The issue is that the Llyods MT940 format is not available for selection in recocillation section. I have set up the bank statement format and linked the format of Lloyds MT940 format which is imported in electronic reporting. Am i missing any set up due to which i could not select Lloyds MT940 format in Bank master

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

A.Prasanna 8,223 on at

Like (0)

Report

Double-check your configuration setups with the steps below; however, I can't remember whether there was a format called "Lloyds MT940 ", the default MT940 format should work for most cases

Configuring MT940 Bank Reconciliation in D365FO Using Electronic Reporting

Was this reply helpful? Yes No
Suggested answer

Abhilash Warrier 5,402 Super User 2025 Season 2 on at

Like (1)

Report
Hi SP,

Please find attached document for help. Additionally, please review the below comments -

Here’s a checklist to help you resolve it:
Key Setup Steps to Make MT940 Format Selectable in Bank Master

Verify Statement Format Setup

Go to Cash and Bank Management > Setup > Advanced bank reconciliation setup > Bank statement format

Ensure:

Statement format = MT940 (or Lloyds MT940 if custom-named)

Generic electronic import format = Checked

Import format configuration = Your imported ER format (Lloyds MT940)

Check ER Configuration Mapping

In Electronic Reporting workspace, confirm:

You’ve imported Advanced bank reconciliation model

You’ve mapped the Lloyds MT940 format to that model

The format is marked as Default for model mapping

Enable Advanced Bank Reconciliation on Bank Account

Go to Cash and Bank Management > Bank accounts

Select your bank account

Under Reconciliation tab:

Set Advanced bank reconciliation = Yes

Choose Statement format = MT940 (or Lloyds MT940)

If the format doesn’t appear in the dropdown, it’s likely due to a mismatch between the ER format name and the statement format name in setup. Try renaming the statement format to match exactly what’s defined in ER.

If this helped, please mark it as "Verified" for others facing the same issue.
Keep in mind that it is possible to mark more than one answer as verified.

Bank Reconciliati...

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (1)

Report

Hi,
You need to add this configuration on "Bank statement format" and then add this format to the bank account.

Was this reply helpful? Yes No