× Discuss on Insight, business intelligence and reporting, Regulatory, Risk, Financial & Performance, Monitoring with Systar, T-Risk, ALCO Reporting, etc…

Report of Transaction passed on different accounts

  • emushaija
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 57
  • Karma: 1
  • Thank you received: 4

emushaija created the topic: Report of Transaction passed on different accounts

Hello All

I have a requirement to prepare report showing all accounts and all transactions passsed on those accounts.

I am glued ,any idea on how i can get a way through that requirement?
#13971

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

  • Posts: 203
  • Thank you received: 29

gm.saran replied the topic: Report of Transaction passed on different accounts

If you T-Insight, then it's easier to take it from the SQL Database.

Otherwise, u've to pick it up from multiple tables
1. ACCOUNT.STATEMENT containts the date on which STATEMENTS are printed.
2. STMT.PRINTED holds all the txns on an account (KEY-DATE) and the Key for the STMT.ENTRY
3. STMT.ENTRY

Combining these, you need to build a No-File enquiry . . .
#13972
The following user(s) said Thank You: Momo

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

Time to create page: 0.375 seconds