How to extract the minimum balance list

Start
Prev
1
Next
End

chief_mzi
Topic Author
Offline
New Member

13 years 11 months ago - 13 years 11 months ago #6130 by chief_mzi

How to extract the minimum balance list was created by chief_mzi

Hello,
We would like to obtain a list of accounts with their minimum balances in a month. How do we go about that listing: account number, minimum balance for the month.

R08
AIX 6.1
jBase 5.0

Regards

Last edit: 13 years 11 months ago by chief_mzi. Reason: Adding Site Specs

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

Lior
Offline
Premium Member

13 years 11 months ago #6143 by Lior

Replied by Lior on topic Re: How to extract the minimum balance list

Hello,

I assume that by "minimum balance" you mean lowest balance.
My suggestion would be to extract the balances of all accounts on a daily basis, load the data into any database and then run queries on that database.

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

shanthi
Offline
Premium Member

13 years 10 months ago #6207 by shanthi

Replied by shanthi on topic Re: How to extract the minimum balance list

Account Activity has the balance details that can be used to derive the minimum balance of an Account in respective month.

Do let me know for any further clarifications.

Regards,
Shanthi

The following user(s) said Thank You: chief_mzi

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

chief_mzi
Topic Author
Offline
New Member

13 years 10 months ago #6240 by chief_mzi

Replied by chief_mzi on topic Re: How to extract the minimum balance list

Thanks Shanthi, we eventually worked on ACCT.ACTIVITY and were able to extract the minimum balances for all the accounts that we needed to list.

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

Start
Prev
1
Next
End

Time to create page: 0.076 seconds