The account workbook

Use the firesys account workbook to integrate data from your consolidation software easily into firesys and to validate it across several files. The account workbook is a convenient way of making a large amount of data to be validated available to all firesys users in the MeetingPoint. Based on an Excel file, it is easy to link data from the consolidation system with the firesys world.

<imagemap>Datei:EN-Excel Validation Kontomappe-Menüband.jpg|1200px|center rect 2 86 215 197 The_basic_functions_of_firesys rect 224 88 323 199 The_validation_worksheet rect 333 88 785 197 The_validation_basic_functions rect 791 90 886 198 The_functions_of_the_master_value_manager rect 890 90 977 199 Working_with_master_values rect 979 90 1061 198 Working_with_transmitter_values rect 1072 90 1175 196 The_account_workbook rect 1178 87 1382 115 The_account_workbook#Sort_account_workbook rect 1179 118 1382 144 The_account_workbook#Delete_rows rect 1178 149 1382 175 The_account_workbook#Account_value_history

desc none </imagemap>

Create an account workbook

The dialog for creating an account workbook

In the “*Validation” ribbon, in the “Cross-file validation” group, create an account workbook by using the “Create account workbook” function. The following dialog appears:

Account group

In the drop-down menu you see all account groups that were created previously in the master value manager.

Account workbook

Create new

Here you can select whether additional account values should be assigned to the previously selected account group. If you confirm this selection with “OK”, a new Excel document opens with an empty account workbook.

Read out from MeetingPoint

If you have selected an account workbook from the drop-down menu under “Account group” that already contains account values, you can activate the “Read out from MeetingPoint” function. The dialog expands to the maximum example shown on the right.

Options

Change key date

You can select this option if you want to change a key date of an account value in the previously selected account group. If you confirm this selection with “OK”, an Excel document opens containing all entries of this account value. Here the entry in the “Key date” column is missing, which you can now enter. To apply this key date, in the “*Validation” menu ribbon, in the “Cross-file validation” group, click on the “Apply master value” button or “Status update” to check whether the changes made can be applied.

Key dates

This list area displays all existing key dates from the account group that was selected beforehand in the drop-down menu. You can select the individual key dates or use the “Select all” function to select the entire list and then click on “OK” to open a new Excel document. This document displays the account values corresponding to the key dates that were previously selected. You can assign a new status, new values and/or free text to these account values. To apply these new contents, in the “*Validation” ribbon, in the “Cross-file validation” group, click on the “Apply master value” button or “Status update” to check whether the changes made can be applied.

	Good to know
	Account values that were already applied to the MeetingPoint can be updated individually in the master value manager or else multiple values can be updated via a new account workbook.

Sort account workbook

Datei:EN-Excel Validierung Kontenmappen-Sortierung.jpg

The sort options of account workbooks

You can sort the contents of your account workbooks at any time according to your individual preferences. firesys enables you to sort in ascending or descending order according to the examples shown on the right.

	Good to know
	You can use the “Sort account workbook” and “Delete rows” functions only in an opened account workbook.

Datei:RxbtnCellAccountValues 15 16.png Delete rows

You can delete the contents of your account workbook. Select the rows you require in your account workbook and press “Delete rows”. Multiple selection is also possible here.

Account value history

You can select a cell in your account workbook and use the “Account value history” function to display a history dialog. From the cell you selected, you see which numerical values this cell already contains. In additional, a change date and information is displayed about who made the changes.

Archive account values and restore them if necessary

→ Go to the main article on the master value manager

To archive a certain status of the account values, you can use the “Create archive workbook” in the central master manager.

See also

An overview of all validation functions in Excel
An overview of all validation basic functions
The firesys validation worksheet
The master value manager

Further contents

→ firesys website
→ Customer area
→ YouTube