Group Price Matrix

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

This option can be used to build a matrix by Product Group 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 Group for which a matrix setup.

The prompts in the matrix table include:

GROUP

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

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 group, 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 group, 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 is checked before the Class or Global matrix tables are checked.