cancel
Showing results for 
Search instead for 
Did you mean: 

Effective interest rate -interest calculation issue for interest rate instruments

anjireddy_appireddy
Contributor
0 Kudos

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!

Accepted Solutions (0)

Answers (2)

Answers (2)

anjireddy_appireddy
Contributor
0 Kudos

The variable interest rate date fix issue (month end date issue) looks like resolved after implementing SAP NOTE-2148458

2148458 - Missing interest day for financial transactions with term "End Incl."

Thanks everyone for your time and looking into the issue.

NikhilAdke
Employee
Employee
0 Kudos

Hi,

Can you post a screenshot of your Structure Tab and cash flow ?

Regards,

Nikhil