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. How?
- (optional) Use the tabs to customize the Price Update report. How?
- 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.)