I currently produce month end statements for each of our account
holding customers. Each statement has a brought forward amount, a
list of invoices raised in that month, a list of payments made in that
month and a due figure (being brought forward PLUS invoiced MINUS
payments)

What I want to do is have a 30 60 90+ aged detail on the report.
Having as total mental block on this one!

Invoice payments are not linked to invoices, many of our customers pay
odd amounts which do not calculate to the invoices. I did think of
paying each invoice and carrying forward a balance but thought that it
was best practice not to store a calculated value in Access?

Thanks for replying again, Salad.

I accept what you are saying. Using your suggestion, what would I do
if the customer had 3 outstanding invoices (100, 60 and 40) and paid
150?
Would I need to keep a track of the payment received and how it was
allocated? How would I set this up?

BobbyDazzler wrote:
I don't know. As I said in the prior post, I would ask the person in
charge.

Many years ago, mid 90's I had something similar. The user would enter
a customer number. A list of unpaid invoices would be presented for the
customer. The op would enter the check # and dollar amount. Then
select an invoice and mark/flag it paid. Do that until the entire check
was allocated. Some customers may specify which invoices they are
paying. So you'd mark those paid. Any leftover can go to any unpaid
invoices. Or else they'd have a credit.

Like I said, talk to the boss.