Hi there,

now i have a system that have a customer database and invoice database. I need to add a aging function to the system that can process an aging report base on a customer. This report will write down how many invoice is given to the customer and which one is paid by customer. There will have a debit and credit column which state the amount of invoice and the payment made by customer. After that it will calculate the total amount that need to be paid by this customer.

Is that got someone have some example of this type of aging report or script.

Exactly how you do this depends upon how your files are structured. The first thing you will need is to decide how to report aging. You can just compute the aging days for each invoice or also group invoices into groups of 0-30, 31-60, 61-90, etc. days.

It's kind of like asking how to replace a fuel injector on a car, it really depends on which specific car you are talking about.

-bd