Documentation >
MAC-PAC Reference and Help >
Technical Support >
Key Concepts and Procedures >
Valid Values >
Valid Values With Sort
Valid Values With Sort
Valid values lists with a sorting capability are similar to the simple valid values lists. However, when the valid values window is displayed, two new function keys are available that allow you to choose a sort key field (F8) and to save the sort key field for future inquiries (F21). A sort key field is the field used to sort the valid values list. For instance, a list of vendors may be sorted by vendor number or vendor name. Only one sort key may be chosen at a time. The list of possible sort keys are usually the same as the fields found in file with the valid values. For example, the vendor master file contains the following important fields: vendor number, vendor name, currency, hold code, and vendor group. Each of these fields may be used as the sort key field when sorting the valid values list.
When you press F8, a new window is displayed listing the possible sort keys. You may scroll through the list and select a line as the new sort key or exit the window by pressing F3. To select a line, you must enter an X in the select field on the left side of the line and press Enter. You may also specify whether you want the values to be sorted in ascending or descending order by entering an A (ascending) or D (descending) in the A/D field of the line. If no value is entered in the A/D field, it will default to A. Once you select a sort key, the sort window is closed and the valid values window is re-displayed with the list sorted as specified in the sort window. When the valid values list is displayed, you may select a line to return to the screen, exit the window, specify another sort key, or save the new sort key by pressing F21. If you press F21, the new sort key will be saved and used to sort the list during future inquiries. The following example illustrates the sort function.
You want to perform a vendor inquiry in Purchasing, but you do not know the vendor number. When the select screen is displayed, you position the cursor in the Vendor field and press F4 to obtain a list of valid customers.
WILLIAMS COMMON FEATURES 2/12/93
DSP01 VENDOR MASTER INQUIRY SELECT
.-------------------------------------------------------------------------.
S | VENDOR LIST |
| |
| Position to |
| |
| Vendor Curr Hld Grp One Cons |
| Number Vend Name Code Cde Cde Tim Vendor |
| AMY1 AM YARBOROUGH USD Y |
| 1234 MAIN STREET IL 60038 |
| ARTISUS ARTISUS USD JS N |
| 2905 LARK CT. |
| BARST BAR STEEL SUPPLY USD Y |
| 1234 MAIN STREET IL 60540 |
| BCA00001 BCA MANUFACTURING USD N |
| 3234 W. GLACIER DRIVE IL 60634 |
| CSTEXP CUSTOMS EXPEDITING USD AA N |
| 3000 W. SANTA MONICA BLVD. CA 91010 | +
| |
| F3=Exit F8=Sort F21=Save |
| |
'-------------------------------------------------------------------------'
|
The Vendor List Valid Values Window.
The list is displayed with the vendor and vendor description fields, and you are given the option to sort the values with the F8 key. You don't recall which vendor you wish to use, but you know it pays bills using US dollars. Because you would like to see the list sorted by currency, you press F8 and the sort window is displayed. You choose Currency Code as the sort key by placing an X in the select field on that line and request that the list be sorted in descending order by entering an D in the A/D field of the line.
WILLIAMS COMMON FEATURES 2/12/93
DSP01 VENDOR MASTER INQUIRY SELECT
.-------------------------------------------------------------------------.
S | VENDOR LIST |
| |
| Position to |
| |
| Vendor Curr Hld Grp One Cons |
| Number Vend Name Code Cde Cde Tim Vendor |
| AMY1 AM YARBO .------------------------------------------------.
| 1234 MAIN STREET | SELECT SORT CRITERIA |
| ARTISUS ARTISUS | |
| 2905 LARK CT. | Position to |
| BARST BAR STEEL | |
| 1234 MAIN STREET | A/D Field Description |
| BCA00001 BCA MANUF | Vendor Number |
| 3234 W. GLACIER DRI | Vendor Name |
| CSTEXP CUSTOMS E | X D Currency Code |
| 3000 W. SANTA MONIC | Vendor Hold Code |
| | Vendor Group | +
| F3=Exit F8 | F3=Exit |
| | |
'----------------------- '------------------------------------------------'
|
The Sort Criteria Window from the Vendor Valid Values List.
This window is displayed by pressing F8 - Sort.
With the desired sort key selected, you press Enter to re-display the valid values list sorted by currency. When the list is displayed, you may choose to save the country code as the sort key by pressing F21. Otherwise, you can select a customer to return to the select screen or exit the window without making a selection.
WILLIAMS COMMON FEATURES 2/12/93
DSP01 VENDOR MASTER INQUIRY SELECT
.-------------------------------------------------------------------------.
S | VENDOR LIST |
| |
| Position to |
| |
| Vendor Curr Hld Grp One Cons |
| Number Vend Name Code Cde Cde Tim Vendor |
| SMVEND01 SAM'S TEST VENDOR USD N |
| 6545, N. STATE ST. IL 660001 |
| SLVEND4 REMOTE WAREHOUSE VENDOR USD N |
| REMOTE WAREHOUSE IL 60602 |
| SLVEND3 REMOTE WAREHOUSE VENDOR USD N |
| REMOTE WAREHOUSE IL 60602 |
| SLVEND2 REMOTE WAREHOUSE VENDOR USD N |
| REMOTE WAREHOUSE IL 60602 |
| SLVEND1 REMOTE WAREHOUSE VENDOR USD N |
| REMOTE WAREHOUSE IL 60602 |
| |
| |
| F3=Exit F8=Sort F21=Save |
| |
'-------------------------------------------------------------------------'
|
The Vendor Valid Values List Sorted by Country Code.