Do you know who makes the item, but have trouble remembering the department or item number? With ILV - Lookup Inventory By Vendor, just enter the primary Vendor ID and F2 automatically finds and displays all the items for that vendor. In addition to sorting by Vendor ID, this useful tool also displays Description in all Inventory Lookups in Sales Invoicing, Purchase Order and Inventory! This enhancement searches only the Vendor that is displayed on screen in Maintain Inventory Items, it does not search the Alternate Vendors.

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 Vendor Id in Inventory. Rebuild Keys will sort the record pointers by Vendor, so that when the enhanced lookup is used, item numbers supplied by the same vendor will be grouped together, regardless of Department or Item Number.

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 Lookups. After creating special auxiliary files with Rebuild Keys, Lookup Inventory By Vendor 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: =======+
|  V - Lookup By Vendor          |
|  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 BL was entered, the following lookup might display:

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

The Lookup By Vendor box will display all items sorted by Vendor then by Department and 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 customize options to display from over 60 different fields! For more information on this powerful tool, see documentation for IEL - Expanded Inventory Lookup.