In order to keep this short I won't go into all that I am trying to do.
I would like to create calculation fields that will summarize all of the debits and credits for a particular account number without having to display it all in a layout. What I want in a single line is... account -> total debits -> total credits. So the calculation has to add up all the values of debits, for example, where the account is a certain value. I want this to be for all records, which after a number of years could be quite a few, but I don't want to have a big long list of the records just to get this value.
Acct=1100 total debits= whatever total credits= whatever
Acct=1200 etc etc etc.
Does this make sense?
Thanks in advance for any help. I am trying to help a friend have an accounting solution that is just like a program he used to use. He is old and doesn't want to learn something new.