In the Price Matrix screen of the system, you will notice that there are levels assigned to each possible price matrix combination. When more than one price combination is entered in the system, these levels will determine which price is used by choosing the combination with the higher priority level.
There are 28 levels, set by the system, displaying all of the possible Price Matrix combinations. These levels cannot be edited. You can view them through the system by clicking on the Levels button at the bottom of the Price Matrix screen. The system will use the price with the highest priority level when multiple price formulas apply.
In looking at the list to the right, you will notice that some combinations involve three or four elements. For example, level number 21 combines , , and . This matrix will apply to customers in the selected when they order a product that belongs to both the selected and .
The use of these levels will depend upon how your pricing structure is organized. For example, if you do not use then you will not need to create price formulas involving . However, the option to create these groups will still exist, and they will still be listed as a level.
To give an example, let's say that a customer is ordering a pencil, which is part of your Office Supplies product line. In your system, there is a price matrix set to give this customer a price that is 10% less than the list price for all products that belong to the Office Supplies product line. This price combination has a level of 09 because the price setting applies to one customer for one product line.
However, there is another price matrix set to give this customer a price that is 20% less than the list price for the specific pencil product that you are selling in this sales order. This price combination has a level of 06 because the price setting applies to one customer for one product. Because the Customer/Product combination has a higher priority level, this price will be used for the sales order.
|