Skip to main content

Simple Restore Worksheet

Filter section​

At the top of the worksheet, you will find the filter fields:

FieldDescription
Table No.Select the table whose history data should be shown. Only logged tables can be selected.
Table NameFilled automatically from Table No. (read-only).
Table FilterFilter specific records within the table. Click the field to open a filter assistant.
Requested Date and TimeThe point in time for which historical values should be shown. By default, this is the current point in time.

Worksheet Table Filter

Worksheet table filter detail

History table​

For the selected point in time, the table shows all logged fields of the filtered records:

ColumnDescription
Date and TimeThe requested point in time
Table EntryIdentification of the record (for example, Customer No.)
Table NameName of the table
Field NameName of the field
Value at TimeValue of the field at the requested point in time
Current ValueCurrent value of the field in Business Central
Blue highlighted lines

Lines that are highlighted in blue indicate fields where the historical value differs from the current value - these can be restored.

History entry in worksheet

Time navigation​

You can adjust the shown point in time in different ways:

Enter timestamp directly​

Change the Requested Date and Time field directly to any point in time.

Worksheet time filter

In the action area, two navigation groups are available:

Jump backward:

ActionDescription
Previous ChangeJumps to the time of the last change for the selected field
1 Day BackSets the point in time back by 24 hours
1 Week BackSets the point in time back by 7 days
1 Month BackSets the point in time back by 1 month

Jump back

Jump forward:

ActionDescription
Next ChangeJumps to the time of the next change for the selected field
1 Day ForwardSets the point in time forward by 24 hours
1 Week ForwardSets the point in time forward by 7 days
1 Month ForwardSets the point in time forward by 1 month
To PresentResets the point in time to the current point in time
info

Jump-forward actions are only available when the selected point in time is in the past.

Restore field value​

Restore a single field​

  1. Select the required line in the history table (must be highlighted in blue)
  2. Click Restore Value
  3. Confirm the dialog - it shows exactly which value will be replaced by which value:

    Do you want to restore the following entry? Table Name, Record, Field Name: Current Value -> Historical Value

  4. After confirmation, the value is updated in Business Central

Restore field value in worksheet Restore field value in worksheet confirmation

Restore multiple lines at once (Expert Mode)​

  1. Select multiple lines in the history table (only blue highlighted lines are considered)
  2. Go to Navigation -> Expert Mode -> Restore Marked Lines
  3. Confirm the dialog
  4. All selected restorable lines are updated

Action to expert mode

Attention

The restore action cannot be undone automatically. Check values carefully before confirming.

Help