Adjust the prices of items based on quantity

About this task

An organization may sometimes have to adjust the quantity-based pricing information of some or all of the items in a price list. Quantity-based pricing is used when an organization wants to offer different prices to a customer based on the quantity ordered. For example, an organization may want to offer a discount of $100 on the unit price of an item if the ordered quantity is between 100 and 199, and a discount of $250 if the ordered quantity is between 200 and 299.

A pricing organization user can adjust the quantity-based pricing information of items in a price list.

To adjust the quantity-based prices for individual items in a price list:

Procedure

  1. Navigate to the Price List Summary screen. To navigate to the Price List Summary screen, perform the following steps:
    1. Log in to Sterling Business Center as pricing administrator.
    2. The application home page is displayed. Click the Pricing tab.
    3. From the Pricing home page, click Find Price List in the Pricing dashlet.
    4. The Price List Search screen is displayed. In the Basic Price List Search panel, enter the search criteria, and then click Search to perform a basic search. Alternatively, click Advanced Search, enter the search criteria, and then click Search to perform an advanced search.
    5. The price lists matching the search criteria are displayed. Click the Price List ID hyperlink or double-click the row corresponding to the price list. The Price List Summary screen is displayed.
      Note: If there is only one price list matching the search criteria, the details of the corresponding price list are automatically displayed.
  2. Perform either of the following tasks:
    • If the items for which you want to adjust the prices are displayed in the Items tab, select the check box corresponding to the items and click Adjust Prices.
    • If the items for which you want to adjust the prices are not displayed in the Items tab, search for the items by clicking the Find Items Within Price List related task. The Find Items panel is displayed. Enter the appropriate search criteria, and click Search. The items matching the search criteria are displayed in the Search Results panel. Select the check box corresponding to the items for which you want to adjust the prices and click Adjust Prices.

      Alternatively, click the Create hyperlink or the Manage hyperlink in the Quantity Tiers column to adjust the quantity-tiered prices for the corresponding item.

      Note: The Create hyperlink will be displayed only if there are no quantity tiers defined for the item. The Manage hyperlink will be displayed only if there are one or multiple quantity tiers defined for the item.
  3. The Adjust Prices dialog box is displayed. In the List Price* box, enter the new list price of the item. The list price is the unit price of an item.
  4. In the Adjustment % (+/-) box, enter the corresponding positive or negative amount to adjust the percentage of the list price of the item. To enter a positive amount, enter the number without a plus (+) sign before the number. To enter a negative amount, enter a minus (-) sign before the number. A positive amount indicates the percentage of the amount to be added to the list price. A negative amount indicates the percentage of the amount to be discounted from the list price.
    Note: You can modify this field only if the Maintain Percent Adjustment rule is enabled in the Applications Manager.
  5. In the Adjustment (+/-) box, enter the positive or negative amount to make an absolute adjustment to the list price of the item. To enter a positive amount, enter the number without a plus (+) sign before the number. To enter a negative amount, enter a minus (-) sign before the number. A positive amount indicates the absolute amount to be added to the list price. A negative amount indicates the absolute amount to be discounted from the list price.
    Note: You can modify this field only if the Maintain Absolute Adjustment rule is enabled in the Applications Manager.
  6. Select the Use a quantity-based tiered pricing for the item check box to specify the quantity-based pricing information for the item.
  7. In the Quantity Tiers area, perform the following steps for every quantity tier:
    1. In the Greater Than Or Equal To column, enter the start range of the quantity for the tier.
      Note: By default, the value in the Greater Than Or Equal To column of the first row is displayed as zero and value in the last row of the Less than column is displayed as No Limit
    2. In the Less than column, enter the end range of the quantity for the tier.
    3. In the List Price column, enter the list price of the item for the tier.
    4. In the Absolute Adjustment (+/-) column, enter the positive or negative amount to make an absolute adjustment to the list price of the item for the tier. To enter a positive amount, enter the number without a plus (+) sign before the number. To enter a negative amount, enter a minus (-) sign before the number. A positive amount indicates the absolute amount to be added to the list price. A negative amount indicates the absolute amount to be discounted from the list price.
      Note: This field is displayed only if the Maintain Absolute Adjustment rule is enabled in the Applications Manager.
    5. In the Percentage Adjustment (+/-) column, enter the corresponding positive or negative amount to adjust the percentage of the list price of the item for the tier. To enter a positive amount, enter the number without a plus (+) sign before the number. To enter a negative amount, enter a minus (-) sign before the number. A positive amount indicates the percentage of the amount to be added to the list price. A negative amount indicates the percentage of the amount to be discounted from the list price.
      Note: This field is displayed only if the Maintain Percent Adjustment rule is enabled in the Applications Manager.
    6. Click Add Another Tier to add a new quantity tier for the item.
    7. A new row is added. Repeat step a through step e to specify another quantity tier for the item.

      Click the Delete icon to delete a quantity tier.

  8. Click Save And Continue to save the changes and move to the next item to continue making the adjustments.
    Note: The Save And Continue button is displayed only if you selected more than one item in the Price List Summary screen.
  9. Click Save And Close to save the changes and close the Adjust Prices dialog box.

    Notes:

    • * indicates that the field is mandatory.
    • You cannot create multiple quantity tiers for an item with the same quantity range.