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

Concat table to know list of accounts ( including closed account) for CUSTOMER

Start
Prev
1
Next
End

kartsnek
Topic Author
Visitor

5 years 7 months ago #22480 by kartsnek

Concat table to know list of accounts ( including closed account) for CUSTOMER was created by kartsnek

Hi,

Do we have any concat table to know list of accounts for a customer including closed account?
Eg.
Customer A has 10 accounts initially and now he closed all 10 accounts. Now we want to know the customer hold how many accounts.

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

silvergem
Offline
Elite Member
TAFC|R12/R13, TAFJ|R20

5 years 7 months ago #22481 by silvergem

Replied by silvergem on topic Concat table to know list of accounts ( including closed account) for CUSTOMER

The concat table is ACCOUNT.CLOSED which contains only closure date. Then you can use this as Main table/reference table to select on ACCOUNT$HIS with record status of closed. All Live accounts can be found on CUSTOMER.ACCOUNT

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

Start
Prev
1
Next
End

Time to create page: 0.035 seconds