Update Item Pricing Form

This form lets you:

• Change prices, costs, or price check type for a range of items on one or more price lists.

You can change the type of price check performed on items, or you can update the base price, sale price, or markup cost by using percentage, amount, markup, or margin. You can also specify the percentage of the increase or decrease in the base price.

This form updates item information on existing price lists. If you want to create a new price list, open the Item Pricing form or the Copy Item Pricing form.

Before you start

• Determine the price lists and items you want to update.

• Determine the method you want to use to update prices.

• Print the Price Lists report from the Price/Sales Analysis Reports folder for the price lists you want to change.

To update the prices in one price list

1. Double-click the Update Item Pricing icon in the Items And Price Lists folder.

2. Use the Finders to specify the range of price lists to update.

3. Use the Finders to specify the range of items to include in the update.

4. Select the kind of change and the method of updating, then, for prices or costs, specify the increase or decrease.

5. Click the Update button to update the selected price lists.

After updating price lists

• Print the price lists that include the information you changed, using the Price Lists icon in Price/Sales Analysis Reports folder, to check the new record information.

• Compare the price lists you printed before making changes to those printed afterwards, to verify that you made all changes correctly.

Multicurrency ledgers

If you have a multicurrency system, you can update prices by currency and exchange rate.

For example, if you update US prices first, you can update Canadian prices on your price list by using exchange rates, and basing the new prices on the US currency prices.

For example, if the price list code is RETAIL, and you enter the following in the Update Pricing fields:

 

Currency: CAD
Price List Code: from RETAIL to RETAIL
Update: Base Price using Exchange Rate
Base on currency: USD

The program will first locate the item pricing with:

 

Currency: USD
Price list code: RETAIL

Then it will multiply the base price times the exchange rate, and update the item pricing for:

 

Currency: CAD and
Price List Code: RETAIL

 

Click the Field List button at the top of this topic for information about fields on the Update Item Pricing form.

Click here for hints on using forms.

See also

 

Copy Item Pricing

Item Pricing

Price List Codes