Account Accrued Interest

  • MasterL
  • MasterL's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
12 years 5 months ago #9283 by MasterL
Account Accrued Interest was created by MasterL
Hi,

Any way to get the historical accrued interest amounts on an account in T24 - r09/r10?

STMT.ACCT.CR is only populated once there is a capitalisation
ACCR.ACCT.CR is blank

There is a field in ACCOUNT, ACCR.CR.AMOUNT which shows the current accrued interest

(The reverse is true for DR in the cases above)

So my question is how do I get the cr or dr accrued interest for previous days?

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #9290 by Dzuki
Replied by Dzuki on topic Re: Account Accrued Interest
Try to create new category with another rate, change the category of account, close the day.
System have to recalculate all accrued interest from the account opening.
But check it in test area.

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #9313 by c.santul
Replied by c.santul on topic Re: Account Accrued Interest
In the application ACCR.ACCT.CR or ACCR.ACCT.DR you'll get the accruals posted for the current capitalization period only.

The accruals for the Previous Capitalization Period would already be capitalized and always the Accrual Amt = Capitalization Amt, if there are any corrections they are also posted on the same period (obviously on the following COB once the adjustment txn is posted).

So if you want to know the Accrual Amount for the previous period use - STMT.ACCT.CR or STMT.ACCT.DR as the case may be. In case you need to find the Exact Accrual for day by day...its tedious work but not impossible.

Extract all the CATEG.ENTRIES for your account with TRANSACTION.CODE EQ 380 390 and those will be your accrual entries / amounts for all the days. Please note that it is not easy to identify the CE for a particular account unless you have setup your CAL Keys to include the account number in the reference.

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #9327 by DUBLIN
Replied by DUBLIN on topic Re: Account Accrued Interest
1. Check ACCOUNT.ACCRUAL , filed DEFLT.ACCR.FQU . Is it daily ?

2. If answer is Yes then next question would be :

What is capitalisation frequency ?

If it's DAILY then T24 wouldn't create any records in ACCR.ACCT.CR but will post capitalisation entries on daily basis => nothing in ACCR.ACCT.CR but something in STMT.ACCT.CR. To get all historical information all you need to do is just to select all records for particular account from this table.

If capitalisation frequency is not DAILY then , as it was said by others, ACCR.ACCT.CR will keep accruals up to date since last interest payment date.
All "PAST" accruals could be found in STMT.ACCT.CR.

Personaly, I wouldn't even think to go with creating of the report based on CATEG.ENTRY = DOOM & GLOOM !

Please Log in or Create an account to join the conversation.

  • MasterL
  • MasterL's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
12 years 4 months ago #9357 by MasterL
Replied by MasterL on topic Re: Account Accrued Interest
In ACCOUNT.ACCRUAL, field 17 (WRITE.ACCR.ACCT) needs to be set to YES for T24 to write the accruals into ACCR.ACCT.CR and ACCR.ACCT.DR during COB. It is disabled by default due to performance concerns.

You can view the accruals per account by verifying the account number in INFO.ACCT.CR and INFO.ACCT.DR applications.

Please Log in or Create an account to join the conversation.

Time to create page: 0.103 seconds