ER MT940 Bank statement import - Credit/Debit dilemma

(0) Share

Report

Posted on by Pedro-Rodriguez

270

Hi,

I am testing Advanced Bank Reconciliation for a customer and after seeing strange things with Debit/Credit I have seem that before with XSLT was possible to define if the credits/debits in the bank statement are imported as debit/credit.

It is possible to do that in ER?

Thanks

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

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

Like (0)

Report

Hi Pedro,

Have you tried ABR MT940 format version 2.8?

Was this reply helpful? Yes No
Pedro-Rodriguez 270 on at

Like (0)

Report

I still have the same result. I have found a new feature:

"Reverse debit, credit when importing bank statements" added recently (21.09.2022)

But it has no description if I need to activate an option in parameters somewhere or if this will be just automatic. I activated the feature but I do not experience difference or I see new parameters.

There are also some new versions for the ER mappings to destinations but I cannot import them in the current application. They may have something in relation with the mentioned feature.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Some ER config needs a specific version of D365FO (i.e. Product update). for example prerequisite for ABR MT940 format is

Was this reply helpful? Yes No
Pedro-Rodriguez 270 on at

Like (0)

Report

Where can I see those prerequisites?

Was this reply helpful? Yes No
Suggested answer

Pedro-Rodriguez 270 on at

Like (0)

Report

The new feature works. After activating the feature there is a new field "Reverse debit credit mark" at the bank accounts.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi Pedro,

Once it has been imported, on ER form under prerequisite tab you can find it,

Before the import, you can search the ID number on LCS to find the release version for this config.

Was this reply helpful? Yes No
Pedro-Rodriguez 270 on at

Like (0)

Report

Thanks. What is the difference between ABR MT940 and the other MT940 format?

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

ABR MT940 is created with focus on advanced bank reconciliation statement.

Was this reply helpful? Yes No