Notifications
Announcements
No record found.
Hi All,
After realized that I reconciled the wrong bank account, how do I unreconciled it? Does anyone have any suggestion(s)? This is AX 2012. Thanks so much!
*This post is locked for comments
Hi Kim,
Did you make use of the standard or the advanced bank reconciliation feature?
How did the wrong reconciliation happen?
Ludwig
I am in the same situation. I accidentally hit reconcile instead of opening lines. any idea on how to reopen this..
Hi mouni,
Can you provide more information on what kind of reconciliation you used (simple/advanced) and what you did exactly?
Many thanks and best regards,
in Standard AX it is not possible to unreconcile a bank reconciliation - you have to do it via the AOT.
(I assume you are on Ax 2012) - you can try this: Of course test this first within a Test environment.
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.
Hi Ludwing,
I have used advance bank recon functionality. All the lines in bank stmnt were reconciled except one. So I acccidentally hit "Reconcile" instead of clicking "Lines" on recon journal. So I am thinking to fix this by creating a new statement manually for that single line , match it with open bank document and then reconcile in a new journal. Let me know if this works
Good post.
Thank you, it is helped for me too.
Hii
how to make the Reconcile Date field editable in the Bank Account Statement table .
and
How to remove the Reconcile Date.
confuse about it
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 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2