MT940 - Import using DMF data entity possible?

(0) Share

Report

Posted on by Jags0101

Hi Experts,

Please suggest, share your experience for this task.

The Bank statement import using format MT940 set up as per Microsoft document (msdnshared.blob.core.windows.net/.../Microsoft-Dynamics-AX-Bank-statement-import-setup-for-MT9401.pdf )

This allows users to upload bank statements successfully.

Is it possible to upload MT940 bank statements directly using DMF project created by above setup? using Recurring integration api?

Look forward to your inputs.

Thanks in advance.

I have the same question (0)

All responses (10)

Answers (2)

Suggested answer

André Arnaud de Cal... 301,148 Super User 2025 Season 2 on at

Like (0)

Report

Hi Jags0101,

I haven't done this with MT940 files, but I think it should work with the recurring integrations as described in the documentation: docs.microsoft.com/.../recurring-integrations

Was this reply helpful? Yes No
Suggested answer

vinitgoyal2005 6,332 on at

Like (1)

Report

Hi,

Have a look at my blog post d365foe.blogspot.com/.../how-to-import-bank-statements-from.html about importing bank statements using Power automate and Recurring integration.

Was this reply helpful? Yes No
Jags0101 5 on at

Like (0)

Report

Thanks Andre.

The DMF Project created has XML as datasource but the MT940 file is not an XML file (its .txt). It may not be possible to load MT940 file using DMF project.

Was this reply helpful? Yes No
Jags0101 5 on at

Like (0)

Report

Thanks Vinit,

The DMF Project created has XML as datasource but the MT940 file is not an XML file (its .txt). It may not be possible to load MT940 file using DMF project.

In your Blog, the bank statements were .csv files, right? Was this matching to Project BankStmt? Composite data entity will need xml datasource? I may be missing something, please let me know.

Was this reply helpful? Yes No
Verified answer

vinitgoyal2005 6,332 on at

Like (1)

Report

Hi,

It is absolutely possible to import it using DMF project. Have you looked at the link I shared? Have you already configured all the setup required for importing the statement manually? Can you manually import the file? If YES then you can then follow the steps as mentioned above and you should be able to import it using Recurring data job.

Data project created will be for XML and the input file will be txt. As a part of statement import configuration, you would add XSLT transformation files. Those same files would be used for transformation from TXT to XML in data project.

Was this reply helpful? Yes No
Verified answer

vinitgoyal2005 6,332 on at

Like (1)

Report

Data project will look something like below:

and when you go to View map -> Transformation tab it will have XSLT transformations

Was this reply helpful? Yes No
Jags0101 5 on at

Like (0)

Report

Thanks Vinit,

Yes, with setup, am able to manually import the file (has .txt extension).

I will try with "<Batch><![CDATA[" before the file content and "]]></Batch>", in the HTTP Post.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hello Jags0101,

You can import MT940 sta files into GL journals automatically.

Here are some hints how this can be achieved: dynamicsax-fico.com/.../

Note:

The process how payments are handled and settled is, however, different from what you can find in the bank module. Yet, maybe that's an alternative for you.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Jags0101 5 on at

Like (0)

Report

Hi Vinit,
[quote user="Vinit Goyal"]
Data project will look something like below:

and when you go to View map -> Transformation tab it will have XSLT transformations

[/quote]

Thanks for your Blog and additional inputs here. Much appreciated.

It is possible to import MT940 (.txt) file using DMF Project created during Bank statement import setup.

Got it working by using: "<Batch><![CDATA[" before the file content and "]]></Batch>", in the HTTP Post, when calling Recurring api.

Was this reply helpful? Yes No
Jags0101 5 on at

Like (0)

Report

Sure, I will go through these details.

Thanks Ludwig.
[quote user="Ludwig Reinhard"]
Hello Jags0101,

You can import MT940 sta files into GL journals automatically.

Here are some hints how this can be achieved: dynamicsax-fico.com/.../

Note:

The process how payments are handled and settled is, however, different from what you can find in the bank module. Yet, maybe that's an alternative for you.

Best regards,

Ludwig
[/quote]

Was this reply helpful? Yes No