Vorlage:Video-Tabelle vorrollen Zentralwerte-English

A detailed explanation of the individual steps

Setting up the roll forward function

• Open the worksheet containing the table that should be set up for using the “roll forward” function.

• In the “*Content” menu ribbon, in the “Roll forward” group, click on the upper part of the “Work area” split area to open the “Roll forward” work area.

• In the “Account group” drop-down menu, select the account group from which the account values or calculations originate that are located in the column to be rolled forward.

• Use the mouse to navigate to the table column from which the values should be rolled forward in a different column. Then click on the green “Add” icon in the “Columns” group in the “Roll forward” work area. The selected column is now displayed in the list area.

• In the “Roll forward” work area in the list area, select the entry that you previously created and assign the correct key date to the entry in the drop-down menu.

• Use the mouse to navigate to the table column in which the values from a different column should be rolled forward. Then click on the green “Add” icon in the “Columns” group in the “Roll forward” work area. The list area now also displays the selected column – and a blue arrow displays the direction of the values to be rolled forward.

• In the “Roll forward” work area in the list area, select the previously created entry and assign the correct key date to the entry in the drop-down menu.

• Then click on the “Save” icon in the “Changes” group in the “Roll forward” work area, and the work area closes automatically.

Executing the “Roll forward” function

• In the “*Content” menu ribbon, in the “Roll forward” group, click on the “Execute” button.

• A dialogue opens that displays information about the last successful “roll forward” process and optionally enables you to enter a free text which is transferred to the “Roll forward” history.

• In the “Key dates” area in the list view, check the information that is listed for the individual “roll forward” operations to see whether the key date to be rolled forward is always correct.

• Before executing the “roll forward” process, if you want to obtain information about which worksheets are being rolled forward, click on the “Status update” button.

• Clicking on “Start” starts the “roll forward” process.
  Note: Any changes that were not saved must be saved beforehand – furthermore, firesys creates a backup copy of your workbook which you must also consent to.

• Your workbook is rolled forward.