D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

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

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

    SILVER CONTRIBUTOR
    Posted Oct 29, 2020 05: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
    ------------------------------


  • 2.  RE: Advanced bank reconciliation: Change posting date of "mark as new" transaction?

    Posted Oct 30, 2020 01: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
    ------------------------------



  • 3.  RE: Advanced bank reconciliation: Change posting date of "mark as new" transaction?

    GOLD CONTRIBUTOR
    Posted Oct 30, 2020 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
    ------------------------------



  • 4.  RE: Advanced bank reconciliation: Change posting date of "mark as new" transaction?

    SILVER CONTRIBUTOR
    Posted Oct 30, 2020 01: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
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role