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 :
Finance | Project Operations, Human Resources, ...
Answered

Advance bank reconciliation

(2) ShareShare
ReportReport
Posted on by 15

I’m trying to run a matching rule in D365 FO for a scenario where one lump‑sum bank transaction should match against multiple payment journals. After running the rule, no error was reported, but no transactions were matched. Has anyone experienced this issue, and what configuration steps are needed to make the rule work for one‑to‑many, many‑to‑one, or many‑to‑many scenarios instead of only one‑to‑one matching? 

Screenshot of the rule setup and bank statement attached.

Bank recon 2.png ...
Bank recon 1.png

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:
  • Suggested answer
    vishalsahijwani Profile Picture
    410 on at

    Hi @HA-05080935-0 ,

    Please check if total of journal amount is matching with the bank transaction completely otherwise even if there is a slight mismatch can cause a non matching issue with 0 errors.

    Also please get your matching rules reverified thoroughly.

  • Suggested answer
    CU29070609-0 Profile Picture
    24 on at

    Hi @HA-05080935-0 ,

    The amount adds up correctly (1,100 + 900 = 2,000),so the issue is not an amount mismatch.Looking at your matching rule setup, the problem is
    likely with the Group condition set to "Payment reference". Here is what is happening :

    The Many-to-Many rule groups transactions using the Payment reference before matching. If the bankstatement transaction does not have a payment reference, or if the payment references on the bank transactions do not match the bank statement,the grouping fails silently with no error and no match is made.

    Steps to fix :

    1. Check Payment Reference :
      Make sure the payment reference on your bank statement transaction matches the payment references on both bank transactions(1,100 and 900).

    2. If no Payment Reference is available :
      Remove "Payment reference" from the Groupcondition in Step 1 of your matching rule.Use a different grouping field or leave it empty to group by amount only.

    3. Many to Many rule requirement :
      For Many-to-Many matching to work correctly :
      → Total of selected bank statement lines must equal total of selected bank transactions
      → Grouping condition must match on both sides
      → All checked criteria must be satisfied

    Kindly mark this as verified if its helpful !

  • Aayush Tiwari Profile Picture
    384 on at

    Hello @HA-05080935-0 

    I have a similar query regarding matching rules, were you able to resolve this, if yes please mark the correct answer as verified. If no correct solution is given please post the solution that you have implemented.

    Regards

    Aayush Tiwari

  • Verified answer
    HA-05080935-0 Profile Picture
    15 on at

    Hi @vishalsahijwani & @CU29070609-0 , thank you for your suggestion. I’ve identified the error and it originated from the Transaction Code Mapping, which wasn’t correctly mapped. After correcting the mapping, the reconciliation ran successfully.

    @Aayush Tiwari , please review your Transaction Code Mapping as well; I hope this resolves the issue on your end.

  • Aayush Tiwari Profile Picture
    384 on at

    Hello @HA-05080935-0 

    Thanks You sharing the solution, this resolves the query that i has having.

     

    Please mark your solution as a verified answer.

     

    Regards

    Aayush Tiwari

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 426 Most Valuable Professional

#2
CU10121822-0 Profile Picture

CU10121822-0 358

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 353 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans