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

Parameters |
Product Line: Soap Dispensers Vendor: Distributor Corp of NE |
Formula |
![]() |
Example |
![]() |

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.
|

Parameters |
Price Group: Test Vendor: Vision Technologies |
Formula |
|

Parameters |
Buying Line: Sweet Paper Vendor: Leonard Paper Company |
Formula |
![]() |