Problems with an aging report in MS Access
Posted on 2003-11-18
Hi, I was wondering if you might be able to help me with a problem I'm having. I'm trying to write an aging report that draws from two tables in an Oracle database - Invoice_Aging and Cust_Payments. All invoices are recorded in Invoice_Aging, and all the payments are recorded in Cust_Payments. How can I write a report in Access that will combine the two tables and figure out the customer's current open balance?
I'm having logistical problems, since payments should be applied to the oldest invoice first, then the next oldest, etc. But, for example, if a customer was to have an invoice from 120 days ago and one from 90 days ago, then decided to pay it in one lump sum, can I break out the payment to apply partly to the 120 invoice, and the rest to the 90? How can I write this into a report?
Any help would be greatly appreciated.