Perform mass adjustment of prices

A pricing organization user can perform a mass adjustment of all the prices in a price list. A pricing organization user can either increase or decrease the prices of all the items in a price list either by a percentage amount or an absolute amount.

About this task

Sometimes an organization may have to adjust the prices of all the items in a price list. For example, because of a fuel price hike, the organization may want to increase the price of all the items by 0.5%.

To perform mass adjustment of prices 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. Select the corresponding check boxes of the price list lines for which you want to adjust the price, and click Mass Adjust Prices. Alternatively, to adjust the prices of all the price list lines in the price list, click the Mass Adjust All Prices related task.
  3. The Mass Adjust Prices dialog box is displayed. Select the appropriate options.

    The following table describes the options in the Mass Adjust Prices dialog box:

    Option Description
    List Price Select this option to either increase or decrease the list price of a price list line or all the price list lines.
    Absolute Adjustment Select this option to either increase or decrease the absolute adjustment for the price list line or all the price list lines.
    Note: This option is displayed only if the Maintain Absolute Adjustment rule is enabled in the Applications Manager.
    Percent Adjustment Select this option to either increase or decrease the percentage adjustment for the price list line or all the price list lines.
    Note: This option is displayed only if the Maintain Percent Adjustment rule is enabled in the Applications Manager.
    Increase Select this option to increase the selected price list line property. For example, you can select this option to increase the list price of a price list line or all the price list lines by some percentage or an absolute amount.

    Select either of the following options:

    • By percentage: Select this option and enter an amount to increase the selected price list line property by a certain percentage. For example, you can select this option and enter an amount of 5% to increase the list price of all the items in a price list by 5%.
    • By Absolute Amount: Select this option and enter an amount to increase the selected price list line property by an absolute amount. For example, you can select this option and enter an amount of $5 to increase the list price of all the items in a price list by $5.
    Note: The currency that is displayed for By Absolute Amount is populated based on the selection that is made in the Order Currency* field. For example, If you have selected US Dollar in the Order Currency*, then By Absolute Amount (In $): is displayed.
    Decrease Select this option to decrease the selected price list line property. For example, you can select this option to decrease the absolute adjustment of a price list line or all the price list lines by some percentage or an absolute amount.

    Select either of the following options:

    • By Percentage: Select this option and enter an amount to decrease the selected price list line property by a certain percentage. For example, you can select this option and enter an amount of 5% to decrease the absolute adjustment of a price list line by 5%.
    • By Absolute Amount: Select this option and enter an amount to decrease the selected price list line property by an absolute amount. For example, you can select this option and enter an amount of $10 to decrease the absolute adjustment of 5 price list lines by $10.
    Note: The currency that is displayed for By Absolute Amount is populated based on the selection that is made in the Order Currency* field. For example, If you have selected US Dollar in the Order Currency*, then By Absolute Amount (In $): is displayed.
  4. Click Save.