Invoice Monthly Statement

[Dianne]

I need to generate a statement once a month that details all current and outstanding invoices. I have created a statement layout and linked it to my invoices layout.

The invoice layout contains a field that gives the status of the invoice. I would like any pending or invoiced invoices to show up but all paid invoices to be omitted from the report. Would also like to show where the invoice stands i.e current, 30 days, 60 days etc...

Can anyone help me with a script to achieve this?

Many thanks

Di x

[Dianne]

Should I be considering a "Find" solution to this? I'm going through previous threads but there is nothing that relates to my question...if anyone has a thread that I could refer to that would be great too, a point in the right direction would be much appreciated - is there a book or tutorial that deals with setting up an accounts database in Filemaker

Thanks in advance

Diane

[Wim Decorte]

Hi Diane,

We would need to know exactly how your file is set up before we can help.

In general though you would script a find based on the "unpaid" flag. Then sort the found set by "days outstanding", probably add a summary field showing the total amount outstanding per caterogy (30 days, 60 days,...)

[Dianne]

Hi Wim

Its still a major work in progess but I have attached it for you to have a look at. Still very new to Filemaker but its such a great feeling when the penny finally drops...

Let me know what you think and thanks for your time, Diane