- Go to Purchasing > Purchasing Matrix.
- Choose the price formula combination that you want to update or delete by either
- Entering the price combination of
Product
A product's reference code. If you set a price formula by product number, then it is applied only when that product is purchased., Price Group A price group's reference code. If you set a price formula by price group, then it is applied to all products within that price group., Product LineA product line's reference code. If you set a price formula by product line, then it is applied to all products within that product line. , Buy Line The reference code assigned to a Buy Line. A price formula set for a Buy Line applies to all products that belong to that Buy Line., Vendor The name of the vendor associated with the contract. If you choose a vendor, and then click Net Pricing, you will see all products under price contract associated with the vendor, as well as the price contract code. Choose this option to adjust prices and costs on all these products at once. Also used to assign a price formula to all products by a certain vendor.- Or browsing through available formulas. From the Type list, choose Current or Future, and from the Show list, choose Available, Existing, or Expired. If want to narrow the results to one branch, click the magnifying glass in the Branch box and click one.
- Click Search.
Under Purchasing Matrix Results, click the combination you want to update or delete.
- On the Price Formula pop-up that appears, click Edit.
- Enter your formula you want to use for this matrix and then enter your rebate amount as a whole number.
- Save your matrix.
Note: If you update your purchasing rebates, reindex them by navigating to Purchasing> Reindex Purchasing Rebate. Enter the start and end date of invoices that you want the updated purchsaing matrix to recalculate from.