Updating standard database prices by category (SQL)
Description
Getting Started: Updating prices in the standard database (SQL)
Cause
Resolution

Updating standard database prices by category

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 that you back up your standard database.

To update standard database prices by category:

  1. Open the Price Update by Category window in one of the following ways:
    • On the ribbon, from the Updates group on the Data tab, click By Category.
    • In classic view, select Pricing menu > Update Database.
  2. On the Categories tab, enter the percentage of change for item prices in each category.

By default, all item prices are updated. To limit the update to specific phases of items, specify the desired phases on the Phase Range tab.

  1. (optional) Use the tabs to customize the Price Update report.
  2. Click [OK].
  3. Review the Price Update Confirmation window.
    • To continue with the price update, click [OK].
    • To cancel the update and return to the Price Update by Category window, click [Cancel].

When you click [OK], Sage Estimating 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.

Tips:

  • If you often use the same settings for updating your standard database by cost category, 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.)


[BCB:164:Chat Estimating US:ECB]

Steps to duplicate
Related Solutions