Update Method

Select from:

• Percentage, apply a percentage.
• Amount, specify a dollar amount.
• Markup Only, apply the markups from the product record.

Update By

If you have selected the Percentage method, type the percentage here; if you selected the Amount method, type the amount. This will update the prices selected in the Prices to Update field by the amount or percentage entered.

Update Type

Select from:

• Query Run, (default), new prices for each Product will be shown in a query window before updating. You will have the choice for each Product to edit, update or cancel.
• Report Only, report the effect of applying the selections made in the Price Update without actually changing the prices. If report destination is Screen select Regenerate from the Report Preview to return to the selection form with all selections retained.
• Automatic, proceed with the price update based on the selections.

Cost Prices to Update

For update by percentage or amount select the cost price(s) (if any) to be updated. If you use a query run, you can update other prices manually in the query window. If you update the Latest Cost Price for Products with a stock level of zero or less, the Average Cost Price will change to the new Latest Cost Price. After the update is complete, you can print a report of the price changes.

See examples below for sample selections and their effects.

Markup Basis

Defaults to the Markup Basis specified in IC Settings.

Note: If Automatically Apply Markups in IC Settings is Selected Markup Basis cannot be changed and prices with markups cannot be updated directly, they will automatically update as the Markup Basis price changes.

Sell Prices

Expand Toolbar (Ctrl+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Customise Fields (Alt+F5)

Opens Customise Fields - you can customise fields visible in the grid.

Action

• None, no change to the sell price.
• Update, update the sell price by the specified percentage or amount.
• Markup, to recalculate the sell price, markup from the Markup Basis after prices are updated.

Code

The Price code.

Currency

The currency for the Price code.

Markup Price

If Markup Basis is Price code, the Price code that mark up will apply from.

Round Direction

Default from the Price Code settings. Specify the rounding direction used when calculating the price for a product where markups or global price update is used.

Round Unit

Defaults from the Price Code settings. If you type a value here, the newly calculated prices will be rounded to match the amount, for example, to round to the nearest dollar, enter 1.00.

Include Inactive

Selected, include inactive products in the update.

Run (F9)

Reprice and show the results.

Examples

Updating all Selling Prices by $1, where Selling Prices are not based on markups.

• Update Method = Amount
• Update By = 1
• Cost Prices to Update = Select all that apply
• Markup Basis = None
• Sell Prices Action = None

Accredo will add $1 to the price types selected.

Recalculating Selling Prices to reflect previous global updates and changes in IC Product without having to open each (where Apply Markups option in IC Settings is clear).

• Update Method = (doesn't matter)
• Update By = (leave blank)
• Cost Prices to Update = (leave clear)
• Markup Basis = the Markup Basis in IC Settings
• Sell Prices Action = Set to Markup for all those that apply

Accredo will recalculate Selling Prices selected to reflect changes to the base price (Markup Basis) selected.

Updating Latest Cost Prices by 5% and then updating Selling Price to reflect this:

• Update Method = Percentage
• Update By = 5%
• Cost Prices to Update = Select Latest Cost
• Markup Basis = Latest Cost
• Sell Prices Action = Update

Accredo will recalculate Selling Price as follows:
(current) Latest Cost + 5% = (new) Latest Cost
(new) Latest Cost + Markup percentage for Selling Price (from Product record) = (new) Selling Price.