×
Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...
Generate Mini statement
- sailen
- Topic Author
- Offline
- Premium Member
-
Less
More
- Posts: 127
- Thank you received: 1
5 years 6 months ago #22503
by sailen
Generate Mini statement was created by sailen
Hi,
Can anyone help me in generating the mini statement of an account? My requirement is to generate the last 5 transactions of an account. For this, I have used EB.ACCT.ENTRY.LIST(ACCT_NO, FROM_DT, TO_DT, RECORD.LIST, OPEN.BAL, ERR). However I have to generate the statement of an account from Day 1 to the today's date and then generate the last 5 transactions from that array. This is taking quite a long time to generate the last 5 transactions.
I think if I could read last 5 records from RECORD.LIST directly, that would also be the fast way. Can I fetch last records from RECORD.LIST directly?
Is there any other way to fetch the last 5 transactions in a better and faster way?
I look forward to receiving the response asap.
Thanks in advance,
Can anyone help me in generating the mini statement of an account? My requirement is to generate the last 5 transactions of an account. For this, I have used EB.ACCT.ENTRY.LIST(ACCT_NO, FROM_DT, TO_DT, RECORD.LIST, OPEN.BAL, ERR). However I have to generate the statement of an account from Day 1 to the today's date and then generate the last 5 transactions from that array. This is taking quite a long time to generate the last 5 transactions.
I think if I could read last 5 records from RECORD.LIST directly, that would also be the fast way. Can I fetch last records from RECORD.LIST directly?
Is there any other way to fetch the last 5 transactions in a better and faster way?
I look forward to receiving the response asap.
Thanks in advance,
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: 1209
- Thank you received: 158
5 years 6 months ago #22504
by VK
Cheers
VK
Replied by VK on topic Generate Mini statement
Hi
take a look at Fxxx.STMT.VAL.ENTRY table where the references to Fxxx.STMT.ENTRY are stored..
take a look at Fxxx.STMT.VAL.ENTRY table where the references to Fxxx.STMT.ENTRY are stored..
Cheers
VK
Please Log in or Create an account to join the conversation.
- sailen
- Topic Author
- Offline
- Premium Member
-
Less
More
- Posts: 127
- Thank you received: 1
5 years 6 months ago #22505
by sailen
Replied by sailen on topic Generate Mini statement
Hi,
Thanks for the response. But there are no any records in Fxxx.STMT.VAL.ENTRY table.
Thanks in advance,
Thanks for the response. But there are no any records in Fxxx.STMT.VAL.ENTRY table.
Thanks in advance,
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: 1209
- Thank you received: 158
5 years 6 months ago - 5 years 6 months ago #22506
by VK
Cheers
VK
Replied by VK on topic Generate Mini statement
Hi
you probably have "value-date accounting" switched off in ACCOUNT.PARAMETER... for this case there should be another similar table.. try to search either VOC for similar table name or your bnk.data for some recent STMT.ENTRY IDs.
you probably have "value-date accounting" switched off in ACCOUNT.PARAMETER... for this case there should be another similar table.. try to search either VOC for similar table name or your bnk.data for some recent STMT.ENTRY IDs.
Cheers
VK
Last edit: 5 years 6 months ago by VK.
Please Log in or Create an account to join the conversation.
Time to create page: 0.039 seconds