Best way to manage end term of ongoing loans

[anjireddy_appireddy]

Hi Experts,

We would like to track ongoing activity for intercompany loans. As part of the process, there is no clear end date to enter at the time of deal creation for intercompany loans. Let say there are two legal entities- X & Y. X lend money to Y and there is no designated end date to receive money from Y. Whenever funds available Y will give it to X. It can be 1 month or 1 year or 3 years. We calculate interest every month and book accounting entries.

Couple of points to consider-

1. If we give current month/ current year as end of the term, most likely users will forget to update the end term of one month or one year.

2. If i give end date as 31 Dec 9999, system will give run time error for unlimited cash flow generation.

What is the good end term user need to give at the time of deal creation?

Pls suggest.

[grigoriy_babitskiy · Accepted solution]

1. If we give current month/ current year as end of the term, most likely users will forget to update the end term of one month or one year.

Write ABAP programm Reminder to check the dates of all intercompany loans. For example, before a week to remind them to extend all deals.

Plan this programm using SM37.

[former_member656317]

All, For the Tcode FTRTLC00 what is the table name for line items Please advise

[former_member656317]

All, For the Tcode FTRTLC00 what is the table name for line items. Please advise.

[former_member618734]

Hi A R and Experts ,

I Understood the solution provided to these scenario , but Please explain ,where or which activity user will forget to update the end term of one Month or one year (Highlighted below).Is at the time of Creating the Deal (FTR_CREATE) ?

1. If we give current month/ current year as end of the term, most likely users will forget to update the end term of one month or one year.

Thanks you in Advance..

[anjireddy_appireddy]

Thanks everyone. We have decided to use it as year end activity.yearly once users update end date.

[former_member198450]

Hi,

This is open ended loan, In this case what we did is updated end of term as 2099 which most likely no loan will continue till this date.

In case you want to make development then you can proceed with changes in program or you can opt this approach too it business call.

Regards,

Jain varghese