- SAP Community
- Groups
- Industry Groups
- SAP for Utilities
- Discussions
- Interest calculation

SAP for Utilities Discussions

Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Interest calculation

Options

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

01-29-2016 11:29 AM

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

- SAP Managed Tags:
- Utilities

6 REPLIES 6

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

02-01-2016 11:29 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

02-01-2016 3:18 PM

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

- SAP Managed Tags:
- Utilities

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

02-02-2016 5:00 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

02-04-2016 9:18 AM

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

- SAP Managed Tags:
- Utilities

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

02-04-2016 11:58 AM

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

- SAP Managed Tags:
- Utilities

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

02-04-2016 12:38 PM