Home » Categories » Multiple Categories

Select Key Definition

Datafile Software

Select Key Definition

Whenever you press <F4-Select> against an application database within the sales or purchase order processing applications the details displayed can be configured to show what you require. This is done via the ‘Select Key Definition’.

As you select this option the system displays each of the ‘system’ databases used within the application in turn asking you to select the items, up to ten, that you wish to display.You are also asked:

LIFO Sequence

The details listed when using <F4-Select> depend on the item searched upon. If search on the prime-index (which for the order processing files would be the order reference) then items are listed in order reference order, if enter a search on a secondary index (for the order processing files this could be the account code) then items are listed in the order they were created. Setting this option reverses this sequence so that details are listed in either reverse prime-index or reverse entry order.

Auto-Sort Column
Auto-Sort Descending

As an alternative to the above you could set the records to be listed in a set sequence. This could include, in the case of the order processing files, the date required. The item you sort on must be one of the list items you have set to be displayed and, here you select the column number of the data item you wish to sort upon and whether the records are to be sorted in descending order (leave blank for ascending order).

Notes

These items only affect the items displayed in the list when selected within the ledger; they do not affect the items you can filter on (i.e. the header selection inputs). These are the prime and secondary indexes of the databases concerned.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Document Control Database Copy Items
Viewed 25 times since Tue, Oct 15, 2024
Recall Standard Text
Viewed 1426 times since Wed, Jul 4, 2012
Order Entry - Replicate Sales Orders with Deposits (SOP Only)
Viewed 21 times since Thu, Oct 24, 2024
Record Last Order Details for Account and Stock
Viewed 2601 times since Fri, Jun 19, 2020
Application User Facilities
Viewed 1484 times since Wed, Jul 4, 2012
Print Invoices / Purchase Invoices - Application User Facilities
Viewed 1485 times since Wed, Jul 4, 2012
Document Processing - Alternative Extra Text Items
Viewed 1065 times since Fri, Jun 19, 2020
Additional User Accumulation Items
Viewed 55 times since Thu, Oct 24, 2024
Show Actual Price on Quantity Break Display
Viewed 1453 times since Tue, Jun 12, 2012
Assembly Components as Quick Form
Viewed 1508 times since Fri, Nov 22, 2013