>Hi Peter,
>
>Let's see if I understand this. You have charges and payments which could apply to either current,30,60, or 90 day balances. You have already accumulated (and stored) 30,60, and 90 day prior balances, right? You want to apply charges and payments as appropriate.
>
Don't you have to tie payments against / to an invoice or scheduled payment?
IMHO as you get your data together you sum all payments + credits per invoice and combine that data with the incoice details in a SQL statment.
Now there is one line per invoice showing billed, paymnets against.
Next go to the reort writer and make a report to display the datain the propper column. Or in a normalized environment NEVER MAINTAIN this data in a table. Makes no sense because it could change this afternoon. Run this process as needed either by customer or by company.
__Stephen
