Do you have trouble remembering the department or have the same item number in different departments? With ILN - Lookup Inventory By Item Number, just enter the Item Number and F2 automatically finds and displays the item in all departments. In addition to sorting by Item Number, this useful tool also displays Description in all Inventory Lookups in Sales Invoicing, Purchase Order and Inventory!

Before the new enhanced lookup will display a new option, Rebuild Keys, must be run. This process creates special auxiliary files that contain record pointers to your Item Number in Inventory. Rebuild Keys will sort the record pointers by Item Number, so that when the enhanced lookup is used, item numbers starting with the same characters will be grouped together, regardless of Department.

To run Rebuild Keys, select Maintain Inventory Options from the Maintenance programs for Inventory, then select L - Set Lookup Options:

+--------------------------------------------------------------------+
|+==================================================================+|
||INMAINT2         Maintain Inventory Options      COMPANY ID: SP   ||
||10/21/92         Software Professionals Inc.     GENERATION #: 62 ||
|+==================================================================+|
|                                                                    |
|           +=========== Program Options ===========+                |
|           |  O - Set Module Options               |                |
|           |  P - Set Printer Assignments          |                |
|           |  L - Set Lookup Options               |                |
|           +=======================================+                |
+--------------------------------------------------------------------+

After selecting Set Lookup Options, the following screen will display:

+--------------------------------------------------------------------+
|+==================================================================+|
||INMAINT2             Set Lookup Options          COMPANY ID: SP   ||
||10/21/92         Software Professionals Inc.     GENERATION #: 62 ||
|+==================================================================+|
|                                                                    |
|                 +======== Lookup Options ==========+               |
|                 |  R - Rebuild Keys                |               |
|                 +==================================+               |
+--------------------------------------------------------------------+

Rebuild Keys will normally only be run when first installing the enhancement. The amount of time required for this process varies depending on the size of your inventory files and your hardware/software configuration. For other cases when this option must be executed, see documentation for ICK - Enhanced Inventory Lookup. After creating special auxiliary files with Rebuild Keys, Lookup Inventory By Item Number will be available whenever F2 Lookup is used for an Inventory Item.

When F2 Lookup is pressed Department or Department/Item Number field, the following menu will appear:

+=======  LOOKUP ITEM BY: =======+
|  N - Lookup By Item Number     |
|  P - Peachtree Default Lookup  |
+================================+

If you have other Lookup Enhancements, they will also be shown on the above menu. If Lookup by Description is selected, you will be prompted for the Starting Key. If a starting key of 0900 was entered, the following lookup might display:

  +=========  SELECT INVENTORY ITEM  =========+
  | Item            Dep  Description          |
  +===========================================+
  | 0900120REF    - AAA  COMMERCIAL REFRIGER. |
  | 0900120REF    - BBB  COMMERCIAL REFRIGER. |
  | 0900120REF    - DDD  COMMERCIAL REFRIGER. |
  | 1200040DIS    - CCC  DISHWASHER           |
  | 1100102MOV    - AAA  MICROWAVE OVEN       |
  | 1100101OVE    - BBB  OVEN, COMMERCIAL     |
  | 10040TRA      - AAA  SUPERTRASH COMPACTOR |
  | 1400040TRA    - AAA  TRASH COMPACTOR      |
  +===========================================+

The Lookup By Item Number box will display all items sorted by Item Number, starting with the entry you have made, or at the beginning of the file if the starting key is left blank.

For even more dynamic Lookup boxes for Inventory, IEL - Expanded Inventory Lookup can be combined with this enhancement to customize your F2 item lookup to sort and display exactly the information you need to see! Great for checking available quantity, current cost, or finding stock from specific vendors! You can customize options to display from over 60 different fields! For more information on this powerful tool, see documentation for IEL - Expanded Inventory Lookup.