Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

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!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 224,528 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans