 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / January 2006Debtors Aged Analysis
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 <vjohns@alumni.caltech.edu> Please feel free to quote anything I say here. > 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? Yes, that is what i have in mind, where payment is allocated to the oldest invoice first. (more like FIFO for stocks). >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 [quoted text clipped - 10 lines] >> >> Can anybody assist? One problem though: I know nothing on VBA. Can you suggest a less painful process than having to learn VBA? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.