Find Script

[Dianne]

I posted a while back for some help and a member kindly posted some info but I am still confused as to how I go about writing a script to solve my problem.

Members advice is below - how do i organise this into a script though...

"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,...)"

I have an 'invoice' layout with a 'status' field showing paid unpaid etc...I would like to find all unpaid invoices for each client detailing the days outstanding i.e current, 30 days, 60 days etc...and move each found set to a new 'statement' layout to print out

Could someone outline a rough script so I can get the general idea of how it works, hopefully I will then be able to adapt it.

thanks in advance for any help and advice

best regards, Dianne

[aaa]

I suggest you for each invoice create calc field as:

Days_Outstanding=Case(not paied,Today-Creation_date,"")

Then you can find your invoices by this field.