You’re offline. This is a read only version of the page.
Announcements
10
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.
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
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 :)
I do research about the solution also have come out this,
but actually i don't know what the AOT means
syedrafayali.wordpress.com/.../
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?
Hello,
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'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?
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 Docs
In 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!
#1
André Arnaud de Cal...
294,118
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
