Hi experts,
I have a requirement something like this. In CFM module we have some deals created.
For each deal there will be deal start date and end date.
Based on the user given input date I need to capture intrest accumlated till that date. Thats ok. But the problem is in between there can be repayments done.
For example : say deal number is 2004010155
start date : 4/1/2008
end date : 3/31/2009
basic amount : 8,00,000.
say suppose on 30.06.2008 a partial repayment of 1,00,000 done.
Now if user given date is 31.07.2008,then we need to calculate intrest amount with basic amount as 8,00,000 till 30.06.2008 and
starting from 01.07.2008 to 31.07.2008(user given date) I need to calculate intrest with amount 7,00,000.(After deducting one lakh as partial repayment done during this period).
For refernce table name is VTBFHAPO.
How can we achieve this?
Thanks & Regards
Himayat.