Price Matrix: Code the Items

Once you have defined your customer groups (click here if you haven't) and defined the product codes in the Price Matrix Maintenance window (click here if you haven't), the next thing to do is code the items in Inventory Maintenance.

Use the Product Code field, found on the Codes tab of Inventory Maintenance, to indicate the product code from the Price Matrix window that applies to the item.

You can update the Product Code field one item at a time in Inventory Maintenance. Or, you can update a range of items using the Item Code Update Report (RICU).

Coding Individual Items in Inventory Maintenance

Use this procedure to code items one at a time in Inventory Maintenance.

1. Display the Inventory Maintenance window.

2. Display the item.

3. Click the Codes tab. At Product Code, type the product code (from the Price Matrix window) that applies to this item.

4. Click Change.

Multistore: The Product Code field is Master Data, the product code you enter applies to all stores.

5. Repeat steps 2 through 4 for each item you need to code.

6. After coding the items (either individually in Inventory Maintenance or using RICU), the next thing to do is calculate and activate the price matrix prices. Click here to go to that topic.

Coding a Range of Items Using RICU

Use the Item Code Update Report (RICU) to update the Product Code field in Inventory Maintenance for a range of items. For example, in your Paint department you have a specific class of items to which you want to assign the same product code.

RICU is a powerful function. You can use it to quickly and easily, and sometimes incorrectly, update fields in Inventory Maintenance for a range of items. Before using RICU, make sure you have a current backup available before you make changes to your Inventory file using RICU.

Complete the following to run RICU to update the Product Code field. For more information about RICU, click here to go the help topic.

1. From the Eagle Browser, click Reports Menu, then Inventory Reports, then Item Code Update Report (RICU).

2. From the   page, review the default entries in the fields and make changes if needed. For a definition of each field, click here.

3. Click . On this page, type the code in the Product Code field that you want to assign to the range of items. This is a product code that you have already defined in the Price Matrix window (MPM). Multistore: The Product Code field is Master Data, the product code you enter applies to all stores.

4. Click . On this page, fill in the from and to ranges to determine the items selected for the report. These are the items that will be updated with the Product Code you entered in the previous step. Review the from / to range you've entered, then set the From/To Range is Correct field to Y (Yes). For a definition of each field on this page, click here.

5. Click . On this page, fill in the desired fields to include or exclude groups of items. For a definition of each field on this page, click here.

6. Click Run. The report processes and the Product Code field is updated for the range of items you specified.

7. After coding the items (either individually in Inventory Maintenance or using RICU), the next thing to do is calculate and activate the price matrix prices. Click here to go to that topic.