Skip to main content
Post a question

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id : NOvVn7WG9KhLpnKbW4vD+f
Finance | Project Operations, Human Resources, ...
Suggested answer

Mapping of dates in bank statement format MT940 - difference between period date and booking date.

Like (0) ShareShare
ReportReport
Posted on 4 May 2023 08:45:39 by 85

Dear Experts.

When we're importing our MT940 statement from our banks, we now see (from multiple banks) that lines inside our statement in certain cases can have dates outside of the statement period. D365FO cannot validate these statements in standard (source: MS Technical Support Engineer).pastedimage1683189903694v3.png

pastedimage1683189866562v2.png

We are currently using the standard mapping from tag :61: "entry date (bookdate)" in the statement to enter the booking date and not the "value date". Anyone has experience in handling these statements? The only workaround at this point seems to be exporting the statement, changing the date in the MT940 file, and re-upload the statement.

We are receiving statement every day, why changing the period dates is not an option.

Looking forward to your input!

//

VBB

  • Suggested answer
    Hana Xue Profile Picture
    Microsoft Employee on 05 May 2023 at 03:23:33
    RE: Mapping of dates in bank statement format MT940 - difference between period date and booking date.

    Hi,

    In Advanced Bank Reconciliation, user can select the booking date as the posting date for new transactions or use the import date as the posting date for new transactions.

    Note that the following actions can help minimize potential date and time conflicts when you import bank statements.

    • Avoid changing the time zone preferences for any bank accounts that have already had statements imported. Changing the time zone preference could impact the ordering of new statements relative to existing statements due to the time zone adjustment.
    • Review all the imports that use the selected data source format. The time zone preference specified for the format will apply to all the import projects that use that format. Verify that the time zone preference is appropriate for all the import projects that use that format.

    More details are in the following link, hope it will be helpful.

    Set up the advanced bank reconciliation import process - Finance | Dynamics 365 | Microsoft Learn

    Best Regards,

    Hana

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans
Loading complete