Skip to main content



No record found.

Microsoft Dynamics AX forum

Advance Bank reconciliation

Posted on by 7
Recently We have set up advance bank reconciliation for one of our client. All went well, and its functioning fine. The challenge we have encountered for below kind of transcation:
Client booked and FD for a short duration for funds sitting idle in current accounts.
For example - FD booked from Bank FD on 15th of March 2024 amounting to 100 INR.
1. FD matures on 15th April 2024 and bank statement has two lines- one for 100 INR and another for 5 INR Interest. (2 lines in statement  on 15th April 2024).
2. User post the bank transcation 105 INR in D365 F&O  in one line in Bank (105 INR- one line in Bank transcation).
Now I am not able to define a matching rule (Many to one) as well as not able to match manually.
Bank statement and Bank transcation have- same date- 15th April, and total amount is same (100+5=105 in Bank statement and 100 in Bank transcation).
Please some one can guide on how to define matching rule for such scenario.
This is not a reversal transcation.

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,632 Super User

Martin Dráb Profile Picture

Martin Dráb 224,528 Super User

nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans