There are a variety of ways to look up a Part Number, including the following:

Part Number Entry

Preceding Part Number

Last Part Number

Next Part Number

View All Part Numbers

Advanced Search

Manufacturer Code

Manufacturer Listing

Inventory Group Code

Bar Codes

Part Number Entry

Type in the Part Number with the Manufacturer Code first, a <.> (period), the Part Number and then press

<ENTER>.

If the part number is entered without a Mfr. Code (example: 2000), the system will go to the Source Part Number Lookup Screen showing all Part Numbers with that number. Enter the selection number of the part number and press <ENTER>.

Preceding Part Number

To view the preceding Part Number in alphanumeric order, type a <P> at the "Part Number" prompt, press

<ENTER>.

Last Part Number

To retrieve the last Part Number entered, press the <-> and press <ENTER>.

Next Part Number

To retrieve the next Part Number in a list, press the <+> and press <ENTER>. The next Part Number will be displayed.

View All Part Numbers

If you want a list of all Part Numbers, enter a <?>, or part of the part number, and press <ENTER>. A list of all Part Numbers will be displayed.

Use the <PAGE UP> and <PAGE DOWN> keys to scroll through selections. Type in the Selection Number and press <ENTER>.

         

Advanced Search

The Advanced Search allows you to search for a Part Number by part of the Part Number, by the Description, or by the Group Code.

To do an Advanced Search, enter a <?> at the Part Number prompt and press <ENTER>. 

At the "Enter Selection" prompt, press <ENTER>. You will be prompted for Part of Part Number, Part of Description, and Group Code. You may enter any or all of the selections. The more detailed the search, the fewer the items will be displayed.

Enter part of the Part Number and press <ENTER>. 

Enter in the description and press <ENTER>. The more detailed the description, the smaller the search list. You may type part of a word, but the spelling must match. (Example: If you enter DARK MET, the list will contain Dark Metallic but not Dark Green Met…) Remember, a space is considered a character.

Enter the Group Code and press <ENTER>. This will do the group code lookup allowing multiple group codes, ranges, <*> in any position and <#> to exclude group codes.

See Inventory Group Code below for more information on how to enter Group Codes.

A list of Part Numbers will be displayed. Use the <PAGE UP> and <PAGE DOWN> keys to scroll through selections. Once you have located the correct Part Number, enter the Selection Number and press <ENTER>.

Manufacturer Code

If you don't know the Part Number just type in the Manufacturer Code, or <?>, and press <ENTER>. A list of Part Numbers is displayed, starting with the Manufacturer.

Use the <PAGE UP> and <PAGE DOWN> keys to scroll through selections. Type in the Selection Number and press <ENTER>.

Report for entire Manufacturer

When a report prompts for a Starting and Ending Part Number, just enter the Manufacturer Code in both prompts and press <ENTER>.

Manufacturer Sort Code

Manufacturer Sort Codes are setup in "Manufacturer Sort Code Entry" in INVENTORY (5.1.11.3), which are defined by you and used to group Manufacturers into categories. You may have three positions in a Sort Code. It is not necessary to use all three positions.

Example of Manufacturer Sort Codes:

                                                       

The Manufacturer Sort Codes would then be setup as follows:

PDD = Paint Manufacturers who offer Quantity Discounts and Delivers; PDP = Paint Mfrs who offer Quantity Discounts but must be picked up; AND = Adhesive Manufacturers who do not offer discounts but deliver; etc…

Enter in the Sort Code and press <ENTER>. If you do not know the Sort Code, enter a <?> and press <ENTER>. Use the <PAGE UP> and <PAGE DOWN> keys to scroll through the selections, if applicable. Type in the Selection Number, and press <ENTER>.

Pattern Match

You can choose a Sort Code through a Pattern Match using the <*>. Examples of pattern matches are: 12* = all codes starting with 12, *3* = all codes with 3 in the second position, **1 = all codes with 1 in the last position. If a blank is in any position, the system will search for a blank in that position, (ex: 3* = all sort codes with 3 in the first position and nothing in the third position). Type in the Manufacturer Sort Code Pattern Match and press <ENTER>.

If you want a report that lists ALL Sort Codes, enter ***. This will list each Sort Code separately on the report in Alphanumeric order. This feature is only available in Inventory Reports.

Inventory Group Code

Group Codes are setup in INVENTORY (5.1.9), and are used to categorize inventory in any way as defined by you. These codes may be used to limit reports and Customer Special Pricing by Manufacturer line. There are five positions available for the Group Code. It is not necessary to use all five positions.

Example of setting up Group Codes (using PPG):                

                       

                                                                                                       

The Group Codes would then be setup as follows: 

M00 = Mixed Paint, Delstar with No Suffix; M01 = Mixed Paint, Delstar with SC Suffix, etc...; F00 = Factory Pack, Delstar with No Suffix, etc..., S = Staples.

You may then look up any level by using the pattern match.

Enter in the Group Code and press <ENTER>. If you do not know the Group Code, enter a <?> and press <ENTER>. Use the <PAGE UP> and <PAGE DOWN> keys to scroll through the selections, if applicable. Type in the Selection Number, and press <ENTER>.

Group Code Selection on Reports

You may select with Group Code equal to null. At any Group Code prompt enter #***** (pound sign (shift 3) and 5 asterisks) to select with that Group Code equal to null. The way to select Group Code NOT equal to null is ***** (5 asterisks).

The Group Code Selection Criteria accepts multiple group codes, ranges and group codes not equal to a group code or range. The following help will appear for all Group Code prompts:

* Press <ENTER> for ALL Group Codes. Enter <?> for Group Code Lookup.

* Enter multiple Group Codes and Ranges (A05-A99) separated by a comma. Prefix with a <#> to exclude Groups Codes (ex. A01, A02, A05-A99, #A12, #A15-A20).

* Enter an asterisk <*> for pattern matching (ex. 12* will select group codes starting with 12) (<*> will not work in Ranges).

There are a total of five separate and independent Group Codes. The Group Codes have the same functionality as the original Group Code (referred to as Group Code 1). If items exist in the additional Group Code files, Group Code prompts will open up automatically to accept the Group Codes. If additional group codes are entered the screen will display each group code prefixed with <G> and the group code number.

The four additional Group Codes are primarily available in Inventory but also in a few other select parts of the system. For example, the "Sales Analysis Reports" in SALES MANAGEMENT (2.1), only accept Group Code 1 for reporting.

Pattern Match

You can select Group Codes with pattern matching using the asterisk <*>.

Examples of pattern matches are:

12*** = all codes starting with 12, *3*** = all codes with 3 in the second position, ****1 = all codes with 1 in the last position.

If a blank is in any position, the system will search for a blank in that position, (ex: 3*** = all group codes with 3 in the first position and nothing in the last position). Type in the Inventory Group Code Pattern Match and press <ENTER>.

If you want a report that lists ALL Group Codes, enter *****. This will list each Group Code separately on the report in Alphanumeric order. This feature is only available in Inventory Reports.

Bar Codes

Anywhere you enter a Part Number, and have Bar Codes setup for the Part Numbers, you may use a bar code reader.

Please refer to "Bar Code Entry" in INVENTORY (5.1.8.1) for detailed instructions.