Share
ReportRecently 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.
I have the same question (0)
All responses (
Answers (
382
