Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / bank statement import ...
Finance | Project Operations, Human Resources, ...
Suggested answer

bank statement import MT940 Format in D365 Finance and operations

(0) ShareShare
ReportReport
Posted on by D365FO DEV 388

Hello everyone, The MT940 Bank statements that we receive from the bank arrive with the account number like this :  :25:4052030478.  When we try to import this file we get an error "The bank statement was not imported because bank account ?? ?? ?? was not identified in the import file.".  If we manually change the .csv file so that the account number looks like this:  :25:/4052030478, it works fine. i already tried the data management method but its now removed by microsoft, i need a new way to be able to import bank statements without adding "/" manually. anyone can help?

  • D365FO DEV Profile Picture
    D365FO DEV 388 on at
    RE: bank statement import MT940 Format in D365 Finance and operations

    Hi, just fill the following fields: SWIFT Code, IBAN and Bank Account Number in cash and bank managements -> bank accounts.( choose ur bank)

  • CAroshan Profile Picture
    CAroshan 5 on at
    RE: bank statement import MT940 Format in D365 Finance and operations

    Hi Mounir, How did you edit the ER reporting. If you can guide, would be helpful. We are also facing this issue.

  • D365FO DEV Profile Picture
    D365FO DEV 388 on at
    RE: bank statement import MT940 Format in D365 Finance and operations

    thank you so much my issue is resolved!

  • D365FO DEV Profile Picture
    D365FO DEV 388 on at
    RE: bank statement import MT940 Format in D365 Finance and operations

    i got these errors after using this formula.(note that i am using development environment and there is only statementfile.sequence bcz i cannot edit on the UAT its saying 'cannot edit in read only editor. and the errors i got are:

    Incorrect reference 'format/StatementFile/FileContent'

    Function arguments are of incorrect types in 'REPLACE'

    Function arguments are of incorrect types in 'REPLACE'

    No overload for function SPLIT matches the input parameters

  • D365FO DEV Profile Picture
    D365FO DEV 388 on at
    RE: bank statement import MT940 Format in D365 Finance and operations

    can you please tell me step by step how i can done this, because im not a functional guy. like if u can tell me how i derive my ER format, how i find the model mapping, and how i change the formula in the model mapping in order to paste the formula u shared.

    waiting for ur reply,

    thanks

  • Suggested answer
    Arcadi Profile Picture
    Arcadi 782 on at
    RE: bank statement import MT940 Format in D365 Finance and operations

    Still can't see any problem with that format, but anyways if you want to add the slash, derive your ER format, and in the model mapping change the formula for format>statementfile>statement to 

    SPLIT(
    REPLACE(
        REPLACE(format.StatementFile.FileContent,":25:",":25:/",true)
        , "(\r\n|\r|\n):20:", "?:20:", true)
        , "?:20:")

  • D365FO DEV Profile Picture
    D365FO DEV 388 on at
    RE: bank statement import MT940 Format in D365 Finance and operations

    I'm using the latest ABR MT 940 formatt in the advanced bank and reconciliation in the ER. also i tried using the MT940 Format but it didnt work. so when i use ABR MT940 FORMAT, lets say the bank account number is :25:95929901221 if i try to import this statement, it gives an error saying 'The bank statement ???? was not imported because bank account ???? was not identified in the import file'. But if i add manually on the swift format a '/' so it will be like that :25:/95929901221, it will import successfully. i just need a way to be able to import statements without adding '/' manually on each record since i got alot of records. please i have been suffering with this issue i need your help.

  • Suggested answer
    Arcadi Profile Picture
    Arcadi 782 on at
    RE: bank statement import MT940 Format in D365 Finance and operations

    MounirDev Are you using the latest MT940 ER Format? It seems like ER expects :25:SWIFT/IBAN or :25:IBAN, so there shouldn't be any problem with what your bank is sending you. If you are not using ER try it with the "MT940 Format" from Microsoft repositories.

  • D365FO DEV Profile Picture
    D365FO DEV 388 on at
    RE: bank statement import MT940 Format in D365 Finance and operations

    i have found the class that is related to this batch regarding bank statement, its called ' bankstatementimportbatch', and there is a method called openresult() that after debugging is related to the bank account number. so can i create an extension on this class and add a condition to let the bankaccount number be imported from the swift MT940 format without adding the '/' manually? if yes please provide me with more informations.

    thanks,

  • D365FO DEV Profile Picture
    D365FO DEV 388 on at
    RE: bank statement import MT940 Format in D365 Finance and operations

    please if you know a senior functional consultant or any person that can help me in my case, let him know. I have been troobleshooting and searching for a solution since 4 days.

    thank you

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans