Class Price Matrix

** This utility is under development and is not yet available. **

This option can be used to build a matrix by Product Class to identify products that fall into the Re-Order Price range and then to determine the List Price and Markup % to update, based on that Re-Order Price.
This matrix is used only if the product included in the class/group selection range from the update utility Update List Price From Matrix is included in a Class for which a matrix setup and is NOT in a Group for which a matrix is setup in Group List Price Matrix.

The prompts in the matrix table include:

CLASS

Enter the product class for the matrix table list price calculation, or select one from the window.
Matrix tables can be setup individually for any class.

SEQ

The sequence number will automatically keep track of the number of entries in the matrix table.

FROM RE-ORDER PRICE

Set the starting re-order price for the product range in this class, whose list price should be updated by the margin set in this record.

TO RE-ORDER PRICE

Set the ending re-order price for the product range in this class, for this list price update.

MARGIN

Enter the margin to be used to recalculate and update the Markup and the List Price.

MARKUP

The new markup percent displays.

Finished?

Multiple records can be entered in the matrix table.
Press <F3> when the table is complete.

Use Update List Price From Matrix to complete the List Price update in the product file.
Note: This table only applies to products if there is no specific matrix for their Group.