Adjust the prices of items based on date range

A pricing organization user can adjust the date range of an item's price in a price list.

About this task

Every price list is defined for a specific period of time during which these prices are effective. Sometimes an organization may have to modify the date range of an item's price because of certain factors. For example, if an organization wants to sell woolen clothing at a higher price in winter, the pricing organization user can modify the date range of the item and increase the item's price instead of creating a new price list.

To adjust the date range of an item's price:

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 date range are displayed in the Items tab, select the check boxes corresponding to the items, click More Actions, and select Set Date Based Prices from the drop-down menu to adjust the date range for all the price list lines for that item.
    • If the items for which you want to adjust the date range 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 boxes corresponding to the items for which you want to adjust the date range, click More Actions, and select Set Date Based Prices from the drop-down menu to adjust the date range for all the price list lines for that item.

      Alternatively, click the Create hyperlink or the date range hyperlink in the Effective Date column to adjust the date range for the selected price list line.

      Note: The Create hyperlink will be displayed only if there is no date range defined for the item. The date range hyperlink will be displayed only if there are one or multiple date ranges defined for the item.
  3. The Adjust Date Ranges dialog box is displayed. Perform the following tasks for every date range:
    1. In the Effective From column, enter the date from which the list price of the item will be effective. Alternatively, click the Calendar icon to select the date.
    2. In the Effective To column, enter the date until which the list price of the item will be effective. Alternatively, click the Calendar icon to select the date.
    3. In the List Price column, enter the list price of the item for the date range selected.
    4. In the Adjustment (+/-) column, enter the positive or negative amount to make an absolute adjustment to the item's list price for the date range selected. 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.
    5. In the Adjustment % (+/-) column, enter the positive or negative amount to adjust the percentage of the item's list price for the selected date range. 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.
  4. To add a new date range for the item, click Add Date Range. A new row for specifying the new date range is added. Repeat step a through step e to specify a new date range for the item.
    Note: If you add a new date range, a new price list line will be created for the price list.
  5. To delete a date range, click the Delete icon.
    Note: If you delete a date range, the price list line corresponding to that date range will be deleted from the price list.
  6. Click Save.

    The Price List Summary screen is displayed.