× 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...

enquiry on overdraft.

  • roshan zha
  • Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 6
  • Karma: -1
  • Thank you received: 0

roshan zha created the topic: enquiry on overdraft.

Hi ALL,
Can anyone help me out with this. i need to create a enquiry which will have a list of overdraft account number and with total no of overdraft account.
2. the debt remain outstanding for 30 day or more beyond the schedule payment or maturity but less than 90 day.
3. the account fail to show debit balance.
4. the account has been inactive for more than 30 day but less than 30 day.

the only thing i need to from which application i can get all these detail.

Thanks,
#21963

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

  • Posts: 105
  • Karma: 2
  • Thank you received: 7

MasterL replied the topic: enquiry on overdraft.

If I were you I'd start with ACCOUNT.OVERDRAWN table.

DATE.FIRST.OD field contains the date the account went into OD. You can use that to calculate the number of days the account has been in OD since (use CDD)
Number 2 sounds more like a loan issue than an overdraft issue. But still, with CDD you can cluster the account by number of days OD
3. I don't understand the requirement
4. Check ACCOUNT.INACTIVE file and use CDD to calculate the days
#22021

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

  • Posts: 26
  • Thank you received: 2

Shibumi replied the topic: enquiry on overdraft.

Could you provide following info?

What is the application used for overdraft accounts? AC or AA
Which release of T24?
#22023

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

Time to create page: 0.207 seconds