You’re offline. This is a read only version of the page.
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
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.
goshoom every post i read of yours is so rude my friend. You can definitely word it better so people feel welcome.
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
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.
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?
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (