Skip to Content
0

Effective interest rate -interest calculation issue for interest rate instruments

Jul 14, 2017 at 02:29 AM

108

avatar image
Former Member

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member
Jul 18, 2017 at 03:49 PM
0

Hi,

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

Regards,

Nikhil

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 19, 2017 at 01:58 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded