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

  • Advanced bank reconciliation: Change posting date of “mark as new” transaction?

    Posted by paul-ceely on October 29, 2020 at 5:49 pm
    • Paul Ceely

      Member

      October 29, 2020 at 5:49 PM

      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?
      Thanks in advance for any assistance!
      #Finance

      ????

      ——————————
      Paul Ceely
      Group ERP Functional Support Specialist
      Britax
      Clover SC
      ——————————

    • Misha Shover

      Member

      October 30, 2020 at 1:27 AM

      Hi Paul,

      I had this issue for a customer last November and at the time, Microsoft advised it was “by design” and suggested we submit an idea for it.Ā  My customer ended up not using the mark as new functionality unfortunately.

      ——————————
      Misha Shover
      Arbela Technologies
      Irvine CA
      ——————————
      ——————————————-

    • Ryan Sorenson

      Member

      October 30, 2020 at 11:00 AM

      I ran into this and got the same response as Misha.Ā  I suggested a small extension to add a parameter to have it use the transaction date instead of the validation date.Ā  I’m not sure if they ended up pursuing that or not.

      ——————————
      Ryan Sorenson
      Sunrise Technologies
      Lehi UT
      ——————————
      ——————————————-

    • Esther Paradoski

      Member

      October 30, 2020 at 1:09 PM

      Hi Paul,

      Here is the link to idea if you would like to vote for it.Ā 

      https://experience.dynamics.com/ideas/idea/?ideaid=52cc8210-874b-e711-80c0-00155d7cb38d

      However, I would also submit it as an issue to Microsoft to try and get more attention drawn to it.

      ——————————
      Esther Paradoski
      Ducks Unlimited Canada
      Stonewall MB
      ——————————
      ——————————————-

    paul-ceely replied 5 years, 9 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Advanced bank reconciliation: Change posting date of “mark as new” transaction?’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!