Automatic Bank Reconciliation Matching rules

(0) Share

Report

Posted on by Community Member

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.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Syed Kazmi 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No