D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Bank Reconciliation

  • 1.  Bank Reconciliation

    SILVER CONTRIBUTOR
    Posted 9 days ago
    We accidentally entered an incorrect bank statement date for our Dec 2019 bank recon.  We posted it with a 1/31/2019 date so now we have TWO bank recs posted for Jan 2019.  When we run the reconciliation summary it seems to be pulling in some info from our original 1/31/19 bank rec. I haven't drilled down on it but the numbers don't see to match what we think should be the Dec 2019 numbers.  Is there any way to "fix" this?  Thanks.

    ------------------------------
    James Wong
    Senior Finance Manager
    Murray Franklyn Companies
    Bellevue WA
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: Bank Reconciliation

    TOP CONTRIBUTOR
    Posted 9 days ago
    What version are you on? Also, are you using the standard or advanced bank reconciliation

    If you are on D365 and using standard bank rec, there is a new feature release that will allow you to cancel reconciled statements.



    ------------------------------
    Christopher Ho Yee
    Altius Consulting
    Richmond BC
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: Bank Reconciliation

    SILVER CONTRIBUTOR
    Posted 9 days ago
    Christopher,

    I should have mentioned that we are on AX2012.  I haven't seen a "cancel reconciled statements" feature.  That would be too easy. :-)  Thanks

    ------------------------------
    James Wong
    Senior Finance Manager
    Murray Franklyn Companies
    Bellevue WA
    ------------------------------

    Conference-AXUG_200x200


  • 4.  RE: Bank Reconciliation

    GOLD CONTRIBUTOR
    Posted 9 days ago
    Well, 2012 complicates things. It wasn't until the last few months where Microsoft released a process for this.

    Get with your AX admin or Microsoft Partner. Here's the fix I've found online a few years back that I've always used with my clients.

    In the BankAccountStatement table  make the ReconcileDate field editable.

    Search  for the incorrect Account Statement and remove the ReconcileDate.

     Remember to change the ReconcileDate field back to uneditable and compile the table

    Check the front end screen ahs reflected the change.

    Now to unmark the  reconciled transactions - go back to the AOT  this time to the BankAccountTrans table and make the Reconciled field editable. .

    In the BankAccountTrans table, filter on your Account Statement and unselect the Reconciled check box against each transaction. Compile the table.

    Change the Reconciled field back to uneditable and compile the table.

    The transactions are available to unmark in the Bank Account Reconciliation Form

    Once the cleared flag against  the transactions are removed, delete the original reconciliation and create a new reconciliation.



    ------------------------------
    Ian Gorman, PMP, MCSE
    Senior Consultant
    ------------------------------

    Conference-AXUG_200x200


  • 5.  RE: Bank Reconciliation

    SILVER CONTRIBUTOR
    Posted 9 days ago
    Thanks, Ian.  Yes, I figured this would be a little more complicated and there would be a "reverse" button any where.  I've reached out to our AX Partners for their assistance.  Thanks for the info.

    ------------------------------
    James Wong
    Senior Finance Manager
    Murray Franklyn Companies
    Bellevue WA
    ------------------------------

    Conference-AXUG_200x200


  • 6.  RE: Bank Reconciliation

    GOLD CONTRIBUTOR
    Posted 9 days ago

    Any time. If you hit any snags, feel free to message me.

     

    Ian Gorman

    Senior Functional Consultant

    MCA Connect, LLC

    M: (407) 595-1036

    www.mcaconnect.com

     

     

    Dynamics Partner of the Year Six Times

    Microsoft Inner Circle Member Ten Years

     




    Conference-AXUG_200x200


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