Finance | Project Operations, Human Resources, ...

MT940 Bank statement format setup issue(Unable to pull data from transaction description associated with the format code :86 )

(0) Share

Report

Posted on by Benjamin long

Hi Everyone,

In D365 F&O i have setup advance bank reconciliation using ER, i am able to import bank statement but the transaction description tag 86 is empty, it is not pulling data from MT940 file. Below is the file format. Thank you

{1:AAAAAAAAAAAA}{2:BBBBBBBBBBBBBBBBB}{4:
:20:############
:25:#############
:28C:#####
:60F:#############
:61:###################
:86:CHEQUE DEPOSIT
:62F:##############
-}

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

BillurSamdancioglu 19,698 Most Valuable Professional on at

Like (0)

Report

RE: MT940 Bank statement format setup issue(Unable to pull data from transaction description associated with the format code :86 )

Hi,

Have you checked the mapping in ER or in Data Management for line 86?

Was this reply helpful? Yes No
Benjamin long 40 on at

Like (0)

Report

RE: MT940 Bank statement format setup issue(Unable to pull data from transaction description associated with the format code :86 )

Hi Billur Samdancioglu,

Thank you so much for your prompt response. I am using a standard ER mapping from Microsoft. i can see that the mapping is done but not sure why it is not pulling the data.

I have tired using data management but not able to configure the Bank statement format as the import format configuration is not available.

Was this reply helpful? Yes No
Suggested answer

Arcadi 794 on at

Like (1)

Report

RE: MT940 Bank statement format setup issue(Unable to pull data from transaction description associated with the format code :86 )

@Benjamin long, the line you are underlying is being used by "AdditionalInfo", the first son of BnkStmtLine. And "AdditionalInfo" is mapped with the model, but only the part after "?00".

It seems, if I'm reading right the formulas, that you'll only get "AAAAA" if the line looks like this:

:86:TEXTTEXTTEXT?00AAAAA?BBBB

It may also help you going to the previous form and using the "Run" button, you'll see everything the model is getting and will help you test and debug:

Was this reply helpful? Yes No
Benjamin long 40 on at

Like (0)

Report

RE: MT940 Bank statement format setup issue(Unable to pull data from transaction description associated with the format code :86 )

Hi Arcadi Burria ,

Thank you so much for your reply, I am able to see the description now. But because the bank statement is coming in from the bank and the format is fixed. How should I write in the formula to read the text within "?" for example "86:176?CHEQUE DEPOSIT?" in the mapping format in ER mapping designer? I am new to d365fo and not sure how to go about this. Thank you so much.

Was this reply helpful? Yes No
Suggested answer

Arcadi 794 on at

Like (1)

Report

RE: MT940 Bank statement format setup issue(Unable to pull data from transaction description associated with the format code :86 )

So you could do a similar formula that the one is used right nor, or something like this:

IF(COUNT(SPLIT(@.LINE86,"?"))>1,

INDEX(SPLIT(@.LINE86,"?"),2).Value,

"")

So you are splitting all "?", you are selecting the second split and you put everything inside an if, because the INDEX formula returns an error if the index doesn't exist.

Was this reply helpful? Yes No
Benjamin long 40 on at

Like (0)

Report

RE: MT940 Bank statement format setup issue(Unable to pull data from transaction description associated with the format code :86 )

Hi Arcadi Burria,

Thank you for the solution and detailed explanation. I received a new requirement, i have to concatenate 1,2 and 3 its seems very complicated.

:86:456?201234?21Example Description?2212345?23Other description

so in system will be like so

subtags are: 22 23|21|20

12345 Other description|Example Description|1234

and may i know where i can learn this formula from? Thank you so much

Was this reply helpful? Yes No
Arcadi 794 on at

Like (1)

Report

RE: MT940 Bank statement format setup issue(Unable to pull data from transaction description associated with the format code :86 )

Hi Benjamin,

It would be better if you open a new thread. your question about parsing data with ER is generic, so people who don't know about MT940 can also help you or learn. Just make sure to be specific about the string/strings you get and the desired output in all cases.

Was this reply helpful? Yes No
Benjamin long 40 on at

Like (0)

Report

RE: MT940 Bank statement format setup issue(Unable to pull data from transaction description associated with the format code :86 )

Hi Acradi Burria,

Thank you for the response, i have created the a new thread link:

community.dynamics.com/.../mt940-bank-statement-format-setup-line86-formula-for-pulling-additional-information

Thank you so much.

Was this reply helpful? Yes No