Example - discount for large orders
In this example, you will define the following discounts:
2% for orders >= 50,000 and < 100,000
3% for orders >= 100,000 and < 250,000
4% for orders >= 250,000
-
In the Select Adjustment Type screen, type Large Order Discount.
-
Under Adjustment Type select Advanced.
-
Clear Include preceding adjustments...
-
Clear Allow succeeding adjustments...
-
Click Next.
-
In the Advanced Adjustment Details screen, select Credit.
-
Under Adjustment Conditions, select the following information:
The order of conditions is important as they are evaluated from top to bottom. The first condition that matches will determine the calculation used. -
Under Add or Subtract Adjustment's Value to these Columns check Sell.
-
Click Next.
-
In the Price Adjustment Criteria screen, simply leave this screen blank.
-
Click Finish.
At the bottom of your worksheet, you will see a new green line with the price adjustment.
In the example below, the order was greater than 100,000 so a discount of 3% was applied.