Aged Debt

[redballoon]

I have an old database I use for Invoicing.

It's updated to FM 9 nicely however I would like to add an aged debt section to it.

I have two filemaker files.

Customer Details

Customer Invoices.

When an invoice is created the customers address nicely fills out with just putting in the business name.

I would like an aged debt section on the Customer details File.

How would I search through the invoices to get the total of Invoices for Current Debt

30 days - 60 days

60 days - 90 days

etc

In the Relationship at the moment between the two the Business name is mapped to the invoice business name which then allows an invoice addresss to be filled automatically.

in Invoices the

Invoice total is in a "total cost" field

Business name in "Business Name" field

Date Created in "Invoice Date" field

So for customer "A" I want to get the Sum of those values in

the "Total Cost" Field

for

date range defined by today's date

and all those invoices with dates =< todays's date -30

for Aged debt of "Current"

then for 30-60 days I want to do the same as above but with dates that are 30 -60 days away from the current date etc...

Any help most appreciated....

[mr_vodka]

How do you mark the invoice paid verse not paid? Are you setting a date with the date that the invoice was paid?

You have not mentioned how you handle your payments at all. IOW, what is your definition of "current debt" and how do you derive it?

Edited February 16, 2008 by Guest

[redballoon]

Oh yes sorry,

I have a Paid field on the Invoice table it is set to "paid" when paid

no I set a date only when the invoice is generated, then it is aged from that point onwards.

[Søren Dyhr]

One way of many could be the way this attachment shows:

--sd

Invoicing.zip