kgriff55

I am hoping there is an easy way to do this that I am overlooking. What I want to do is set a certain script to run at night because it takes about 3 hours to complete. This script checks balances due each day for every invoice and fixes a larger problem that we had. I would like to know if there is an easy way to trigger the script at 5pm every day. Filemaker Pro 6 Windows XP

I actually got all this figured out before I read your latest response and am currently running a script to change all of the old invoices to include the change. I am just doing it as a test right now, but it appears to be the solution that I will end up using. Thank you very much.

I guess I really do need some hand holding here. Where would I change this relationship? Also, once an invoice is archived, will it still be easily accessible in case there is a problem down the road?

I'm only about halfway done testing this, but I think it is going to work. Thank you very much. One last question. I assume that now I can just write a script to go through and change all invoices with zero balance to Archived. Is this correct?

I think I only partially understand what you are saying when you say "change your relationship to use this field instead of ContactID". Does this " = Case ( not Archived ; ContactID )" make sure that it is only checking non-archived invoices for that contact ID? I guess I just don't know the sytax that you used (the semicolon). Thanks for all the information.

I just thought of another question in reply to your idea. How would I make the script first find all contacts that actually have invoices so that it can sum the balance due for those contacts?

I like your idea, but have a couple questions. First, won't this take a very long time? Second, could you point me toward your example or give me a little bit more direction? I am not sure how to make a script run only once a day at night. Thanks for your help.

This is kind of a complicated issue and I'm new to all of this, so hopefully it fits this forum. Invoices are created and are related to contact information by a Contact ID. Each contact can have a credit limit that is stored in the contacts database. If the sum of the balance due for every invoice for that contact is > the credit limit, we want to halt the creation of a new invoice. The calculation is as follows: Credit Limit Calc = If(Sum(Invoices::Balance Due) >Credit Limit , "No New Invoices!", "") The problem I have occurs when trying to create a new invoice for a dealer that has a large number of older invoices. The calculation of the balance due can take a very very long time due to calculation of all invoice line items, etc... What we would like to do is limit this calculation to only the last 5 or 10 invoices for that contact so that the time is reduced. I had some ideas, but the following seems to make it difficult: -the invoices for a certain contact are not necessarily in numeric order at all I can't figure out how to make a script or calculation that only considers the last five or last ten invoices (by date). Any insight or help would be greatly appreciated.