Faster Past Due Updates....

[smilemaker]

I've created a accounts receivable database that holds invoices, payments, and adjustments in the same database file. This seems to work well. I liked the suggestion in this forum about determining past due invoices by customer balances....rather than individual invoice records.

So, my question. I've written a script that will run periodically to update past due accounts. This script takes a long time (1 hour or so). I would like to update all the customer records on start-up each day. My script basically loops through each customer record and uses several calculations that sum certain records (that have been flagged) through relationships. This works. However, it seems slow. The calculations can't be stored due to the sum/relationship usage. Is there a better way to do this? Thanks for any help.

[Anatoli]

Post each transaction after creating to the customer balance. Then you never need to calculate sum from many records, which is slow. Static values in database are best operator friends

[northstar1128]

What calculation did you use for the overdue notification. I will never have more than 20 or 30 overdues in my program. I'm having trouble being notified of my overdues and then having trouble have the "checked in" record being checked in. It records it as another record instead of one less record.