Debtors Aged Analysis

  • Thread starter Thread starter nclsgna
  • Start date Start date
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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query wont sort ? 10
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Crosstab query for Aged Analysis Error 4
DupliciteRecords 1
Array extended formula - sort 3
Access Default Microsoft Access Order Entry database issue 0
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Please, need help with A/R aging 4

Back
Top