What I have is an Invoices table that has the invoice header info including the invoice total. I have a second table where I have posting information. The first record posted to the table is the invoice total amount and a posting code which indicates this record is the total owed on the invoice.

I then add records for each transaction posted to that invoice along with the posting code, the amount, pay method [if applicable], etc. I can post a [P]ayment, [N]SF charge, [F]inance charge, [I]nterest charge, etc. I then have a lookup table that is a cross reference of what these codes mean and whether they are a payment [-1] or a charge [1]. I can then use a SQL statement to figure out the balance on any invoice using a parameterized view on the Invoice number.

>I have a receivables table and I want to flag them so I can move them to a history table or I want to
>change the amount owed.
>
>Here is an example of my data
>
>Acct_num;Price;Inv_date
>1;40.00;06/27/01
>1;40.00;07/27/01
>
>The customer pays 60 dollars. I want to flag the oldest date as paid and then replace the next one with
>the remaining amount owed which would be 20 dollars. This is just an example of what I need to do. The
>oldest record needs to be changed first and then continue on. Any ideas on how I could do this?
>
>TIA,
>Tyler