Skip to main content

Notifications

Announcements

No record found.

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

Advanced bank reconciliation: Change posting date of "mark as new" transaction?

(0) ShareShare
ReportReport
Posted on by Paul Ceely 45

We are trying to use Advanced bank reconciliation with individual bank statements per day per bank account.  These statements are downloaded from the bank (MT940 format) every business day morning, for the previous day's activity (or, on Mondays, three files are downloaded for Friday's, Saturday's, and Sunday's activity).  When there is a bank-initiated fee included in a statement, we wish to "mark as new" and post.  However, the date that D365 is using is the date the statement is validated, so the posting date is 1 to 3 days late compared to the actual date of the transaction.  Not a big deal until we get to month-end when we need the posting date of the bank fee to show in the correct period…  Is there any way to change the posting date of a "mark as new" transaction?

  • 72camaross Profile Picture
    72camaross 202 on at
    Advanced bank reconciliation: Change posting date of "mark as new" transaction?
    Hey, we had a similar issue. We recommended creating the bank-initiated transaction in a general journal and running the reconciliation again. Then the dates line up and the advanced bank rec should catch it.
    Hope that helps!
  • Paul Ceely Profile Picture
    Paul Ceely 45 on at
    RE: Advanced bank reconciliation: Change posting date of "mark as new" transaction?

    By way of response, Microsoft pointed me at an existing quality report: https://fix.lcs.dynamics.com/Issue/Details?bugId=516502&dbType=3&qc=6715f61082ea7a41605689ebe391acaab26ac920503454e3a6fc2c3f48c9d265

    To summarize this report, Microsoft is stating that the process is "currently working by design" and that the inability to change the posting date "is a design limitation."  On a somewhat positive note, Microsoft does "understand this is a gap and [they] will address in a future release."  However, I am not aware of it having been addressed yet.

  • infinite Profile Picture
    infinite 5 on at
    RE: Advanced bank reconciliation: Change posting date of "mark as new" transaction?
    [quote user="Paul Ceely"]

    We are trying to use Advanced bank reconciliation with individual bank statements per day per bank account.  These statements are downloaded from the bank (MT940 format) every business day morning, for the previous day's activity (or, on Mondays, three files are downloaded for Friday's, Saturday's, and Sunday's activity).  When there is a bank-initiated fee included in a statement, we wish to "mark as new" and post.  However, the date that D365 is using is the date the statement is validated, so the posting date is 1 to 3 days late compared to the actual date of the transaction.  Not a big deal until we get to month-end when we need the posting date of the bank fee to show in the correct period…  Is there any way to change the posting date of a "mark as new" transaction?

    [/quote]

    Can you please give me please information of any news regarding this issue, because we have the same issue for a client.

    Regards

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced bank reconciliation: Change posting date of "mark as new" transaction?

    Hi Paul,

    Would be great if you could keep us updated about the feedback from MS.

    Many thanks and best regards,

    Ludwig

  • Paul Ceely Profile Picture
    Paul Ceely 45 on at
    RE: Advanced bank reconciliation: Change posting date of "mark as new" transaction?

    Hi Ludwig,

    You are correct that the posting date really doesn't matter between October 12th and 13th.  However, the issue becomes important at month-end when, for example, the posting date in the MT940 file is 30-Oct-2020 (a Friday) and the statement was downloaded from the bank (and uploaded into D365) on the following Monday, 02-Nov-2020.

    I have opened a ticket with Microsoft and will update this thread as I learn more.

    Most sincere thanks for your thoughts and input.

    Best regards,

    Paul

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced bank reconciliation: Change posting date of "mark as new" transaction?

    Hi Paul,

    I am not aware of any specific parameter; i.e. a developer might have to take a look into this.

    Yet, does this really matter for you?

    What I mean is that your monthly profit/loss does not change if you use 13 or 12 October as posting date.

    Before spending a lot of time on that, I would recommend having a chat with your finance colleagues to get their opinion on this issue.

    Best regards,

    Ludwig

  • Paul Ceely Profile Picture
    Paul Ceely 45 on at
    RE: Advanced bank reconciliation: Change posting date of "mark as new" transaction?

    The fees should be posted on the posting date.  However, the statement is downloaded from the bank the morning of the following day (so, in this scenario, on 13-Oct-2020) and D365 would have used a posting date of 13-Oct-2020 (assuming the statement was uploaded to D365 on the day it was downloaded from the bank).  Is there a way to instruct D365 to use the posting date specified in the MT940 file?

    Thanks!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced bank reconciliation: Change posting date of "mark as new" transaction?

    Hi,

    In field 61 you see first the valuta date in the form JJMMDD (in your case 12 october 2020)

    After the valuta date you have the posting date in the form MMDD (also here you have 12 october)

    The bank charges are for the month of September as specified in field 86.

    Now the question is where do your accountants want to have them posted into (September or October)?

    Personally, I would post them on the valuta or posting date in October because September might already be closed for postings and your financial reports might have already been created for that month.

    That's not perfect but if you have approx. the same fees each month then this monthly shift of the costs does not matter from an overall finance perspective.

    Best regards,

    Ludwig

  • Paul Ceely Profile Picture
    Paul Ceely 45 on at
    RE: Advanced bank reconciliation: Change posting date of "mark as new" transaction?

    Hi Ludwig,

    Many thanks for your response.

    The bank fees are represented in the MT940 as highlighted below:

    BankFeesMT940.jpg

    Based on my limited understanding of these files, the fee shows 12-Oct-2020 for both dates (201012 and 1012).

    I am importing the MT940 files using the process defined in the MS Doc Reconcile bank statements by using advanced bank reconciliation (having completed the setup per the instructions in MS Doc Set up the advanced bank reconciliation import process).

    Thanks in advance for any additional insight you can provide.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced bank reconciliation: Change posting date of "mark as new" transaction?

    Hello Paul,

    In the MT940 file a difference is made between the posting and valuta date.

    Can you double check what date values are shown in your MT940 file especially for the fees?

    You did not mention how you import the MT940 files into D365FO.

    Might be the case that the valuta and posting date have simply been mixed when importing the statements.

    Best regards,

    Ludwig

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