Skip to Content
avatar image
Former Member

Month End Indicator in FTR_EDIT is disabled for editing (Treasury Module)

Hi Gurus,

Good day, just want to ask why the interest of my security was calculated based on 28 days only which should have been based on 30days on February 2018. I checked the set up of the security and it was set to 360/360. I made a research that in order to treat February a 30 days, the MthEnd indicator should have been ticked or set up. Should I also change the Int.Calc.Method from 360/360 to 360E/360 instead?

Month-end indicator for end of fixed period

If the month-end indicator is set, for the purposes of calculation according to the German interest calculation methods of 360/360 and 360E/360, the last day of February is assumed to be the 30th, meaning that 30 interest days are calculated for the month of February.
If the month-end indicator is not set, 28 interest days or 29 in the case of a leap year are calculated.
The number of specified interest days is reduced by one day if the inclusive indicator for the fixed interest period end is not set.

My concern is:

1. If I am going to tick the MthEnd indicator, does this affects the previous postings? My only concern is that, February postings for future year should be treated as 30 days instead of 28 or 29 days.

2. I am trying to edit the security to set the MthEnd indicator, however, the field is disabled and greyed out hence, changes cannot be performed?

Neet your inputs and expertise on this badly.

Thanks in advance.

PA Reyes

fmboh.png (15.4 kB)
ojh0g.png (182.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 28 at 11:00 AM

    Hi PA,

    That checkbox involves only your transaction and Interest accrued. As you are on 08.05.2013 it will not change Interest but on 28.02.2013 it will have some effect. I have checked my system and on creation of transaction I'm able to edit MthEnd.

    If you want to change the value for Interest Coupon you have to change conditions in FWZZ

    If you change value it will affect future operations. if you are not able to edit conditions, you may need to copy the condition with the new date to enable it. You can check calculations with TPM44 and "Key Date is Month-End" checkbox

    Kind Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 16 at 03:13 AM

    Hi Gustavo,

    Thank you for your answer. I also checked as well the TPM44 and found out that the "Key Date is Month-End" is not set during the ran of job for TPM44. I may need to update the variant to set the "Key Date is Month-End".

    Thanks for the help. Appreciate it very much.

    Thanks,

    PA Reyes

    Add comment
    10|10000 characters needed characters exceeded