Updating Pricing Information for Groups of Items

Learn more

About Price Lists

Associating Items with Price Lists

Adding Price List Codes

Changing Pricing Information for Single Items

I/C Update Item Pricing Screen

The I/C Update Item Pricing screen updates item pricing information for a range of items on one or more price lists.

Note: If you want to create a new price list, use the Item Pricing screen.

ClosedBefore you start
  • Determine the price lists and items you want to update.
  • Determine the method you want to use to update prices.
  • Print the I/C Price Lists report for the price lists you want to change.

To update item pricing:

  1. Open Inventory Control > I/C Items and Price Lists > Update Item Pricing.

  2. If you have a multicurrency system, in the Currency field, specify the currency of the item prices you are changing.
  3. In the From Price List Code and To Price List Code fields, specify the range of price lists to update.
  4. In the Sort By field, specify the filter to use to select item prices, and then in the From and To fields, specify the range to update. More...

    You can specify a range of item numbers, categories, item segments, vendor numbers, or optional field values. You can choose from any character optional fields that are active.

  5. From the Update list, select the type of information to update.More...

    You can update any of the following information:

    • Base Price. Select this option to add, increase or decrease item base prices.
    • Sale Price. Select this option to add, increase, or decrease sale prices for a range of items. You can also specify the beginning and ending dates for the period during which the sale price applies.
    • Markup Cost. Select this option to increase or decrease the cost on which markups are currently based.
    • Price Check Type. Select this option to change how Order Entry responds to price overrides (for example, displaying an error message or requiring price approval).
    • Price List Dates. Select this option to update the period for which the selected price lists are valid.

  6. In the Using field, specify whether to apply a percentage or an amount, or (in a multicurrency system) apply an exchange rate to the base price, sale price, or markup cost.

    Note: This field appears only if you are updating a price or a cost.

  7. Depending on your choices for the Update and Using fields, fill in the remaining fields as follows:

    • If you selected Base Price or Markup Cost, specify whether to increase or decrease the price or cost, and then specify the percentage or the amount.
    • If you selected Sale Price or Price List Date in the Update field, specify the range of dates for which the updated information is valid.

    • If you selected Price Check in the Update field, specify the type of price check message to display in Order Entry. More...

      Specify how you want Order Entry to respond to price overrides. Order Entry can:

      • Do nothing (if you select None).
      • Display a warning message and let you continue.
      • Display an error message and reject the price override.
      • Require a supervisor’s approval on price overrides.
  8. Click Update to update the selected price lists.
ClosedAfter updating pricing information
  • Print the I/C Price Lists report to check the information you changed.
  • Compare the price lists you printed before making changes to those printed afterward, to verify that you made all changes correctly.

Published: September 11, 2020
© 2020 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks