Accounting Script

[jimmyfix]

For any help I receive I thank you in advance.

I am donating my help to an old carpenter friend who doesn't want to learn anything new and I am stuck.

Basically I have a situation where I have an account which we will call "Cash Checking". It has both debits and credits. Nothing mind blowing there. My friend wants to enter data once a month for the whole month. There are a bunch of other acounts too which also have debits and credits as well. He has a layout called "Audit Trail" That shows all the debits and credits for all the accounts he has entered data for in that month. Some of these accounts have carry over totals and some don't. The ones that don't are not a problem. The ones that do however are troublesome. Cash Checking for example. In this Audit Trail there is a list of Debits and a list fo Credits. I need a balance for the account which could be a debit balance or a credit balance depending on which sum is greater. This I think I have figured out also but getting a balance for the month on this account that is up to date is tricky. January is easy. Then we come to February or any other month after that and trouble. I use the same layout to view any month of data so If I view January then the account balance must be for January when I view the month of February or any other the balance must include all past entries. Do I need to store the month totals somewhere and what happens if he makes a change in the January data how is the stored data updated. I have a field called MonthYear that will be unique for each set of data of course but do I create a script that will add things up depending on which month he wants to view or can I get the balance field to do the job???

Any help is most appreciated...

[dansmith65]

It's difficult to give advice without having a better understanding of your database setup. For starters, a screen shot of your relationships might help.

He has a layout called "Audit Trail" That shows all the debits and credits for all the accounts he has entered data for in that month

How is the data in this layout limited to only one month? Are you performing a find with a date range of one month?