Support Files: Product, Customer.
Use this file to create price matrices based on selected customer/product combinations. Sales Order Entry references this file when calculating the default selling price of merchandise on an order.
Prices obtained from the pricing hierarchy can affect (and sometimes override) prices generated from the Customer Price Settings.
The price matrix is not designed to work with configured products. The Configurator has its own pricing overrides. However, if you set a configured product to use the product master price as its main price instead of the graded price, then the starting price (prior to any add-ons) would be priced using the price matrix settings.
To set up price matrices, you apply price codes to selected customer/product combinations in your system. Then, when one of the selected customers appears on a sales document and orders one of the selected products, the system references this file and applies pricing to the product based on the calculation you specify here.
When determining whether to apply a customer price matrix calculation, order-entry programs
identify the customer and then reference the code in the Price Category field from the Customer Settings,
identify each product on the order and reference the code in the Price Code field in the Advanced Product Settings for each.
If a Customer Price Settings record exists that includes both of these codes (see the Customer Price Category and Product Price Category fields below), the system applies the price matrix from that record when calculating the default selling price for the order.
Each Price Matrix calculation references the following:
Price Matrix Usage Code field - the formula for the calculation.
Factor field - the user-defined variable used in the formula.
Use Lowest Price field - determines where the system goes to find the base price to use in the calculation.
When applying a price calculation, the system first references the Price Matrix Usage Code field and the Factor field (see below). Each usage code consists of a formula that applies the contents of the Factor field in a different way. For example, one usage code multiplies the factor by the base product price, and another subtracts the factor from the base product price.
To obtain the base product price to use in customer price matrix calculations, the program references the Use Lower Price field in the Customer Price Settings. If the field is
disabled, the program uses the price in the Selling Price field in the Advanced Product Settings for the selected product.
enabled, the program compares the price obtained from the pricing hierarchy with the Selling Price field in the Advanced Product Settings for the selected product and uses the lesser of the two.
If the price returned by a price matrix calculation exceeds the default selling price, the system applies the higher price. If the price returned is lower than the default selling price, the system compares the price with the previous lowest price (for example, a promotional or markdown price) and applies the lowest price found.
