Account Statment Questions

Ok I have a couple of questions. I am trying to edit our companys Account Statement to be a printout of Account number, Current Balance in activity, as well as have a running balance in the account activity. We use our accounts as a Debit system and all of the accounts are prepaid instead of using it as a Credit System.

I have been removing some of the information which does not pertain to our setup such as due date, ammount due etc. What I need to figure out is how to pull the customers current balance in their activity as this is the amount of credit they have available to use on their account as of the closing date. IE Jan 1 - December 31 and have the balance shown be the activity balance as of Dec 31. I also need to create a running balance column inside of the accounty activity section Showing the first balance as of Jan 1 and then per each transaction it going up and down via charges and credits (account payments) Now obviously it already prints out the charges and credits in the two columns and I am curious if there is anyway to pull out the balance as of the first date in the query and then show it going up and down in the loop that pulls out the charges/credits. The Account receivables balance is not accurate as the amount of money they have in their account if you go into the customers Account History and look at activity. Is there any way to pull this information for example Customer.Balance ?? (dont think this is an actual way to pull just the theory of what we are trying to accomplish.

In the end the Report will have the stores information in the top left. Account number, current balance as of the date. I am removing the account summary section and then just want to show the account activity between Date X and date Y with a total running column on the far right so they can see their payments and charges affecting the balance and then have a year end total charged so they can use it for Tax purposes.

Any help is greatly appreciated. I assume it is possible to make this happen I am just not sure how to go about it exactly. I have tried countless different combinations with no success.

Reply to
Benjamin Didamo
Loading thread data ...

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.