Notifications
Announcements
No record found.
Hi all,
anyone can help me to solve this?
I realize I put wrong bank statement date after I reconcile the bank reconciliation, any suggestion or solution to edit the bank statemen date after i reconcile?
System: Microsoft Dynamics AX 2012 R2
Thank you in Advance.
Hello,
I see that in D365 there is an ability to cancel a bank statement reconciliation. See URL here: Reconcile a bank account - Finance | Dynamics 365 | Microsoft DocsIn which case you should be able to cancel & redo the process with the correct date.With that being said, I realize you're on 2012.Does 2012 not have any buttons in the UI that allow you to modify after reconciliation?If not, then it appears you may be out of luck from within the application.However, since you're on 2012 (and should have access to your data still), you could always resort to writing a SQL script to modify that field (assuming it's only that 1 field that you're looking to manipulate).
- is the purpose of updating that date to the correct bank statement date just for your own tracking?- i.e. I'm just verifying that the bank statement date doesn't have any other implications to you / your team / your system
Assuming "YES" to the above questions, there should be no issue with modifying that date from the back-end. But that's entirely at your discretion.Please let us know if you have any other questions about this.Thanks!
I'm using Microsoft Dynamic AX 2012 R2
Because I'm reconciled the Nov transaction and key in wrong the bank statement date on 31/12/2020, it should be 30/11/2020.
In month-end, if I want reconcile Dec bank transaction, is it still can put the bank statement date on 31/12/2020? And the Dec transaction will appear let me to reconcile?
From my testing, it doesn't appear you'll be able to do this in the UI. When you try to use the same bank statement date, the transactions you're looking to reconcile have already been reconciled.
And since you can't undo bank reconciliation in the UI (in 2012), you may want to glance @ this thread: community.dynamics.com/.../613347
There's a post about halfway into the thread that gives you an option of remedying this via the AOT.
If you go that route, be sure to do so in a TEST environment first.
Here's another non-MSFT site that explains how this can be done:
syedrafayali.wordpress.com/.../
Not an idea scenario, but thankfully you're not completely stuck.Thanks! :)
I do research about the solution also have come out this,
but actually i don't know what the AOT means
And can't see the capture of this link step of the process on how to click in system, how to remove reconcile date and how to compile?
Hi Lizzz,
AOT = Application Object Tree
The AOT is more commonly utilized by folks who are technical. So if you haven't heard of it at this point, you would likely not be the person on your team who would be making any sort of changes in the AOT.You may want to get in touch with someone on your team that's more technical / a developer / etc.
In the meantime, these links can provide some info on the AOT (and how to open it in AX 2012):
Thanks so much :)
Thank you Brandon Johnson, problem was solved. ;)
Good morning Lizzz,
Can you spend a view words on how you solved the problem?
This will certainly help other community members as well.
Many thanks for your support.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 503 Most Valuable Professional
André Arnaud de Cal... 434 Super User 2025 Season 2
BillurSamdancioglu 278 Most Valuable Professional
