Copying Pricing Information to Other Price Lists or Currencies

The Copy Item Pricing screen copies pricing information from one price list or currency to another price list or currency, adding items to a new or existing price list.

Note: You cannot copy an item or a range of items if any of the items already appear on the list you are copying to. Use the Update Item Pricing screen to change existing price list information.

To copy items and prices to another price list:

1. Open Inventory Control > I/C Items and Price Lists > Copy Item Pricing.
2. If you have a multicurrency system, enter (or use the Finder to select) the currency from which you want to copy item pricing information. More...

   If you have a multicurrency system, you must specify the currency of the prices you are copying.

   You can copy prices to a different currency in the same price list, specifying an exchange rate to convert prices from one currency to another. This is the simplest way to update prices in different currencies.

3. Enter (or use the Finder to select) the code for the price list from which you want to copy item pricing information.
4. If you have a multicurrency system, enter or select the code for the currency to which you are copying pricing information.
5. Enter or select the code for the price list to which you want to copy pricing information.
6. Use the Select by list to specify a selection method, and then use the From and To fields to specify the range of item prices to copy. More...

   You can copy prices for all or a portion of the price list, selecting the range of prices by one of the following elements:

   • Item numbers
   • Item categories
   • Item segments
   • Vendor numbers
   • Any optional field defined for Inventory Control items
7. In the Select Fields section, select the pricing information to copy. More...

   Choose which pricing information you want copied to the target price list:

   • Base Price. Select the Base Price option to copy the base price.
   • Decimal Places. If you select the Base Price option, select the number of decimal places to use when displaying or printing the base and sale prices.
   • Sale Price. Select the Sale Price option to copy the sale price.
   • Sale Starts/Ends. If you select the Sale Price option, select the first and last dates from the drop-down calendar for a sale period during which sale prices apply.
   • Markup Cost. Select the Markup Cost option to copy the markup cost.
   • Markup Factor. To select the Markup Cost option, enter the number by which to multiply the markup costs to calculate the selling prices for items on the new price list.
   • Discount/Markup Information. Select the Discount/Markup Information option to copy the item's discount or markup information that is specified on the Discounts tab of the Item Pricing screen.

     If you specify discounts or markups by percentage, this information is unaffected by increases or decreases when copying.

   • Price Check Information. Select the Price Check Information option to copy the price check information that is specified on the Price Check tab of the Item Pricing screen. Price check information includes item and employee-specific rules for checking price override amounts entered in Order Entry.

     Note: Price checks are available only in Sage 300 Premium.

   • Tax Information. Select the Tax Information option to copy the item's tax information that is specified on the Taxes tab of the Item Pricing screen.

     The tax information may not be valid in the target price list if you are copying between currencies. Tax information is unaffected by increases or decreases when copying.

8. In the Create the Selected Fields section, specify whether to increase or decrease prices in the target price list by a percentage, or (in a multicurrency system) apply an exchange rate. More...

   You can increase or decrease the pricing information when you copy it by specifying a percentage or, if you have a multicurrency system, an exchange rate. This feature lets you quickly set up discounted price lists or price lists in another currency.

   • If you calculate discount and markup amounts by percentages, these percentages are not affected by increases or decreases you specify when copying.
   • Tax information is not affected by copying with an increase or decrease.
9. Click Copy to copy pricing information for the selected range of items.