>
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__Stephen Russell
>>
"Simplicity is the ultimate sophistication."
Leonardo da Vinci
>> My old crummy site.