web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Advance bank Reconcili...
Microsoft Dynamics AX (Archived)

Advance bank Reconciliation - MT940

(0) ShareShare
ReportReport
Posted on by Community Member

Dear experts,

I did the Advance bank reconciliation with all steps as technet website succecfuly (as I think)  but when I upload the Bank Statement txt format I got this inflog (0 bank statement is imported from C:\Users\axadmin\Desktop\B\SWIFT_MT940.txt.)

Please can anyone help

Thanks in Advance

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Abdullah,

    In addition to the information that you found here (community.dynamics.com/.../165525) you can also take a look at the following whitepaper that was posted by the German MS Support team a while ago for AX2012 systems.

    msdnshared.blob.core.windows.net/.../AX-2012-R2-Importing-account-statements-MT940.pdf The last document does not deal specifically with the advanced bank reconciliation feature but might give you some ideas what to look for and take care of.

    If this does not help, here some additional Information from the same source that deals with the advanced bank reconciliation Feature but for AX7 Systems. msdnshared.blob.core.windows.net/.../Microsoft-Dynamics-AX-Bank-statement-import-setup-for-MT9401.pdf

    Hope this information helps you fixing your issue. Would be great if you could keep us updated.

    Thanks,  

    Ludwig

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Abdullah, Have you worked through the different documents and been able to get the statement uploaded? Best regards, Ludwig

  • Community Member Profile Picture
    Community Member on at

    Dear Ludwig,

    Thanks for your quick respond,

    I followed all steps even i repeated in USMF Company with the same sample file and it's not working I Don't believe I missed something because I repeated it many times with no luck

    let's supposed that the Problem with my MT940 file ( because as I read it may different between countries) how can I make sure the one I have is suitable with AX 2012 R3

    I tried BAI2 with the same result.

    Please any advice

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Abdullah,

    If you are not sure about your MT940 file, you can download sample ones here:

    wiki.nuclos.de/.../7+MT940%3A+Beispiele

    There are a number of software tools available that can check MT940 files for Errors. One of those tools can be found here

    2014.windata.de/.../produktZVT.html

    Please note that you can make use of a free trial to get your files checked.

    (Note that both websites are in German language but using Google translate or something alike should certainly help).

    Hope this helps,

    Ludwig

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hello again Ludwig,

    I found the problem it was with the same template, some of the codes contains small letters. this small thing cost me two working days :/

    Thanks again for your support

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Great that you could fix your issue even though it cost you much time. Would you mind verifying your solution also for the other community members? Many thanks and have a great day ahead, Ludwig

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    I am really sorry for the late reply,

    I followed the AX standard steps and it work fine for me all the issues was with the same banks statement and it seems it different from country to country, my templates contains unnecessary information plus small letter codes.

    the below link explain the steps

    blogs.msdn.microsoft.com/.../advanced-bank-reconciliation-setup-in-ax-2012-r2

    Many Thanks  

  • Community Member Profile Picture
    Community Member on at

    Hi Abdullah,

    Could you please share the bank statement file and the details( like company and the bank account for which you imported , even we are getting the same error and are unable to proceed

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans