Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Advanced Bank Reconciliation - Matching Rules - 1 to many

Posted on by Microsoft Employee

Hi All,

We are implementing the advanced bank rec and are in the testing phase. The rules are working excellently for 1 to 1 match however we cannot find a rule to work for a 1 to many match (We process batch receipt journals and payment journals which show as multiple lines in the bank documents however the bank statement line is a single line).

I have found a post here from 2014 - http://dynamicsnavax.blogspot.com.au/2014/11/deep-dive-bank-reconciliation-matching.html which says under FAQ: You can only match 1 statement line to 1 document line. Microsoft does have a plan to allow 1 to many matching. No release date has been announced.

I cannot find any further info on if this is now available. I don't want to waste more time testing rules if the option isn't even available. Obviously we can still manually match but the point of implementing the advanced rec is to have as much auto match as possible.

Any info or advice appreciated.

Thanks

Alison

*This post is locked for comments

  • Suggested answer
    Diana Raileanu Profile Picture
    Diana Raileanu 37 on at
    RE: Advanced Bank Reconciliation - Matching Rules - 1 to many

    Hello Alison, 

    I have the same requirement for my customer, and the way this was achieved is by creating a matching rule that does not have the 'Match amount' enabled. I am still narrowing the match by date and additional criteria like bank transaction type etc.  This enabled us to automatically match 1 bank statement to many Dynamics transactions. 

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans