How Multi-Level Lookup Function Work
To illustrate the power of multiple level lookups, let's go into the Receiving Entry program

In the Receiving Entry, with the cursor on RECV NO field, Press F9 to bring up the Receiving Lookup Screen

 F1=NEW RECEIVING F4=EXIT sF9=DET
+------------------------------------------------------------------------------+
| RECV NO: _______                           *** [SSI] RECEIVING ENTRY ***     |
+----------------------------------------------------------------------[help]--+
|   INV #:          SUP. INV:             PO #:           PO REF#:             |
|   SUPLR:      /                                    PRINT--> RCV:   DMG:      |
|  PURCHR:    /                                     CI NO:                     |
|     LOC:    /                                 RECV DATE:                     |
|  REC BY:    /                                  REC DATE:                     |
|  CHK BY:    /                                  CHK DATE:                     |
+------------------------------------------------------------------------------+
     ITEM NUMBER  VARI SIZE UOM F    ORD UOM    RCV UOM BIN #    DMG UOM I










Enter Receiving Number

This is the Receiving Entry Lookup Screen Position the Cursor to the PO # field Press F9 to bring up the Purchase Order Lookup Screen

 F1=NEW RECEIVING F4=EXIT sF9=DET
+--+--LOOKUP------------------------------------------------------------------+
| R| F1=SELECT F2=DESCEND F4=CANCEL                                           |
+--|--------------------------------------------------------------------------|
|  |                   *** [SSI] RECEIVING ENTRY LOOKUP ***                   |
|  | RECV #  RECV DATE     PO # PO REF #   INVOICE SUPLR-INV# R D CHKINS# STS |
|  |--------------------------------------------------------------------------|
|  |                    _______                                               |
|  |                                                                          |
|  |                                                                          |
+--|                                                                          |
   |                                                                          
   |                                                                          
   |                                                                          
   |                                                                          
   |                                                                          
   |                                                                          
   |     +-------------------------------------------------------------+      
   |     | SUPLR PUR LOC RBY RECV DATE  CBY CHK DATE    ADD BY         |      
   |     |                                                             |      
   |     +-------------------------------------------------------------+      
   |Enter Purchase Order Number                                               
   |                                                                          
   +--------------------------------------------------------------------------

This is the Purchase Order Lookup Screen Move the cursor to the Supplier Code field and Press F9 to bring up the Supplier Lookup Screen

 F1=NEW RECEIVING F4=EXIT sF9=DET
+-+--LOOKUP--------------------------------------------------------------------+
| | F1=SELECT F2=DESCEND F4=CANCEL                                             |
+-|----------------------------------------------------------------------------+
| |                     *** [SSI] PURCHASE ORDER LOOKUP ***                    |
| |    PO # MAN PO#    SUPLR PUR PO DATE    DELIVB4    T P C     TOTAL-AMT STS |
| |----------------------------------------------------------------------------+
| |                    _____                                                   |
| |                                                                            |
| |                                                                            |
+-|                                                                            |
  |                                                                            |
  |                                                                            |
  |                                                                            |
  |                                                                            |
  |                                                                            |
  |                                                                            |
  |----------------------------------------------------------------------------+
  | SL ISU PAY DLV QI  HDSC% HDSC-AMT  TR DAY TRM %     MERCH-AMT     DISC-AMT |
  |                                                                            |
  |----------------------------------------------------------------------------+
  |Enter Supplier Code                                                         |
  |                                                                            |
  +----------------------------------------------------------------------------+

Move the cursor to the Supplier Name column and enter "ACME*" to brin up all supplier names that stats with "ACME". Press F1 to execute th query

 F1=NEW RECEIVING F4=EXIT sF9=DET
++--LOOKUP-------------------------------------------------------------------+-
|| F1=SELECT F2=DESCEND F3=MAINTENANCE  F4=CANCEL                            | 
+|---------------------------------------------------------------------------|-
||                       *** [SSI]  SUPPLIER LOOKUP ***                      | 
|| SUPL# SUPPLIER NAME             T A RSN DISC-COMMAND STRING DISC%    DISC$| 
||---------------------------------------------------------------------------|-
||       ACME*                                                               | 
||                                                                           | 
||                                                                           | 
+|                                                                           | 
 |                                                                           | 
 |                                                                           | 
 |                                                                           | 
 |                                                                           | 
 |                                                                           | 
 |                                                                           | 
 |                                                                           |-
 |                                                                           | 
 |                                                                           | 
 |                                                                           |-
 |Enter Supplier Name                                                        | 
 |                                                                           | 
 +---------------------------------------------------------------------------+-

The system brough up 3 rows matching your query. Select the first one by pressing RETURN or Function Key 1

 F1=NEW RECEIVING F4=EXIT sF9=DET
++--LOOKUP-------------------------------------------------------------------+-
|| F1=SELECT F3=ANOTHER SET F4=CANCEL                                        | 
+|---------------------------------------------------------------------------|-
||                       *** [SSI]  SUPPLIER LOOKUP ***                      | 
|| SUPL# SUPPLIER NAME             T A RSN DISC-COMMAND STRING DISC%    DISC$| 
||---------------------------------------------------------------------------|-
||[05899]ACME CORPORATION          R Y                          0.00     0.00| 
|| 06349 ACMETECH CORPORATION      R Y                          0.00     0.00| 
|| 05147 ACMETRADE MFG             R Y                          0.00     0.00| 
+|                                                                           | 
 |                                                                           | 
 |                                                                           | 
 |                                                                           | 
 |                                                                           | 
 |                                                                           | 
 |                                                                           | 
 |                                                                           |-
 |                                                                           | 
 |                                                                           | 
 |                                                                           |-
 |                                                                           | 
 |                                                                           | 
 +---------------------------------------------------------------------------+-

The supplier code for ACME Corporation is automatically filled i by the supplier lookup screen. Press Function Key 2 to select all Purchas Order for supplier code: 05899 in descending order

F1=NEW RECEIVING F4=EXIT sF9=DET +-+--LOOKUP-------------------------------------------------------------------- | | F1=SELECT F2=DESCEND F4=CANCEL +-|---------------------------------------------------------------------------- | | *** [SSI] PURCHASE ORDER LOOKUP *** | | PO # MAN PO# SUPLR PUR PO DATE DELIVB4 T P C TOTAL-AMT STS | |---------------------------------------------------------------------------- | | 05899 | | | | +-| | | | | | | |---------------------------------------------------------------------------- | SL ISU PAY DLV QI HDSC% HDSC-AMT TR DAY TRM % MERCH-AMT DISC-AMT | |---------------------------------------------------------------------------- |Enter Supplier Code | +----------------------------------------------------------------------------

This is the results of the lookup

 F1=NEW RECEIVING F4=EXIT sF9=DET
+-+--LOOKUP--------------------------------------------------------------------
| | F1=SELECT F3=ANOTHER SET F4=CANCEL                                         
+-|----------------------------------------------------------------------------
| |                     *** [SSI] PURCHASE ORDER LOOKUP ***                    
| |    PO # MAN PO#    SUPLR PUR PO DATE    DELIVB4    T P C     TOTAL-AMT STS 
| |----------------------------------------------------------------------------
| |   14415            05899 JLA 02/13/2002            R Y N      1,897.00 OPN 
| |   14414            05899 LTC 02/13/2002            R Y N      7,455.70 OPN 
| |   14410            05899 JLA 02/13/2002            R Y N      3,693.80 OPN 
+-|   14406            05899 LTC 02/12/2002            R Y N     12,354.36 OPN 
  |   14405            05899 RSA 02/11/2002            R Y N      8,407.80 BKO 
  |   14399            05899 RSA 02/11/2002            R Y N     41,296.00 BKO 
  |[  14398 3750       05899 JRC 02/07/2002            R Y N      2,520.00 CLS]
  |   14396            05899 RSA 01/06/2002            R Y N      5,832.00 CLS 
  |   14395            05899 RSA 01/02/2002            R Y N      8,723.70 CLS 
  |   14394            05899 RSA 01/02/2002            R Y N      7,816.50 CLS 
  |----------------------------------------------------------------------------
  | SL ISU PAY DLV QI  HDSC% HDSC-AMT  TR DAY TRM %     MERCH-AMT     DISC-AMT 
  |    ZAM ZAM SSI SSI  0.00     0.00       0  0.00      1,897.00         0.00 
  |----------------------------------------------------------------------------
  |                                                                            
  |                                                                            
  +----------------------------------------------------------------------------

Use the Down Arrow key to position the cursor to PO Number: 14398 the press RETURN or Function Key 1 to Select It. This fill in PO Number 1439 into the PO Number column

F1=NEW RECEIVING F4=EXIT sF9=DET +--+--LOOKUP------------------------------------------------------------------+ | R| F1=SELECT F2=DESCEND F4=CANCEL | +--|--------------------------------------------------------------------------| | | *** [SSI] RECEIVING ENTRY LOOKUP *** | | | RECV # RECV DATE PO # PO REF # INVOICE SUPLR-INV# R D CHKINS# STS | | |--------------------------------------------------------------------------| | | 14398 | | | | | | | +--| | | | | | | | | +-------------------------------------------------------------+ | | SUPLR PUR LOC RBY RECV DATE CBY CHK DATE ADD BY | | | | | +-------------------------------------------------------------+ |Enter Purchase Order Number | +--------------------------------------------------------------------------

Press F1 to execute the loop which selects ALL Receiving Entires for Purchase Order Number: 14398

 F1=NEW RECEIVING F4=EXIT sF9=DET
+--+--LOOKUP------------------------------------------------------------------+
| R| F1=SELECT F3=ANOTHER SET F4=CANCEL                                       |
+--|--------------------------------------------------------------------------|
|  |                   *** [SSI] RECEIVING ENTRY LOOKUP ***                   |
|  | RECV #  RECV DATE     PO # PO REF #   INVOICE SUPLR-INV# R D CHKINS# STS |
|  |--------------------------------------------------------------------------|
|  |[  22505 02/12/2002   14398 3750         22466 5323       N Y   15763 RCV]|
|  |                                                                          |
|  |                                                                          |
+--|                                                                          |
   |                                                                          
   |                                                                          
   |                                                                          
   |                                                                          
   |                                                                          
   |                                                                          
   |     +-------------------------------------------------------------+      
   |     | SUPLR PUR LOC RBY RECV DATE  CBY CHK DATE    ADD BY         |      
   |     | 05899 JRC RCV STL 02/12/2002 STL 02/12/2002  sam            |      
   |     +-------------------------------------------------------------+      
   |                                                                          
   |                                                                          
   +--------------------------------------------------------------------------

Press F1 to select Receiving Number: 22505 into the Receiving Entry screen

 F1=DETAIL F4=NEXT RECEIVING F6=EDI
+------------------------------------------------------------------------------
| RECV NO:   22505                           *** [SSI] RECEIVING ENTRY ***     
+----------------------------------------------------------------------[help]--
|   INV #:   22466  SUP. INV: 5323        PO #:   14398   PO REF#: 3750        
|   SUPLR: 05899/ACME CORPORATION                    PRINT--> RCV: N DMG: Y    
|  PURCHR: JRC/JOHN R. CRUZ                         CI NO:    15763            
|     LOC: RCV/RECEIVING DEPARTMENT             RECV DATE: 02/12/2002          
|  REC BY: STL/SAM T. LEE                        REC DATE: 02/12/2002          
|  CHK BY: STL/SAM T. LEE                        CHK DATE: 02/12/2002          
+------------------------------------------------------------------------------
     ITEM NUMBER  VARI SIZE UOM F    ORD UOM    RCV UOM BIN #    DMG UOM 
     CT931        ASST NS   PC  N ****** ***   1400 PC             0 PC  






Voila! You got the receiving record you are looking for


Last Update Sun Mar 24 17:34:27 HKT 200