How to cancel a bank transaction reconciliation?

(1) Share

Report

Posted on by Community member

In D365FO how can we cancel a bank transactions reconciliation that was done from the bank transactions side and not from the bank statement side?

The reconciliation was done this way because the transactions were only found on the D365FO side.

The reconciliation was done in the following way (an example we made now in the test system to show how we did this):

1) From bank transactions, we selected the bank transactions (Debit and Credit) that should be reconciled, then went to /Reconcile transactions/

2) Then, the two transactions were marked as reconciled

Where can we undo this reconciliation?

What we have tried:

1) Select one of the reconciled transaction and go to Reconciliation relations. This shows only empty lines because this has no bank statement relation:

2) Go to the bank transactions for one of the reconciled bank transaction, and there go to tab Bank transactions, both the field /Cleared/ and /Reconciled/ are YES, and cannot be changed from there (greyed field):

All responses (7)

Answers (0)

Layan Jwei 7,345 Super User 2024 Season 2 on at

Like (0)

Report

How to cancel a bank transaction reconciliation?

Hi Community member,

Frank's answer will be marked as verified now. Thanks for coming back to us.
Community member 9 on at

Like (0)

Report

How to cancel a bank transaction reconciliation?

The solution suggested from Frank was the way we went to solve the issue (I wasn't able to mark his answer for some reason), we had our developer create a customization that unchecks the reconciled transactions on the bank transactions page and that solved our issue.

Thank you for your replies and help.
Hana Xue Microsoft Employee on at

Like (0)

Report

How to cancel a bank transaction reconciliation?

Hi,
I agree with Frank, if you want to achieve your needs you have to consider customization.
Best Regards,
Hana
Suggested answer

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (1)

Report

How to cancel a bank transaction reconciliation?

You may need a developer to write a custom script to uncheck these items. You can reverse a reconciliation if it's done via the Bank account reconciliation process but even that wasn't possible until Microsoft provided that enhancement a few years ago.
Community member 9 on at

Like (0)

Report

Cancel bank transaction reconciliation

Hi Hana, thank you for your response. This is a question I am having, the question I have (and the problem) is the following:

In D365FO how can we cancel a bank transactions reconciliation that was done from the bank transactions side and not from the bank statement side?
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Cancel bank transaction reconciliation

Hi,
Thank you for sharing, it will help a lot of people on the forum, besides, it would be better if it was written as a blog, because too many posts in the forum can sometimes overwhelm it. And please mark it as verified as this is an experience post and not a question.
Best Regards,
Hana
Mohamed Amine Mahmoudi 9,531 Super User 2024 Season 2 on at

Like (0)

Report

D365FO - cancel bank transaction reconciliation

Hi,

Thank you for sharing

How to cancel a bank transaction reconciliation?

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Community AMA December 12th

Leaderboard

Featured topics

Product updates

How to cancel a bank transaction reconciliation?

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Community AMA December 12th

Subscribe to

Leaderboard

Featured topics

Product updates