Whenever you press <F4-Select> against an application database within the stock system the details displayed can be configured to show the details 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 stock application in turn asking you to select the items, up to ten, that you wish to display. You are also asked:
The details listed when using <F4-Select> depend on the item searched upon. If search on the prime-index (which for the stock file would be the stock code) then items are listed in stock code order, if enter a search on a secondary index (for the stock file this could be the stock description) 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.
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 stock file, the stock code or physical quantity. 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).
Note: these items only affect the items displayed in the list when selected within Stock Control; 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.
Article ID: 515
Created On: Tue, Jun 19, 2012 at 11:36 AM
Last Updated On: Thu, Jun 22, 2023 at 10:52 PM
Online URL: https://kb.datafile.co.uk/article/select-key-definition-stock-control-515.html