Creditor

Select the Creditor (Supplier) to update costs for.

Currency

The currency of the Creditor, read-only.

Rate Type

Defaults to the Rate Type for Purchases, read-only if currency is Base.

Date

Will default to the end date of the current IC period, required.

Exchange Rate

If Use Exchange Rate Table is selected from FX Settings, the rate is fetched from the Exchange Rates Table based on Currency Code, Rate Type and Date.

Product From/To

Stock Group

Restriction on Products to update, optional.

Update Method

Choose between Percentage, Amount and Revaluation.

If Revaluation, the Supplier Cost Base will be reconverted from Supplier Cost at the Exchange Rate.

Update By

If you 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 Cost Prices to Update fields by the amount or percentage entered.

If you selected Revaluation, this will be read-only.

Update Type

Select from:

• Query Run - (default), new prices for each Product will be shown in bold 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

Select the prices to update. If you selected Update Method Revaluation, only Supplier Cost Base is checked. If the Supplier Standard Cost is Selected, the Supplier Standard Cost Date will also be updated.

Include Inactive

Selected, include inactive products in the update.

Run (F9)

Reprice and show the results.