Skip to Content
A R

Effective interest rate -interest calculation issue for interest rate instruments

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
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    Hi,

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

    Regards,

    Nikhil

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 19, 2017 at 01:58 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded