web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How to Add 4th Matching Criterion (External Doc No.) and Prioritize Over Amount in Bank Rec?

(4) ShareShare
ReportReport
Posted on by 13

I am working on customizing the automatic bank reconciliation process in Microsoft Dynamics 365 Business Central (DBC365). Currently, the system matches bank statement lines with ledger entries based on three criteria:

  1. Amount

  2. Document No.

  3. Description

I want to add a 4th matching criterion: External Document No., and I want this criterion to be prioritized over the amount. This means that if the External Document No. matches, the system should consider it a valid match even if the amounts differ. If the External Document No. is empty or does not match, the system should fall back to the default matching logic (amount, document no., and description).

Has anyone successfully implemented a similar customization? If so, could you share your approach or code snippets?

Is there a way to force the system to accept matches based on External Document No. even if the amounts differ?

NB: I am working with DBC365 On-Premise.

 

Objective: Adding a 4th matching criterion (External Document No.) and prioritizing it over the amount.

 

I can't find the setup page  of auto match.

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    95,331 Super User 2025 Season 2 on at
    Looks like the same problem.
     
    Of course, you can consider customization. You can make a separate button, for example, to reconcile according to External Document No. This will not destroy the standard logic and can meet your needs.
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Gerardo Rentería García Profile Picture
    25,157 Most Valuable Professional on at
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,275 Super User 2025 Season 2 on at

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans