A price matrix is a collection of formulas that calculate the price of a product based on different purchasing scenarios. This topic outlines several possible scenarios you might want to configure. You set purchasing price formulas on the Purchasing Matrix Master. Go to Purchasing > Purchasing Matrix.
Important: The Purchasing Matrix is similar to, but not the same as the sales Price Matrix Master. The Price Matrix defines price formulas for products purchased by your customers: Sales > Pricing > Price Matrix. If you want to set up pricing formulas for customer sales pricing, see Create a price formula in the matrix. The Purchasing Matrix defines price formulas for inventory you purchase from the vendor: Purchasing > Purchasing Matrix.
Tip: To learn how to enter the options here, see What are purchasing matrices? and Advanced price formula options
Scenario 1: Apply a 10% discount to the cost price of Dispensers purchased from Distributor Corp of NE
| Parameters |
Product Line: Soap Dispensers Vendor: Distributor Corp of NE |
| Formula |
|
| Example |
|
Scenario 2: Apply a 20% price break to all brushes purchase by Brushtech when 10 or more are purchased
| Parameters |
Product Line: Brushes Vendor: Brushtech Quantity: 10 |
| Formula |
Note that all price formulas require a formula for one product (Quantity=1) before you can add special pricing for quantities greater than 1. In this scenario, there is no special pricing for 1 unit, so the first line has a Quantity of 1 with a zero amount. Then add a second formula that sets the required minimum Quantity break, and then set the discount amount.
|
Scenario 3: Apply 30% discount to the cost of items in the Test Price Group purchased from the vendor Vision Technologies.
| Parameters |
Price Group: Test Vendor: Vision Technologies |
| Formula |
|
Scenario 4: Apply a .5 multiplier to the cost of items in the Sweet Paper Buy Line when purchased from Leonard Paper Company.
| Parameters |
Buying Line: Sweet Paper Vendor: Leonard Paper Company |
| Formula |
|