× 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
  • New Member
  • TAFJ_R18_LinuxOne
More
4 months 4 days 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.

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

More
4 months 3 days ago #24397 by kripesh
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...

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
  • New Member
  • TAFJ_R18_LinuxOne
More
4 months 3 days 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
The following user(s) said Thank You: kripesh, longnt2012

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
4 months 3 days ago #24399 by 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.
 

Cheers
VK

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

Time to create page: 0.072 seconds