MAC-PAC Homecontact ussupport login 
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.