Price Matrix: Calculate and Activate the Prices

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

How you do that depends on the type of matrix prices you have set up in the Price Matrix window (MPM). If the price matrix type is:

Updating * (asterisk) Type Matrix Prices

  1. Display the Inventory Maintenance window.

  2. Display the item.

  3. Click the Pricing tab. In the Pricing column, click the matrix price that applies to this item. Type the price and press Enter.

  4. Click Change.

  5. Repeat steps 2 through 4 for each item that has a product code with an * (asterisk) type matrix price.

  6. After you've coded and activated all matrix prices, the next thing to do is code the customer accounts. Click here to go to that topic.

Updating + (plus) Type and $ (dollar) Type Matrix Prices

Run the Price Change report (RPC) to first calculate the matrix prices and then run the RPC report again to add the prices to the items in Inventory Maintenance.

  1. Display the Price Change report. From the Eagle Browser, click Applications and then click Report Menu. Click Inventory Reports and then click Price Changes (RPC).

  2. In the Print Setup window, fill in your choices and then click Options.

  3. From the Options window, select the following:

  1. Click From / To. In this window, enter your selections for this report. Normally, you would leave the From/To range blank so that all matrix prices are updated.

  2. Click PC Option 4. In this window, specify a date effective. If you are updating + (plus) type matrix prices, type Y and select a matrix cost to use.

  3. Click Run. The report processes and calculates the matrix prices. Review the report to verify that the prices are what you expected. You can also review the prices in the Item Price Changes window.

  4. Display the Price Change report. From the Eagle Browser, click Applications and then click Report Menu. Click Inventory Reports and then click Price Changes (RPC).

  5. In the Print Setup window, fill in your choices and then click Options.

  6. From the Options window, select F from the Options list to update inventory prices.

  7. Click From / To. In this window, enter your selections for this report. Use the same From / To range you used in the previous RPC report.

  8. Click Run. The report processes and updates the matrix prices for the items in Inventory Maintenance.

  9. After you've coded and activated all matrix prices, the next thing to do is code the customer accounts. Click here to go to that topic.