Change the pricing or costing of items by editing formulas for individual matrix cells in the Quick Buy Matrix or Quick Sell Matrix.
From the Files > Price Maintenance menu, select Quick Buy Matrix or Quick Sell Matrix to display Sell Matrix Maintenance window or the Quick Sell Matrix Maintenance window.
Enter the required information in the screen to display the list of matrix cells you want to edit.
Place your cursor on the first price formula in the list you want to change.
Select Adjustments > Adjust Formula to display the Quick Sell/Buy Matrix Adjust Formula window.
In the Price or Cost Formulas field, enter the type of formula, either Price or Cost.
In the Adjust Formula Type field, enter one of the following:
Multipliers - Arithmetic expressions, such as addition (+), subtraction (-), multiplication (*), and division (/).
Constants - Dollar values.
Check the Treat Discounts as Multipliers check box to convert the discount formulas (+/-) in the Price Formula field of the Quick Matrix screen to multipliers. The following table shows the result of price formulas changing to multipliers.
|
The price formula... |
changes to... |
|
-10 |
*0.9 |
|
-20 |
*0.8 |
|
+10 |
*1.1 |
|
+200 |
*3.0 |
For example, the discount formula in Quick Sell Matrix Maintenance for a product is -20 (-20 percent). You adjust the formula to Multiply and add the adjustment value 2 in the appropriate fields, below. The system converts the product's formula (-20) to *0.8, then multiplies this new number by 2 to get *1.6. This number is then changed back into the discount formula +60.
In the Adjustment Function field, enter one of the following to change the arithmetic function:
Add
Subtract
Multiply
Divide
In the Adjustment Value field, enter the amount to adjust the multiplier or a constant as follows:
Multiplier - Affects the numeric values in the formula. For example, if the formula is REP-COST x 1.35 and you enter 0.1, the result is the formula REP-COST x 1.45.
Constant - Affects the dollar amounts. For example, enter 0.1 and the system adds ten cents to the price.
Click Adjust. The system prompts to "Load all Cells?" Click one of the following:
Yes - Applies the change to all matrix cells.
No - Applies the changes to the selected matrix cell.
See Also: