Price Matrix By Group
Overview
A Price Matrix is an opportunity to give an account or multiple accounts discounts on parts they buy. Price Matrixes allow for discounts on Manufacturers (lines of parts), categories of parts, or a combination of both. A Price Matrix By Group is a shared matrix that is created and maintained for a series of similar accounts, allowing a user to create or update a single matrix and apply the changes immediately to multiple customers.
Pricing Example:
A business owner wants to setup a group called Dealers, assigning special pricing to a number of accounts. Most of the accounts were setup with a default pricing level of Jobber price. However, the seller wants to give the accounts a discount on WIX parts, giving them an adjusted price of Cost plus 20% on those items. The price matrix will display as follows:
Step #1: Setup Matrix
Configure the Adjusted Selling Price for Price Matrix By Account table by clicking:
TOOLS | SYSTEM TABLES | PRICE MATRIX BY GROUP
Group Number: Enter an alphanumeric value to assign to each account that will be using the adjusted price. Once this table entry is saved, the alphanumeric Group Number can then be assigned in the Price Matrix Group field in the Accounts Record.
Manufacturer Code: Enter the Manufacturer Code that will be discounted. If the account should receive the discount on all lines, enter *** to include all manufacturers.
Pricing Category 1, 2, 3: Enter the Pricing Category, if applicable. Pricing categories are not required.
Three pricing categories are allowed, in descending order (the 2nd pricing category will need to be within the 1st pricing category, and so on). The pricing categories that will be utilized in the Price Matrix screens will be assigned in Tools/System Setup/XRef Field Setup under Pricing Category 1, 2, and 3. Dependent on the category fields selected, those categories may need to be added to the category code listing under Tools/System Tables/Category Codes.
Price Field: Select the Price Field value to use for the adjusted price calculation.
Note: The Price field value is not applicable when the Price Def Code is set to a fixed value (A) since an actual price value is entered in the Value field and therefore, a calculation is not required.
Price Definition Code: Select $, %, or A (fixed value) to calculate the adjusted selling price.
Value: For $ and %, enter a positive or negative value to adjust the selling price by; for A (fixed value), enter the actual adjusted selling price. The resulting adjusted selling price is based on the Price Definition Code ($, %, A) selected above and the Value entered here.
For example, if the value of 10 is entered, the resulting adjusted selling prices are:
Step #2: Enable part flag in Inventory
Enable the adjusted selling price by setting the Part Discount flag to Yes in the Inventory Record. Access the Inventory Record by clicking on:
FILE | INVENTORY MAINTENANCE | INVENTORY
See also