
This example adds filtering on an amount and/or a document number to the Apply Sales Document window when the Find window is used. as well as sorting the documents by date. The additional functionality can make it much quicker to find the correct document for a payment to be applied to, by its amount or by any part of its document number.
This customization also demonstrates some very useful techniques including:
- using Virtual Fields instead of Modifier to add the extra fields we need,
- using Triggers to capture a table reference to a temporary table,
- applying a where clause to that temporary table,
- using a where clause that involves more than one table,
- adding virtual keys to the temporary table,
- and manipulating the contents of the temporary table.
Continue reading →