× 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
More
6 years 9 months ago #21963 by roshan zha
enquiry on overdraft. was created by roshan zha
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,

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

  • MasterL
  • Visitor
  • Visitor
6 years 4 months ago - 6 years 4 months ago #22021 by MasterL
Replied by MasterL on 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
Last edit: 6 years 4 months ago by MasterL.

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

More
6 years 4 months ago #22023 by Shibumi
Replied by Shibumi on topic enquiry on overdraft.
Could you provide following info?

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

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

Time to create page: 0.304 seconds