Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Advanced Bank Reconciliations Matching Rule Not Matching

Posted on by 10

Hello - In AX2012 specific matching rule does not auto-match. Originally, we had an additional criteria of Date < Booking Date. Even after deleting Date < Booking Date still doesn't work. Please help, I'm really out of option. 

1. Expected for "169 4 Day Match Int" deposit of $213.99 on 4/19/21 to match $213.99 data on 4/15. It seems that if there are two or more open bank documents that the rule is confused. 

2. When it says, “Allowed date difference” of 2/3/4 days, how does it function? Does it total all transactions within that 2/3/4 days or does it look for a match one day at a time going back four days until it finds a match?

Thank you and appreciate any assistance on this matter.

pastedimage1623449542500v1.png

pastedimage1623449542501v2.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced Bank Reconciliations Matching Rule Not Matching

    Hi,

    Can you try to setup 5 instead of 4 days in the day difference parameter field?

    If this does not help, then have a look at the following guides for setting up the matching rules:

    docs.microsoft.com/.../import-and-reconcile-using-advance-bank-reconciliation

    docs.microsoft.com/.../set-up-bank-reconciliation-matching-rules

    Best regards,

    Ludwig

  • Yen1973 Profile Picture
    Yen1973 10 on at
    RE: Advanced Bank Reconciliations Matching Rule Not Matching

    Sorry about that. Let's try this again. Thank you for your assistance.

    pastedimage1623676721916v1.png

    pastedimage1623676895085v2.png

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced Bank Reconciliations Matching Rule Not Matching

    Hello Yen1973,

    The screenprints are very small and not readable.

    Can you create new ones and upload them again?

    Many thanks,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans