Skip to main content

Notifications

Announcements

No record found.

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

How to cancel a bank transaction reconciliation?

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 4,815 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 Microsoft Employee 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

     
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,726 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 Microsoft Employee 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 7,962 User Group Leader on at
    D365FO - cancel bank transaction reconciliation
    Hi,
    Thank you for sharing 

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans