Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Automatic Bank Reconciliation Matching rules

Posted on by Microsoft Employee

Hello,

I am trying to use auto bank reconciliation in AX for the first time. I have a bank statement in MT940 format. The entire setup is complete for MT940. The MT940 has bank transaction code for transactions such as NCMI, NTRF etc. 

In matching rules search criteria for statement lines,  I selected bank transaction code = NCMI (value) and for open bank document lines i selected bank transaction type = bank transaction code (statement fields).

Also, in the MT940, it has reference number for each transaction. In matching rules search criteria for open bank document , I set payment reference = Reference Number (statement fields).

When i run matching rules, it says "0 statement lines were  matched for rule NCMI."

Can someone please explain how the matching rules should be set? I aim to match transactions based on 'bank transaction code' in statement lines to 'bank transaction type' as well as match the 'reference number' to 'payment reference number' in AX.

Please help.

  • Martin Dráb Profile Picture
    Martin Dráb 225,526 Super User on at
    RE: Automatic Bank Reconciliation Matching rules

    Syed, I'm sorry, but I honestly don't see anything rude in what said:

    By the way, please don't prefix titles of your threads with "Dynamics AX" or "Microsoft Dynamics AX". All questions in this thread are about Dynamics AX, therefore repeating it in title doesn't provide any new information and just makes title less readable. I'll remove it for you from both threads.

    I just explained the author of this thread how the thread titles should look like and why. That's one of duties of a moderator.

    Can you please point out to what you consider rude? I may learn from different points of view.

    And please, don't use any swear words, as you did in the original version of your reply. It weakens your argument if you vulgary shout at people not to be rude.

  • Syed Kazmi Profile Picture
    Syed Kazmi 5 on at
    RE: Automatic Bank Reconciliation Matching rules

     goshoom every post i read of yours is so rude my friend. You can definitely word it better so people feel welcome.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Automatic Bank Reconciliation Matching rules

    The Automatic Bank Reconciliation Matching rules performance was very slow.  We got like 2 millions records to match every day , but it breaks. Is there any way to improve the performance. Thanks

  • Martin Dráb Profile Picture
    Martin Dráb 225,526 Super User on at
    RE: Dynamics AX Automatic Bank Reconciliation Matching rules

    By the way, please don't prefix titles of your threads with "Dynamics AX" or "Microsoft Dynamics AX". All questions in this thread are about Dynamics AX, therefore repeating it in title doesn't provide any new information and just makes title less readable. I'll remove it for you from both threads.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics AX Automatic Bank Reconciliation Matching rules

    Thanks Ludwig.

    Just want to confirm, I have multiple transactions posted with same amount and reference number. So when I run the rule, it doesn't pick that line even though the details match exactly. Is it because there are multiple ditto lines and the system cant particularly select one of them?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Dynamics AX Automatic Bank Reconciliation Matching rules

    Hi,

    There can be many reasons why you get this message. The issue might either be with your file and/or the matching rules that you setup.

    Here are some great sites that can help you

    - community.dynamics.com/.../deep-dive-bank-reconciliation-matching-rules-ax-2012-r3

    - dynamicsnavax.blogspot.de/.../advanced-bank-reconciliation-ax-2012-r3.html

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans