×
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...
HVT Account Statement
- Khinhhak
- Topic Author
- Offline
- New Member
-
- TAFJ_R18_LinuxOne
Less
More
- Posts: 7
- Thank you received: 2
9 months 4 weeks ago #24396
by Khinhhak
HVT Account Statement was created by Khinhhak
Hi all,
Have anyone experience with HVT account statement display not properly? Any solution applied. Thanks.
Have anyone experience with HVT account statement display not properly? Any solution applied. Thanks.
Please Log in or Create an account to join the conversation.
- kripesh
-
- Offline
- Platinum Member
-
Less
More
- Posts: 456
- Thank you received: 65
9 months 3 weeks ago #24397
by kripesh
Have a great day !
Replied by kripesh on topic HVT Account Statement
Hi,
Kindly give more details for your question on HVT Statement. What is the Statement name. How are you executing it ? Attach some screenshot for it if possible. Explain in detail so that someone who has come across such problem will be able to help you. Things like the Release of T24, Database used can also be helpful in some cases. Using UXP or Old Browser etc etc...
Kindly give more details for your question on HVT Statement. What is the Statement name. How are you executing it ? Attach some screenshot for it if possible. Explain in detail so that someone who has come across such problem will be able to help you. Things like the Release of T24, Database used can also be helpful in some cases. Using UXP or Old Browser etc etc...
Have a great day !
The following user(s) said Thank You: longnt2012
Please Log in or Create an account to join the conversation.
- Khinhhak
- Topic Author
- Offline
- New Member
-
- TAFJ_R18_LinuxOne
Less
More
- Posts: 7
- Thank you received: 2
9 months 3 weeks ago #24398
by Khinhhak
Replied by Khinhhak on topic HVT Account Statement
Hi Kripesh,
I refer to Account Statement Enquiry (ENQ STMT.ENT.BOOK) which display the all transactions debit/credit opening/closing balance of account. Since HVT account balance is merged by using TSA.SERVICE so the sort order in the STMT.PRINTED is not correctly sorted and consultant advised to sort DATE.TIME on enquiry which impact the performance (DATE.TIME is multivalue and no indexed on STMT.ENTRY) and also not guarantee 100% due to missed implemented DATE.TIME to have second. Thus I would seek for any better experience on displaying right order for HVT account
Here we use R18 with Oracle DB and Browser.war
I refer to Account Statement Enquiry (ENQ STMT.ENT.BOOK) which display the all transactions debit/credit opening/closing balance of account. Since HVT account balance is merged by using TSA.SERVICE so the sort order in the STMT.PRINTED is not correctly sorted and consultant advised to sort DATE.TIME on enquiry which impact the performance (DATE.TIME is multivalue and no indexed on STMT.ENTRY) and also not guarantee 100% due to missed implemented DATE.TIME to have second. Thus I would seek for any better experience on displaying right order for HVT account
Here we use R18 with Oracle DB and Browser.war
The following user(s) said Thank You: kripesh, longnt2012
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: 1187
- Thank you received: 157
9 months 3 weeks ago #24399
by VK
Cheers
VK
Replied by VK on topic HVT Account Statement
Hi
just a thought: you can get date and time of STMT.ENTRY record from its @ID:
OCONV(@ID[1,5], 'DG') ==> date
OCONV(@ID[11,5] ,'MTS') ==> time with seconds.
just a thought: you can get date and time of STMT.ENTRY record from its @ID:
OCONV(@ID[1,5], 'DG') ==> date
OCONV(@ID[11,5] ,'MTS') ==> time with seconds.
Cheers
VK
Please Log in or Create an account to join the conversation.
Time to create page: 0.079 seconds