Advanced Bank Reconciliation - Matching Rules - 1 to many

(0) Share

Report

Posted on by Community Member

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

I have the same question (1)

All responses (1)

Answers (0)

Suggested answer

Diana Raileanu 39 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No