The Revaluation Tool

In order to perform a revaluation a user must have global edit privileges in the Catalog (operation of daReplace) and be able to perform a replace on all the fields to be updated (column access of duReplace). The default columns that require replace permission are:

  • ValValuedByRef
  • ValDateValued
  • ValReasonForValuation
  • ValValuationAmount
  • ValValuationNotes

Updating valuation information in EMu can be tedious if a large batch of records needs to be changed. The EMu Global Replace facility may be used to apply a set of values for a series of records, making the batch update of records easier; however in most instances a global replace does not provide sufficient control to update the valuation amount correctly. For example, you may want to increase the current valuation by 5%. The global replace facility does not provide a mechanism that allows field values to be computed.

The Revaluation tool enables users to update valuation information for either a single record or a group of records. The tool is very similar to the Relocation tool used to update location information.

The Revaluation tool is found by selecting Tools>Revalue from the Catalog module menu bar. The command is available in all display modes (e.g. List, Contact Sheet and Detail) and can be used on either the current or selected records. When selected a dialog box displays containing valuation fields. The dialog is generally laid out in the same format as the Valuation tab itself:

Valuations box

The Revaluation tool provides three different methods for calculating the new amount:

  • Set Amount

    Allows an absolute value to be set. The value entered into the input box to the right of the option is set for all objects to be revalued.

  • Add Fixed Amount

    Adds a fixed amount to the existing valuation. The current value of each object is read and a fixed amount is added to it. A negative value may be used to decrease the valuation. If an object does not contain a current valuation, the value is left empty.

  • Add Percentage

    Adds a fixed percentage to the current valuation. The current value of each object is determined and then increased by a fixed percentage. Using this option it is possible to add 5% to the selected objects. A negative percentage may be used to devalue objects. If an object does not contain a current valuation, the value is left empty.

After the value has been calculated the tool can also round the result up to the nearest specified amount. For example, entering a value of 10.00 would result in all valuations being rounded up to the nearest ten dollars.

The Revaluation tool is found by selecting Tools>Revalue from the Catalog module menu bar:

Valuations box

The Date Valued field is filled with the current date. Other values entered are remembered the next time the tool is used in the current form (Date Valued is always updated).

When the Update button is clicked the revaluation begins. The Updating box will display with an indication of how many records have been processed:

Updating

When the process is complete the dialog will remain visible until the Ok button is selected.

If a record cannot be updated because it is being edited by another user, a message will display requesting what action to take:

Cannot update

Note: While the tool provides a useful facility for upgrading batches of records, the standard valuation mechanism of entering data for a single record is still supported.