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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Matching rules in Bank reconciliation

(3) ShareShare
ReportReport
Posted on by 27
Dear Experts,
 
I have a very simple requirement and hopefully this is very common.
 
Our client is sending the payment from D365 and the same payment line they want to reconline with automatic matching rule.
 
So we want a matching rule which is like- Voucher number from D365= reference number in MT940 field, if same or contain then it will match.
 
How the matching rule will look like?
 
Categories:
I have the same question (0)
  • Verified answer
    Giorgio Bonacorsi Profile Picture
    1,031 on at
    Hello,
     

    Technically, it is possible to implement some custom alignment, but we first need to take a step back from a functional standpoint.

    The voucher is generated by D365FO and represents the internal accounting registration. It serves as the unique identifier for the posted journal entry in the general ledger. This number is typically auto-generated from a configured number sequence. For the information shared with the customer, we populate the payment reference field in the payment journal line. This field is specifically designed for external use: it is included in the bank payment file and appears on the recipient's bank statement.

    The reference number visible on the bank statement is therefore an external element, typically filled with meaningful details for the recipient (like invoice numbers, customer references, or structured codes). This information can even be provided or completed by the client/payee themselves during reconciliation.

     

    Technically the matching rule should be define here:

     

    Thank you, 

    Giorgio

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

News and Announcements

Season of Giving Solutions is Here!

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 338 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans