Hi,

We are using variable interest rate for our interest calculation and post every month-end.

For each month we use only one interest rate. for ex- Jan- 2%(whole month), Feb-2.1%, Mar-2.3% and Apr-2.4%. We use TJ05 for interest rate adjustment for financial transactions. Interest calculation working correctly in normal cases except month end date. We have identified a special case, where loan start date is 31 Mar and ends on 17th April (we follow end date as inclusive).

When I try to adjust interest rates using TJ05, it should consider March and April interest rates. However system is considering March interest rate and calculating interest as per March rate. Please suggest why system is not considering April interest rate and how do I solve it.

Example-

Loan amount -100,000

Loan Start date - 03/31/2017 and end date -04/17/2017 (End date inclusive).

When I run TJ05-Interest rate adjustment, system update interest rate of the 03/31/2017. System supposed to calculate interest for April, based on April interest rate (2.4%), but system is calculating interest for April based on March 31st interest rate. Interest is zero for March as we use end date as inclusive instead of start date.Not sure, why system ignores, April interest rates. The behavior of the system is different for monthend date.

Thank you!

## Add comment