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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Matching rules in Bank...
Finance | Project Operations, Human Resources, ...
Answered

Matching rules in Bank reconciliation

(3) ShareShare
ReportReport
Posted on by DE-03121601-0 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:
Dynamics 365 Finance
I have the same question (0)
  • Verified answer
    Giorgio Bonacorsi Profile Picture
    Giorgio Bonacorsi 1,465 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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 590 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 349

#3
Diego Mancassola Profile Picture

Diego Mancassola 263

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans