Updating standard database prices using a pricing service

Updating the standard database prices does not affect existing estimates. The new standard database prices apply to estimates started after the update. This procedure updates the prices of all linked items.

It is mathematically impossible to end up with the original prices if you increase, and then decrease prices by the same percentage.

Before you begin

This process makes permanent changes to the standard database. Before you update prices, Sage recommends performing a back up of your estimate data.

To update prices by price code:

Open the Price Update by Price Code window in one of these ways:
- On the ribbon, from the Updates group on the Data tab, click By Price Code.
- In classic view, select Pricing menu > Update Database.
In the Price Code column, enter the price codes (up to 50) that you want to update.

Tip: Click the List button to select price codes from a list.
Enter the percentage of change, by category, for each price code.
- To increase prices, enter a positive percentage. For example, to increase labor prices by 5%, enter 5 in the Labor % field.
- To decrease prices, enter a negative percentage. For example, to decrease equipment prices by 8%, enter -8 in the Equipment % field.
- To keep the current prices, leave the appropriate category % field blank.
(optional) Use the tabs to customize the Price Update report.
- To select where the report prints, click the Categories tab and choose an option in the Price Update Report area.
- To change the fonts or colors, click the Font tab and change the font settings.
- To change the page setup, click the Page Setup tab and change the page setup options.
Click [OK].
Review the Price Update Confirmation window.
- To continue with the price update, click [OK].
  
  When you click [OK], Sage Estimating (SQL) performs the price update. To pause the price update process, click [Pause] in the Price Update in Progress window. With the price update paused, you can click a button to undo, cancel, or continue the price update.
- To cancel the update and return to the Price Update by Price Code window, click [Cancel].

Tips:

If you often use the same settings for updating your standard database by price code, you can save those settings as the default for future updates. To do this, click [Save Default].
To preview the price update results before you perform the actual update, select Preview in the Price Update Report area. (The Preview option is for review purposes only; it does not update the standard database prices.)