Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[James Wong]

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
——————————

[Christopher Ho Yee]

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
——————————
——————————————-

[James Wong]

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
——————————
——————————————-

[Ian Gorman]

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
——————————
——————————————-

[James Wong]

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
——————————
——————————————-

[Ian Gorman]

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

 

Ian Gorman

Senior Functional Consultant

MCA Connect, LLC

M: (407) 595-1036

http://www.mcaconnect.com

 

 

Dynamics Partner of the Year Six Times

Microsoft Inner Circle Member Ten Years

 

——Original Message——

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
——————————