Dear Friends,
We are implementing SAP Loans Management for one of our clients and he has a requirement to charge Loan Processing fee as follows.
A processing Fee is applied ( an ad-hock amount) on the Loan say 25000 for a Loan amount of 15 ml.
the above amount is charged to the Loan.. it is deducted from each disbursement on a pro-rate basis such that 25000 is deducted when 50% of the loan is disbursed ( i.e. Processing fee of 25000 is completely deducted on pro-rate basis on each disbursement until 7.5 ml is disbursed. there after there is no deduction.
e.g.
1) Loan Amount = 15,000,000.00
2) Processing fee = 25000.00
3) Fist Disbursement = 3,000,000.00
4) Processing Fee Deduction = 25000*((3 ml/ 15 ml)*2)
i.e Processing fee deduction = 10,000.
5) Say next disbursement = 5 ml
6) now since the total disbursement 3 ml +5 ml = 8 ml > 7.5 ml (50% of Loan) the remaining processing fee i.e. 15000 should be deducted from 5 ml.
Is there a way to map this charge such that it is deducted from disbursement on pro-rate basis?
Please direct me to an appropriate condition and how to set it up.
Best regards,
M. Naveen Kumar