GL Reports
- partha
- Topic Author
- Offline
- New Member
- Posts: 10
- Thank you received: 0
Can you please explain in detail about GL in T24? What are all the parameterization required to generate the GL reports in T24.
Thanks
Partha
Please Log in or Create an account to join the conversation.
- jpb
- Offline
- Moderator
- TAFj-R20 - 'unix'
- Posts: 2854
- Thank you received: 649
Please Log in or Create an account to join the conversation.
- partha
- Topic Author
- Offline
- New Member
- Posts: 10
- Thank you received: 0
Please Log in or Create an account to join the conversation.
- balaji2301
- Offline
- Senior Member
- Posts: 58
- Thank you received: 8
Can u please tell me how to verify the GL reports and what one needs to look in GL report??
Regards,
R Balaji
Please Log in or Create an account to join the conversation.
- jpb
- Offline
- Moderator
- TAFj-R20 - 'unix'
- Posts: 2854
- Thank you received: 649
If you mean verify as 'reconcile' this is highly dependant on your setup and the used modules, I can't answer generally.
To look into the generated reports use the enquiry REPORT.LIST and select by REPORT.NAME.
For specific enquiry on certain lines you can use enquiry RE.STAT.LINE.CONTENT or use RE.STAT.BAL.REC to print detailed information.
Does this help?
Please Log in or Create an account to join the conversation.
- jpb
- Offline
- Moderator
- TAFj-R20 - 'unix'
- Posts: 2854
- Thank you received: 649
Thanks for your response. I want to verify as reconcile please let know what setup I need to refer and to check the report for the transactions inputted. Some LD, SEC.TRADE, MG transactions have been inputted I need to verify against the transaction in GL report. Please advise.
Normally this is a task for your finance department ;-)
The only general tip is to search for the transaction reference in the report and compare to the result of enquiry TXN.ENTRY.
Positions/accounts/deals should match to EB.CONTRACT.BALANCES (most of them in there).
If there are any gaps in defining the LINES you will get transactions under CATCH.ALL or you will have a mismatch.
As mentioned before, recon is to be established to your needs. I don't have a 'out-of-the-box' solution.
(E.g. I don't know MG and when you talk about SEC.TRADE in GL are these own book transactions ? Too many unknown !)
Please Log in or Create an account to join the conversation.
- balaji2301
- Offline
- Senior Member
- Posts: 58
- Thank you received: 8
I have created a SEC TRADE for Bond with Value date as 09 Apr 2014 but I am not getting the interest accrued detail in CRB report as on 31 DEC 2014. Interest accrued is displaying on 01 Jan 2015 for the same SEC TRADE. Please help me to know why it was not displaying on 31 DEC 2014.
Interest Accrual for other SEC TRADE which I created on 14 Dec 2014 is displaying in CRB report as on 31 DEC 2014.
Thanks in advance.
Regards,
R Balaji
Please Log in or Create an account to join the conversation.
- jpb
- Offline
- Moderator
- TAFj-R20 - 'unix'
- Posts: 2854
- Thank you received: 649
The underlying files for own book are Fxxx.SC.TRADING.POSITION and Fxxx.SC.TRADE.POS.HISTORY.
Maybe the setup in SECURITY.MASTER is causing this difference, e.g. ACCRUAL.START.DATE or COUP.DIV.CUT.DATE or ...
Please Log in or Create an account to join the conversation.
- Louis_CL16
- Offline
- New Member
- Posts: 11
- Thank you received: 1
I have a query about how to map line for new product?
Please Log in or Create an account to join the conversation.
- jpb
- Offline
- Moderator
- TAFj-R20 - 'unix'
- Posts: 2854
- Thank you received: 649
Please Log in or Create an account to join the conversation.
- Louis_CL16
- Offline
- New Member
- Posts: 11
- Thank you received: 1
Do I have to make new product from the range (RE.STAT.RANGE) , or have to create a new line?
If I have to create a new line, how can I build it for ASSET&LIAB key and PRF&LOSS?
I am sorry because I don't know how to map line.
Please Log in or Create an account to join the conversation.
- jpb
- Offline
- Moderator
- TAFj-R20 - 'unix'
- Posts: 2854
- Thank you received: 649
If for example you define a new account-type you might want to show it with the already existing line for current accounts.
So locate the lines (debit and credit) where current accounts are shown and check how the selection is made.
In GL
Maybe it's just something like ASSET.APPLIC.ID = AC, CATEGORY = 1000, ASSET.TYPE = CREDIT/DEBIT (depending on your CONSOLIDATE.COND for AL), maybe you have e.g. CATEGORY = *ACBILCL and/or ASSET.TYPE = *CAT51 (a star means the values are taken from RE.STAT.RANGE, see e.g. GLSTD.3120).
In PL the logic is the same, see e.g. PLSTD.0100
If you have to change a already used RANGE you have to remove it from the LINES (shown in REPORT.NAME, REPORT.LINE) before you can amend them.
If you need a new assignment in either report you can just insert a new LINE at the correct place with your selection.
Please Log in or Create an account to join the conversation.
- Louis_CL16
- Offline
- New Member
- Posts: 11
- Thank you received: 1
As I know that total print is used to calculate the total for Type "total". And "total accum" is used to calculate the total for Type "detail". For example, every detail which is record 2 in field total accum will be sum total in the line type "total" which is record 2 in field total accum.
So, what if total is record "3,4,5,6 or 7"? because we can define 1 field total accum for each line.
Can you give me a more clear example?
Thank you
Please Log in or Create an account to join the conversation.