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

Like (0) Share

Report

Posted on 4 May 2023 08:45:39 by VBB

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).

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

All responses (1)

Answers (0)

Suggested answer

Hana Xue Microsoft Employee on 05 May 2023 at 03:23:33

Like (0)

Report
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