Interest calculation

[former_member261786]

Hi All,

We have interest calculation scenario where interest to be calculated on slab rate base.

Text	Posting Date	Due Date	Amount
Receivable Debit	01.01.2015	10.01.2015	1000

Date From	Date To	Days in Arrears	Interest Percentage
10.01.2015	09.02.2015	30	10%
09.02.2015	11.03.2015	30	20%
11.03.2015	Above		50%

• For first 30 days from the due date is 10%
• For next 30 days from the due date is 20%
• 60 and above days is 50%.

Can this requirement achieve with standard configuration with bellow mentioned path?

Interest Calculation - Item Interest Calculation - Define Reference Interest Rates - Define Percentage Rates for Reference Interest Rates - Define Interest Calculation Rules - Define Interest Key - Maintain Amount Limits for Debit/Credit Interest - Define Interest Lock Reasons - Define Specifications for Interest Calculation - Activate Additional Functions for Interest Calculation - Define Clearing Reasons for Which Interest is not Calculated - Define Specifications for the Mass Run.

I am facing challenge to map different % at interest key while assigning at contract level.

If enhancement is needed can you suggest the reference information to take it forward?

Regards,

Hari

[former_member261786]

Hi All,

Any review comments on this plz...

[AmlanBanerjee]

Hi Hari,

You will not be able to acheive your requirement through standard Configuration.

So, now what I could see is you want to trigger the interest functionality through mass transaction, FPINTM1.

However, enhancing event 2000, you will be able to cater your requirement.

Through this event, you can have different interest key for at different point of time for the same line item, depending on the buisness conditions.

So you can have three interest keys defined in SAP and assign the first one at the Contract account level. The first time it will take the interest key from CA and post the interest document, for the second and third document, it will check if there is any interest document posted previously for the document from DFKKIH table.

If yes, it will check the interest key and then will proceed accordingly.

Hope it helps..

Thanks,

Amlan

[former_member261786]

Thanks Amlan...

[former_member261786]

Hi Amlan,

Thanks for above inputs for this solution, I got another challenge to meet the interest calculation.

Including above scenario – if interest run is not initiated for 80 days from the due date, system has to calculate first 30 days 10% and next 30 days 20% and with current date validation as 50%. Posting with 3 interest items at CA level.

In my current client they are running either quarterly or half yearly (Still not confirmed).

Continues to 2000 event can this functionality achieve by any FM.

Thanks,

Hari

[AmlanBanerjee]

Hi Hari,

Your requirment is in similar lines to the scenario, where in there is a change in the interest rate in the interim b/w two interest posting period interval.

Say, suppose, last interest posting happend in 01/01 and there has been a change in the interest rate on 01/15, then if the interest is calculated on 01/30, then as per standard SAP functionality, the interest document that is posted will have two separate line items, one for 01/01-01/15 for Interest rate,I1, and another for 01/16-01/30 for Interest rate,I2.

Check event 1788; this is the event where the interest posting is performed.In here you have to pass the three different due dates with three different interest rate.

Hope it helps

Thanks,

Amlan

[former_member261786]

Thanks Amlan...will check this.