MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference and Help > Technical Support > Key Concepts and Procedures > Valid Values > Valid Values With Pre-Selection

Valid Values With Pre-Selection

 

 

Valid values with pre-selection capability are the most complicated of the valid values lists.  They allow you to limit the values displayed in the list to those that meet the selection criteria specified in the initial pre-selection window.

When you request a valid values list with pre-selection, a window of enterable fields is displayed.  You may enter valid data into these fields to be used as selection criteria for the valid values list, exit the window and return to the screen, or request valid values for a field on the pre-selection window.  If you enter valid selection data, only values that meet the criteria are displayed in the valid values window.  If you do not enter any selection criteria, all possible values are displayed.  The following example illustrates how valid values with pre-selection works.

You want to inquire into a sales order; however, you do not know the correct sales order number.  When the Sales Order Inquiry Function Select Screen (OP800S01) is displayed, you place the cursor on the sales order number field, press F4, and a pre-selection window is displayed.

 

WILLIAMS                      SALES ORDER INQUIRY                      2/12/93

 .-------------------------------------------------------------------------. CT

 |                    SALES ORDER LIST CRITERIA SELECT                     |   

 |                                                                         |   

 | Bill-to Customer                      Co/Loc                            |   

 |                                                                         |   

 | Ship-to Customer                      Part Number                       |   

 |                                                                         |   

 | Selling Co/Whse                       Order Date                        |   

 |                                                                         |   

 | Promised Ship Date                    Order Status                      |   

 |                                                                         |   

 | Order Type                            Hold Code                         |   

 |                                                                         |   

 | Configuration Code                                                      |   

 |                                                                         |   

 | F3=Exit             F4=Prompt           F23=Cfg Template                |   

 |                                                                         |   

 '-------------------------------------------------------------------------'   

     Order Type                        Line Status                             

                                                                               

 F2=Command          F3=Exit             F4=Prompt           F9=Maintenance    

 F15=Rekey Data      F23=Cfg Template                                          

                                                                               

                 A Valid Values Pre-Selection Window.

The Sales Order List Criteria Select Screen (OP100W01) displays eleven enterable fields.  You may enter data into any, all, or none of these fields to use as selection criteria for the sales order number valid values list.  In this case, you must enter either the bill-to customer or the part number.  However, in some pre-select screens all of the fields are optional.  Because you would like to limit the list further to a specific customer, you decide to enter a customer number.  However, you do not know any valid customer numbers, so you enter information in the Company and Location fields, place the cursor on the Bill-to Customer field of the pre-selection window and press F4 to obtain a list of valid customers.

 

WILLIAMS                      SALES ORDER INQUIRY                      2/12/93

                                                                             CT

 .-------------------------------------------------------------------------. CT

 |                    SALES ORDER LIST CRITERIA SELECT                     |   

  .-------------------------------------------------------------------------.  

  |                      BILL-TO CUSTOMER NUMBER LIST                       |  

  |                                                                         |  

  |                              Position to                                |  

  |                                                                         |  

  |   Bill-to Cust   Cust Name                      Curr Cntry St Zip Code  |  

  | X AC-CHICAGO     ANDERSEN CONSULTING - CHICAGO  USD   USA               |  

  |   69 WEST WASHINGTON STREET            CHICAGO, ILLINOIS                |  

  |   JEWELRY        JEWELS AND GEMS                USD   USA  IL 60600     |  

  |   2 JEWEL STREET                       SUITE 2                          |  

  |   MABCHI         MAB'S AMERICAN CUSTOMER        USD   USA  IL 60606     |  

  |   200 ARIZONA LANE                                                      |  

  |   RSCUST01       CUSTOMER 1 - REMOTE WAREHOUSE  USD   USA  IL 60602     |  

  |   1 WEST WASHINGTON                                                     |  

  |   RSCUST02       CUSTOMER 2 - REMOTE WAREHOUSE  USD   USA  IL 60602     |  

  |   2 WEST WASHINGTON                                                     | +

  | D - Detail                                                              |  

  | F3=Exit              F8=Sort              F21=Save                      |  

  |                                                                         |  

  '-------------------------------------------------------------------------'  

                                                                               

                                                                               

          The Bill-to Customer Valid Values Window After Pre-Selection.

 

As you can see, another valid values window is displayed and you select a customer to return to the Sales Order List Criteria Select Screen.  You also want to select only those orders with an order type of B, C, F, or G.  So, you enter these four values into the Order Type field (some pre-selection fields allow you to enter more than one value at one time).

 

WILLIAMS                      SALES ORDER INQUIRY                      2/12/93

                                                                             CT

 .-------------------------------------------------------------------------. CT

 |                    SALES ORDER LIST CRITERIA SELECT                     |   

 |                                                                         |   

 | Bill-to Customer     AC-CHICAGO       Co/Loc           001 CHI          |   

 |                                                                         |   

 | Ship-to Customer                      Part Number                       |   

 |                                                                         |   

 | Selling Co/Whse                       Order Date                        |   

 |                                                                         |   

 | Promised Ship Date                    Order Status                      |   

 |                                                                         |   

 | Order Type           B C F G          Hold Code                         |   

 |                                                                         |   

 | Configuration Code                                                      |   

 |                                                                         |   

 | F3=Exit             F4=Prompt           F23=Cfg Template                |   

 |                                                                         |   

 '-------------------------------------------------------------------------'   

     Order Type                        Line Status                             

                                                                               

 F2=Command          F3=Exit             F4=Prompt           F9=Maintenance    

 F15=Rekey Data      F23=Cfg Template                                          

                                                                               

      A Pre-Selection Valid Values Window that Allows you to Enter more than 1

              Selection Criteria at a Time.

 

The selection window now contains values in four different fields that will be used as selection criteria for the sales order numbers.  You do not want to specify any more criteria, so you press Enter to display the valid values that match the criteria.

 

WILLIAMS                      SALES ORDER INQUIRY                      2/12/93

                                                                               

 .-------------------------------------------------------------------------.   

 |                            SALES ORDER LIST                             |   

 |                                                  Position to            |   

 |                     Order Hld  Bill To     Ship To                      |   

 |   SO Number Co  Whs Tp St Cde  Customer    Customer   Ord Date Ship Dt  |   

 |   Y00001 00 001 CHI  B  O     AC-CHICAGO  APG-CHICAGO 02/12/93 02/14/93 |   

 |   Y00001 01 001 CHI  G  O     AC-CHICAGO  APG-CHICAGO 02/12/93 02/12/93 |   

 |                                                                         |   

 |                                                                         |   

 |                                                                         |   

 |                                                                         |   

 |                                                                         |   

 |                                                                         |   

 |                                                                         |   

 |                                                                         |   

 | F3=Exit             F10=Selection                                       |   

 |                                                                         |   

 '-------------------------------------------------------------------------'   

     Order Type                        Line Status                             

                                                                               

 F2=Command          F3=Exit             F4=Prompt           F9=Maintenance    

 F15=Rekey Data      F23=Cfg Template                                          

                                                                               

        The Bill-to Valid Values Window after Multiple Pre-Selection Criteria has

             been Entered.

 

The valid values list containing all of the sales orders that match the selection criteria you entered in the pre-select window.  At this point, you may scroll through the list and select an order to return to the select screen, exit without a selection, or return to the select screen to specify new selection criteria.  You notice the sales order number you want to use, and select it with an X in the select field to return it to the select screen.