Skip to main content
Dynamics 365 Community / Forums / Finance forum / How to cancel a bank t...
Finance forum
Answered

How to cancel a bank transaction reconciliation?

editSubscribe (2) ShareShare
ReportReport
Posted on by 9
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):
 
  • Layan Jwei Profile Picture
    Layan Jwei 2,789 Super User on at
    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.
  • 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 Profile Picture
    Hana Xue on at
    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

     
  • Verified answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,410 Super User on at
    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.  
  • 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 Profile Picture
    Hana Xue on at
    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 Profile Picture
    Mohamed Amine Mahmoudi 3,550 UG Leader on at
    D365FO - cancel bank transaction reconciliation
    Hi,
    Thank you for sharing 

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans