Debtors Aged Analysis

N

nclsgna

I am trying to create a debtors aged analysis, where a customer can make
payments for multiple invoices (eg Cheque 001 for $66 pays for invoices of
$30, $29 and $11, implying a short payment on one of the invoices).

Can anybody assist?
 
V

Vincent Johns

The easiest way that occurs to me to do this would involve some VBA
code. You could, for example, list the unpaid invoices for that
customer, then spit out payment records in some order (such as oldest to
newest, or largest to smallest) until the money runs out. Is that what
you have in mind?

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Top