The account workbook

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen

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.


EN Menüband Excel Inhalt Daten-Import Kontomappe-erstellen.jpg



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:

Firesys Icons BubbleTransparent 1 white background.png Account group

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


EN Excel Status Kontomappe-Kontogruppe.jpg


Firesys Icons BubbleTransparent 2 white background.png Account workbook

Video: 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.



A detailed explanation of the individual steps

How to create an account value:

  1. Open an Excel workbook and activate firesys.
    Note: A prerequisite is that a compatible MeetingPoint was already connected.

  2. In the “*Content” menu ribbon, in the “Master values” group,
    → open the master value manager.

  3. In the “Management” group, click on the “Add” button.
    → A selection dialogue box opens.

  4. Select the “Account group” option and in the input dialogue box that opens, enter the name you require.

  5. Then close the master value manager and in the “Account workbook” group, click on the “Create” button.
    → This opens a dialogue box

  6. which you can select the account workbook to which the account values should be written, and also whether you want to create a new account workbook or load an existing one from the MeetingPoint.

  7. This opens a new Excel worksheet in which you can define the components of the individual account values.

  8. By using the “Transfer” function (in the “Account workbook” group), you can transfer all of the account values that exist in the account workbook into the MeetingPoint.
    → You have created an account value.

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.

Firesys Icons BubbleTransparent 3 white background.png 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 “*Content” menu ribbon, in the “Data-Import” group, click on the “Transfer account workbook” button or “Status update” to check whether the changes made can be applied.

Firesys Icons BubbleTransparent 4 white background.png 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 “*Content” menu ribbon, in the “Data-Import” group, click on the “Transfer account workbok” button or “Status update” to check whether the changes made can be applied.


Glühbirne neu.png
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.


RxmnuCellAccountValuesSheetSorting 16.png Sort account workbook

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.


Glühbirne neu.png
Good to know

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


RxbtnDeleteEmptyRow 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.

RxbtnCellAccountValues 11 16.png Master value history

You can select a cell in your account workbook and use the “Master 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.


EN Excel Validierung Kontowert-Verlauf.jpg

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.

RxbtnCellMultiUpdate 16.png Transfer account workbook

In firesys you can use the “Transfer master values” function to transfer account/master values out of the account workbook to your MeetingPoint.

Glühbirne neu.png
Good to know

The “Working with master values” function can only be executed on an account workbook.


EN Excel Validierung Kontenwerte-übertragen Auswahl.jpg



Once you have created an account workbook, you can add contents. To do this, enter information in the “Account”/“Description”/“Key date” and “Value” fields. You can then click on the “Transfer master values” function to transfer all entries in the account workbook to the MeetingPoint. You have two different selection options here:

Status update

The software checks which changes were made in the MeetingPoint when the values that are currently located in the account workbook are transferred. You then see a result report showing which changes you can expect when you execute the “Transfer” function.

Transfer

The existing account/master values are transferred to the MeetingPoint.


EN Excel Validierung Zentralwerte-Statusupdate.jpg

Special features when handling special characters

When working with firesys you have to take into account that some special characters are automatically replaced during the file import as well as during the import of account workbooks. This information is stored in the MeetingPoint - and here it could come to structural difficulties with the below mentioned special characters:

ASCII-Code Special character
ALT + 033 !
ALT + 034 "
ALT + 035 #
ALT + 039 '
ALT + 042 *
ALT + 047 /
ALT + 058 :
ALT + 060 <
ALT + 062 >
ALT + 063 ?
ALT + 091 [
ALT + 092 \
ALT + 093 ]
ALT + 0124 |
ALT + 0132
ALT + 0147
ALT + 0148

Additionally, the following characters (the so-called control characters) are removed:


ASCII-Code Description
ALT + 000 The null character prompts the device to do nothing
ALT + 001 Initiates a header (Start of Heading)
ALT + 002 Ends the header and marks the beginning of a message. (start of text)
ALT + 003 Indicates the end of the message (end of text)
ALT + 004 Marks the end of a completes transmission (End of Transmission)
ALT + 005 A request that requires a response (Enquiry)
ALT + 006 Gives a positive answer to the request (Acknowledge)
ALT + 007 Triggers a beep (Bell)
ALT + 008 Lets the cursor move back one step (Backspace)
ALT + 009 A horizontal tab that moves the cursor within a row to the next predefined position (Horizontal Tab)
ALT + 010 Causes the cursor to jump to the next line (Line Feed)
ALT + 011 The vertical tab lets the cursor jump to a predefined line (Vertical Tab)
ALT + 012 Requests a page break (Form Feed)
ALT + 013 Moves the cursor back to the first position of the line (Carriage Return)
ALT + 014 Switches to a special presentation (Shift Out)
ALT + 015 Switches the display back to the normal state (Shift In)
ALT + 016 Changes the meaning of the following characters (Data Link Escape)
ALT + 017 Control Character
ALT + 018 Control Character
ALT + 019 Control Character
ALT + 020 Control Character
ALT + 021 Negative response to a request (Negative Acknowledge)
ALT + 022 Synchronizes a data transfer, even if no signals are transmitted (Synchronous Idle)
ALT + 023 Marks the end of a transmission block (End of Transmission Block)
ALT + 024 Makes it clear that a transmission was faulty and the data must be discarded (Cancel)
ALT + 025 Indicates the end of the storage medium (End of Medium)
ALT + 026 Replacement for a faulty sign (Substitute)
ALT + 027 Initiates an escape sequence and thus gives the following characters a special meaning (Escape)
ALT + 028 Marks the separation of logical data blocks and is hierarchically ordered: file as the largest unit, file as the smallest unit.(File Separator, Group Separator, Record Separator, Unit Separator)
ALT + 029 Control Character
ALT + 030 Control Character
ALT + 031 Control Character


See also

Navigation hoch.svg Data import
Navigation rechts.svg An overview of the data import manager


Further contents

firesys website
Customer area
YouTube