× 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

Start
Prev
1
Next
End

emushaija
Topic Author
Offline
Senior Member

10 years 11 months ago #13971 by emushaija

Report of Transaction passed on different accounts was created by emushaija

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?

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

gm.saran
Offline
Elite Member

10 years 11 months ago #13972 by gm.saran

Replied by gm.saran on 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 . . .

The following user(s) said Thank You: Momo

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

Start
Prev
1
Next
End

Time to create page: 0.090 seconds