Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Advanced Bank Reconcil...

Advanced Bank Reconciliation - Matching Rules - 1 to many

(0) Share

Report

Posted on by Community Member 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

All responses (1)

Answers (0)

Suggested answer

Diana Raileanu 37 on at

Like (0)

Report

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.