[Store]  [Cart]  [Resources]  [Learning]  [About]  [Solutions]  [Consulting]  [News]  [Links]

Questions s Coffee cups indicate the complexity of a file, tip or article. One coffee cup is the easiest and three is the most advanced. To download a file, click on the green arrow icon next to the listing. If there are no coffee cups or platform icons, the listing may be an article, Quick Tip, Knowledgebase or bonus file.

Displaying 1...1 of 1 Resources found  [Another find]
Overdue Invoices    Download   Intermediate   Tip File    Version 12
The Proper Method for Locating Overdue Invoices
databasepros.com/list.php?resource_id=DBPros001298
Finding records that are overdue (such as in an invoicing solution) should not be done with a calculation field. Calculation fields can be used as an alert but should not be searched since they have to be unstored in order for the Get(CurrentDate) function to update, thus making the search unindexed and possibly slow. This file not only includes a calculated warning message but also a script that finds overdue records without interfacing with the warning calculation.


Productive Computing