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.
Any time. If you hit any snags, feel free to message me.
Senior Functional Consultant
MCA Connect, LLC
M: (407) 595-1036
Dynamics Partner of the Year Six Times
Microsoft Inner Circle Member Ten Years
If you've found this thread useful, dive deeper into User Group community content by role