Ok, I have the clients table. I have a table with the verified trips. I was storing the payments in the same table, but that can be changed. As the payments come in, I should apply them to the trips and record them in the payments table.

I think I have that so far. I think I'm also starting to grasp how I calculate the balance, but I just got the new message buzz so I'm going to look and see if that's you responding to the message where I asked about calculating balances.

Thanks,

-Michelle


>You are asking for account aging, but you don't track payments against the transactions. This is like saying "I'm hungry but I don't feel like eating." You can't win.
>
>If you need to age accounts receivable then you need to keep invoices their dates, their original amounts, and their current balance. You need to apply payments against those invoices. Payments should be in their own table, perhaps named Payments.
>
>Theproblema you are having are related to the data design. You must go back and rethink the nature of the information you are recording. There are trips, people pay for these trips, people want a statement every month showing them what they owe, and very likely what they owe it for. You want to kick them in the but if they don't pay, so you want to show them how long ago they took the trip that they haven't paid for.
>
>To do this you need a data design that will record the required information. You need a customer table to know who the peole are, you need a trips table to know what trips have been taken by whom and to keep track of whether or not the trip has been paid, you need a payments table to record each payment received and you need to apply that payment against a trip or even more than one trip.
>
>You need to be able to calculate balances for date ranges. To do this you need data for each trip with the date and the amount still left unpaid. Carrying around calculated balances will be a downfall of the system. It will get out of synch and you won't have the original detail to reconstruct it. You will lose revenue and not even know it.