Price Matrix By Account
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 Account is a unique matrix for a single account, which allows for unlimited personalized discounting.
Pricing Example:
Account #100 was setup with a default pricing level of Jobber price. However, the seller wants to give the account 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 ACCOUNT
Account Number: Enter the account number using the adjusted price.
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