Give your sales department the tools to succeed in Sales Invoicing! Provide better customer service, sell more and process orders faster, when you can press F2 Lookup and see up to the minute information on current stock availability, quantity reserved for pending orders, amount on open purchase orders not yet received, reorder date, alternate item numbers or vendors, and much more!

Choose the exact information you want to see (from over 60 fields) when you press F2 to lookup an inventory item. With IEL - Expanded Item Lookup, you can create up to 9 different lookup formats, each displaying different information. These powerful tools work in Sales Invoicing, Inventory and Purchase Order, anywhere you can press F2 to lookup an inventory item!

After installing enhanced lookups, you must run a new program, Rebuild Keys, before the new lookup will display. This process creates special auxiliary files that contain record pointers to different fields in your Inventory files. Rebuild Keys will sort the record pointers by Dept and Item Number, or by other selected fields if you have additional lookup enhancements.

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 L - 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                |               |
|                 |  L - Set Lookup Display Formats  |               |
|                 +==================================+               |
+--------------------------------------------------------------------+

If you have enhancement ICK - Enhanced Inventory Lookups, you will have another option, Set Key Code Formats. For more information on this program option, see documentation for ICK - Enhanced Inventory Lookups. 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 running Rebuild Keys, expanded lookups must be created with Set Lookup Display Formats. After selecting L - Set Lookup Display Formats from the Lookup Options Menu, the program will prompt you for a Lookup Code. Press F2 Lookup for a list of available Lookup Codes. Select User Defined Lookup 1, and the following screen will display:

+------------------------------------------------------------------------+
|+======================================================================+|
||INMAINT2             Maintain Inventory Options      COMPANY ID: SP   ||
||12/29/92            Software Professionals, Inc.     GENERATION #: 12 ||
|+======================================================================+|
| Lookup Code.....: 1                                                    |
| Menu Hot Key....: 1                                Maximum Width:   75 |
| Menu Description: User Defined Lookup 1            Current Width:    0 |
| Menu Sequence...: 10                               Available....:   75 |
| Sort Group......: 1                                                    |
|                                                                        |
| Field  Start   Width  Decimal Places   Title                           |
|                                                                        |
|                                                                        |
|                                                                        |
|                                                                        |
|                                                                        |
| Accept (Y/N) Y                                                         |
|                                             F8 - Undo                  |
+------------------------------------------------------------------------+

The following page will explain each option on the above screen and show how to setup an expanded lookup displaying various fields. After creating this example, you should be familiar enough with the options available, to create the expanded lookups you desire.

Menu Hot Key - This is the letter or number which will represent this lookup format whenever F2 Lookup is used for an inventory item, and more than one lookup display format is available. The default Hot Key is the same as the Lookup Code, but can be changed to almost any letter or number. If the same letter or number is used for more than one format option, the first option on the menu will be selected. For simplicity, leave this value at the default setting.

Menu Description - This is the title that will appear in the Lookup Options menu, next to the Menu Hot Key. Edit the description to convey to the operator what will be displayed in the lookup box if this option is selected. For this example, enter a Menu Description of "Expanded Sales Lookup".

Menu Sequence - This field is used to prioritize your lookup formats. You should enter number 1 for the lookup format which will be used most often, number 2 for second most used format, etc. If you do not want a lookup format to be displayed, enter zero for Menu Sequence to inactivate this option. For this example, enter 1 for menu sequence.

Sort Group - Specifies how to lookup items in inventory. Normally, this value will set to "P", which uses the Standard Peachtree sort group that looks up inventory items by Department and Item Number. For this example, change the value from 1 to P.

Note: If you have additional Lookup enhancements, you may be able to use pre-defined Sort Groups D to lookup by Description, V to lookup by Vendor, I to lookup by Vendor Item# or N to lookup by Item Number. If you have enhancement ICK - Enhanced Inventory Lookups, you can create custom sort groups to lookup items by any alphanumeric field in inventory. If you enter an invalid Sort Group, an error message box will display valid options. For more details on Sort Groups, see documentation for ICK - Enhanced Inventory Lookups.

+------------------------------------------------------------------------+
| Lookup Code.....: 1                                                    |
| Menu Hot Key....: 1                                Maximum Width:   75 |
| Menu Description: Expanded Sales Lookup            Current Width:    0 |
| Menu Sequence...: 01                               Available....:   75 |
| Sort Group......: P                                                    |
+------------------------------------------------------------------------+

Field - Up to 12 different fields may be selected for each lookup format. The lookup is limited to a maximum width of 75 characters. In the upper right corner of the screen, the Maximum Width is displayed, along with the Current Width of the fields selected, and the spaces Available. After each field is selected, the Current Width and Available is updated.

F2 Lookup will list the fields available, plus the default field size, number of decimals (if numeric) and field title. Select the fields by highlighting the desired field and pressing return, or by typing in the 2 digit code.

For this example, enter the following fields shown below. To allow all of the fields specified to display, change the Start, Width and Decimal values to equal those in the example:

+------------------------------------------------------------------------+
| Field  Start   Width  Decimal Places   Title                           |
| DP     001      03          02         Dep                             |
| IT     001      12                     Item Number                     |
| DE     001      16                     Description                     |
| A               07          02         Price A                         |
| LC              07          02         Cost                            |
| VE     001      06                     VendID                          |
| OH              05          00         OnHnd                           |
| PN              05          00         Pend                            |
| AV              05          00         Avail                           |
+------------------------------------------------------------------------+

Start - Normally this value should be 001. You can enter a value greater than 1 if you do not want to display the first characters of a field. This option only applies to alphanumeric fields, the amount of spaces shown for numeric fields are controlled by Width and Decimal.

Width - This value will default to the maximum width for the selected field. If you change the Start value, this field will reflect the number of spaces left to display. If the field is a text field and the width is less than the field size, the right most characters of the field will be suppressed. If the field is numeric and the width is less than the value of a field, the lookup box will display asterisks.

Decimal - If the field is numeric, this value will default to the number of decimal places this field allows. You can change this value to less than the default to suppress decimal places not used. If a field uses decimals that exceed the number set here, asterisks will display in the lookup box.

Title - This title appears at the top of the lookup box above the fields selected. The maximum width of the title is the same as the Width set for this field. If you enter a title that is longer than the Width, it will be truncated.

To save the Expanded Sales Lookup just created, press F10 Done and answer Y to the Accept prompt. After accepting the screen, the program will compile the lookup display created. Press F10 - Done to return to the Lookup Options menu, then press F10 again to return to the Program Options screen for Maintain Inventory Items, or Shift F10 to return to the Main Menu in Peachtree.

After creating the above Expanded Sales Lookup, whenever F2 Lookup is pressed at the Department or Dept/Item Number field, the following menu option will appear:

+=======  LOOKUP ITEM BY  ========+
|  1 - Expanded Sales Lookup      |
|  P - Peachtree Standard Lookup  |
+=================================+

Type "1" to select Expanded Sales Lookup, or press enter with the option highlighted. If you have created other expanded lookup displays, or have additional Lookup Enhancements, they will also appear on this menu. If Expanded Sales Lookup is selected, you will be prompted for a Starting Key.

If a starting key of CLC was entered, the following lookup might display:

+=======================  SELECT INVENTORY ITEM  ==========================+
|                                                                          |
| Dep Item      Description      Price A    Cost VendID OnHnd  Pend Avail  |
+==========================================================================+
| CLC 436781G   GIRL'S BLUEJEANS   10.99    5.45 NUMCO     10     5     5  |
| CLC 463444    CHILDREN'S SOCKS    1.25    0.69 SACKS     21     0    21  |
| CLC 463487G   GIRL'S PRINT DRE   10.99    5.25 NUMCO     14    10     4  |
| CLC 463781    BOY'S BLUEJEANS    10.99    5.75 NUMCO     -7     2    -9  |
| CLM 113908    SILK SOCKS          7.98    3.60 SACKS     20     0    20  |
| CLM 425208    SOLID DRESS SHIR   23.50    0.00 BRATCH    10     2     8  |
| CLM 425308    STRIPED DRESS SH   23.50    8.88 BRATCH    23     1    22  |
| CLM 819608    SILK DESIGNER TI   12.50    0.00 NUMCO     13     0    13  |
| CLM 876264    DESIGNER SLACKS    59.99   22.98 BLASS     11     0    11  |
| CLM 876266    DESIGNER JACKET   139.44    0.00 BLASS      8    -1     9  |
| CLW 910115    LINEN 2-PIECE SU   89.99   55.00 DIOR      11     0    11  |
| CLW 910458    FLORAL PRINT DRE   29.99    0.00 STEWRT     8     0     8  |
| CLW 910535    SILK BLOUSE        37.50    0.00 GVANNI    19     0    19  |
+==========================================================================+