COB reporting process and reporting
- Barthelemy
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
1 year 4 months ago #24231
by Barthelemy
COB reporting process and reporting was created by Barthelemy
Hello
I begin with T24 and realise actually a mission in bank using T24. NB : This bank use R14 of T24
I want to help this bank :
1) to identifiy mismatch entriees after COB and correct them
What can I do please ? Which report file generated in COB can help me ? Which JQL can be execute to determine efficiently those mismatch ?
2) Which JQL can be execute to identify all account having negative working balance at 30/06/2023 ?
I need in this query the information below :
branch account, account number, account currency, working balance in account currency, date, customer ID, customer name
3) WHere can I identify all COB program which generate a file report ? Where are those file name are configured ?
I begin with T24 and realise actually a mission in bank using T24. NB : This bank use R14 of T24
I want to help this bank :
1) to identifiy mismatch entriees after COB and correct them
What can I do please ? Which report file generated in COB can help me ? Which JQL can be execute to determine efficiently those mismatch ?
2) Which JQL can be execute to identify all account having negative working balance at 30/06/2023 ?
I need in this query the information below :
branch account, account number, account currency, working balance in account currency, date, customer ID, customer name
3) WHere can I identify all COB program which generate a file report ? Where are those file name are configured ?
Please Log in or Create an account to join the conversation.
- VK
- Offline
- Platinum Member
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1182
- Thank you received: 157
1 year 4 months ago #24232
by VK
Cheers
VK
Replied by VK on topic COB reporting process and reporting
Hi
to get mismatches report you can run application RE.STAT.MISMATCH with V function.
Balances can be found in FBNK.EB.CONTRACT.BALANCES (for the main company; for others - find out corresponding mnemonic in F.COMPANY) and in FBNK.ACCOUNT (for main company).
Consolidates balances: F.EB.JOURNAL.SUMMARY, FBNK.CONSOLIDATE.ASST.LIAB (again - for main company).
to get mismatches report you can run application RE.STAT.MISMATCH with V function.
Balances can be found in FBNK.EB.CONTRACT.BALANCES (for the main company; for others - find out corresponding mnemonic in F.COMPANY) and in FBNK.ACCOUNT (for main company).
Consolidates balances: F.EB.JOURNAL.SUMMARY, FBNK.CONSOLIDATE.ASST.LIAB (again - for main company).
Cheers
VK
Please Log in or Create an account to join the conversation.
Time to create page: 0.079 seconds