The master value manager: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(26 dazwischenliegende Versionen von 3 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
The master value manager is the “control centre” for all master values. Keep an overview of which master values are stored in the MeetingPoint. Here you can also create manual values and use these for cross-file validations later on. So that you can continue working in the Excel document, you must close the master value manager.  
The Master value manager is the "control center" for all master values. Keep track of which master values are stored in the MeetingPoint. Here you can also create manual values to use them later for cross-file validations. In addition, you can create account groups, account calculations and account aggregates. It is also possible to add and subtract account values in an account calculation. To continue working in the Excel document, you must close the Master value manager.
 
[[Datei:EN_Menüband_Excel_Inhalt_Zentralwerte_Zentralwert-Manager.jpg|1200px|center]]


<imagemap>Image:EN_Excel Menüband Inhalt Zentralwerte Zentralwert-Manager.jpg|1200px|center


desc none
</imagemap>




Zeile 10: Zeile 9:
== The master value manager interface ==
== The master value manager interface ==


The interface of the master value manager displays all important information and tools so you can work easily with master values.  
The Master value manager interface quickly provides you with all the important information and tools for comfortable work with master values, account calculations and account aggregates.




[[Datei:EN_Excel_Status_Zentralwert-Manager_Übersicht.jpg|center|800px]]
[[Datei:EN Excel Inhalt Zentralwert-Manager Übersicht.jpg|center|800px]]




== [[File:Firesys Icons BubbleTransparent 1 white background.png|link=|24px]] Management ==
== [[File:Firesys Icons BubbleTransparent 1 white background.png|link=|24px]] Management ==


=== Add ===
===[[Datei:Image-Common-Plus.48.png|link=|16px]] Add ===
[[Datei:EN Excel Validierung Zentralwert-Manager Hinzufügen.jpg|mini|upright=2.0|The Add dialog in the master value manager]]
[[Datei:EN Excel Validierung Zentralwert-Manager Hinzufügen.jpg|mini|upright=1.5|The Add dialog in the master value manager]]


Here you can add a manual master value, an account calculation or an account group to the MeetingPoint.  
Here you can add a manual value, account calculation, account group or account aggregates to the MeetingPoint.


==== Manual value ====
::<b> [[Datei:Image.Cell.Type.DatabaseValue.48.png|link=|20px]] Manual value </b><br>


A manual value is stored in the MeetingPoint and can only be changed in the master value manager. So that validations can be structured better, you have to give the value a name, enter a number and you also have the option of saving a comment.  
::A Manual value is stored in the MeetingPoint and can also only be changed in the Master value manager. In order to better structure your manual values, you must give the value a designation; optionally, a comment can also be stored.




Zeile 36: Zeile 35:




==== Account group ====
::<b>[[Datei:Image.Cell.AccountGroup.48.png|link=|16px]] Account group </b><br>
 
::In addition, new account groups can be added. Here it is only necessary to assign a name - and newly created account groups can later be assigned values from account folders and the Data import.
 
::<b>  [[Datei:Image.Cell.NeutralAccountCalculation.48.png|link=|16px]] Account calculation </b><br>


New account groups can also be added. To do this, you merely need to assign a name. Values from account workbooks can be assigned to newly created account groups later on.  
::You can create an account calculation in which you add or subtract account values. It is necessary to give the account calculation a name and assign it to an existing account group.


==== Account calculation ====
::<b> [[Datei:Image.Cell.NeutralAccountAggregate.48.png|link=|16px]] Account aggregate</b><br>


You can create an account calculation in which you add or subtract account values. It is necessary to give the account calculation a name.
::You can create an account aggregate by adding or subtracting account values and account calculations. As with account calculation, you must give the account aggregate a name and assign it to an existing account group.


=== Edit ===
===[[Datei:Image.Common.Edit.48.png|link=|16px]] Edit ===


Change the selected manual master value.  
Change the selected manual master value. It is also possible to edit account calculations, account aggregates and manual rounding values.


=== Edit name ===
===[[Datei:Image.Cell.Title.Edit.48.png|link=|16px]] Edit name ===


Edit the name of the selected master value.  
Edit the name of the selected master value. You can also rename account groups here.


=== Edit comment ===
===[[Datei:Image.Common.Manager.Comment.Edit.48.png|link=|16px]] Edit comment ===


Create or edit a comment which is displayed in the master value manager.  
Create or edit a comment for a single value displayed in the Master value manager.


=== Delete ===
===[[Datei:Image.Trans.Term.Delete.48.png|link=|16px]] Delete ===


Deletes the selected master values from the MeetingPoint.  
Deletes the selected master value, account group, account aggregate, key date or manual rounding value from the MeetingPoint.


=== Convert transmitter value ===
===[[Datei:Image.Cell.CopyKeyDate.48.png|link=|16px]] Copy key date ===
 
You can copy the key date and the corresponding accounts in the Master value manager.
A dialog opens in which you can assign a new key date to the accounts without having to go via the account workbook.
This is a convenient way to prepare your values for the coming fiscal year.
 
===[[Datei:Image.Cell.ExcelValue.Convert.48.png|link=|20px]] Convert transmitter value ===


Converts the selected transmitter value into a manual master value.  
Converts the selected transmitter value into a manual master value.  


=== Check use ===
== [[File:Firesys Icons BubbleTransparent 2 white background.png|link=|24px]] Informations ==
 
===[[Datei:Image.Cell.CheckUsage.48.png|link=|16px]] Check use ===


Checks whether a transmitter value is used in cross-file validation. The list of recipient files then indicates in which files this transmitter value is used.  
Checks whether a transmitter value is used in cross-file validation. The list of recipient files then indicates in which files this transmitter value is used.  


== [[File:Firesys Icons BubbleTransparent 2 white background.png|link=|24px]] The list ==
===[[Datei:Image.Cell.AccountValue.History.48.png|link=|16px]] Display master value history ===
 
Here you can display the history of manual, sender and account values.
 
== [[File:Firesys Icons BubbleTransparent 3 white background.png|link=|24px]] The list ==
 
In the list view, all master values, account groups, account calculations and account aggregates currently stored in the MeetingPoint are displayed. Further information on the individual values can be displayed at the top right of the Central Manager via the "Expand all" or "Reduce all" button.


The list view displays all master values and account groups that are currently saved in the MeetingPoint. You can expand and reduce the individual manual and account values by using the button on the side. Presentation of all master values in the MeetingPoint.  
== [[File:Firesys Icons BubbleTransparent 4 white background.png|link=|24px]] View ==


== [[File:Firesys Icons BubbleTransparent 3 white background.png|link=|24px]] View ==
<b>[[Datei:Image.Common.Manager.AllItems.Expand.48.png|link=|16px]] Expand all/[[Datei:Image.Common.Manager.AllItems.Reduce.48.png|link=|16px]]Reduce all </b>


=== Expand all/reduce all ===
Expands or reduces all objects in the list. This makes more information available to you.  
Expands or reduces all objects in the list. This makes more information available to you.  


=== Search & filter ===
<b>[[Datei:Image.Common.Manager.Search.Orange.48.png|link=|16px]] Search & filter </b>


Opens the search field to search the object list for certain information. Determine which objects are shown in the list. You can also filter by transmitter values, manual master values, error-free objects, warnings and problems. Multiple filters can be combined. The view can be reset by choosing “Remove filter”.  
Opens the search field to search the object list for certain information. Determine which objects are shown in the list. You can also filter by transmitter values, manual master values, account aggregates, error-free objects, warnings and problems. Multiple filters can be combined. The view can be reset by choosing “Remove filter”.  


=== Help ===
<b>[[Datei:Image-Help.48.png|link=|16px]] Help </b>


Opens the help area which supports you as you work.  
Opens the help area which supports you as you work.  




== Display central value history  ==
== Video: Display central value history  ==


{{Vorlage:Video- Zentralwert-Verlauf-English}}
{{Vorlage:Video- Zentralwert-Verlauf-English}}
== Video: Copy key date ==
{{Vorlage:Video-Zentralwert-Manager Stichtag kopieren-English}}


== See also ==
== See also ==
[[Datei:Navigation_hoch.svg|link=]]  [[The_functions_of_the_master_value_manager|The functions of the master value manager]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[The_functions_of_the_master_value_manager|The functions of the master value manager]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Additional_functions_in_the_master_value_manager|Additional functions in the master value manager]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Additional_functions_in_the_master_value_manager|Additional functions in the master value manager]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Working_with_master_values|Working with master values]] <br>
 
[[Datei:Navigation_rechts.svg|link=]]  [[Insert_transmitter_values|Insert transmitter values]] <br>


{{MoreContent}}
{{MoreContent}}
[[Kategorie:English-Excel Dokument-Zentralwerte-Content]]
[[Kategorie:English-Excel Dokument-Zentralwerte-Content]]

Aktuelle Version vom 22. November 2021, 15:29 Uhr

The Master value manager is the "control center" for all master values. Keep track of which master values are stored in the MeetingPoint. Here you can also create manual values to use them later for cross-file validations. In addition, you can create account groups, account calculations and account aggregates. It is also possible to add and subtract account values in an account calculation. To continue working in the Excel document, you must close the Master value manager.

EN Menüband Excel Inhalt Zentralwerte Zentralwert-Manager.jpg



The master value manager interface

The Master value manager interface quickly provides you with all the important information and tools for comfortable work with master values, account calculations and account aggregates.


EN Excel Inhalt Zentralwert-Manager Übersicht.jpg


Firesys Icons BubbleTransparent 1 white background.png Management

Image-Common-Plus.48.png Add

The Add dialog in the master value manager

Here you can add a manual value, account calculation, account group or account aggregates to the MeetingPoint.

Image.Cell.Type.DatabaseValue.48.png Manual value
A Manual value is stored in the MeetingPoint and can also only be changed in the Master value manager. In order to better structure your manual values, you must give the value a designation; optionally, a comment can also be stored.


Glühbirne neu.png
Good to know

You can only enter numbers in the “Value” field. If a letter or special character occurs in the number (provided it does not occur at the first location), these characters are removed when you click “OK”.


Image.Cell.AccountGroup.48.png Account group
In addition, new account groups can be added. Here it is only necessary to assign a name - and newly created account groups can later be assigned values from account folders and the Data import.
Image.Cell.NeutralAccountCalculation.48.png Account calculation
You can create an account calculation in which you add or subtract account values. It is necessary to give the account calculation a name and assign it to an existing account group.
Image.Cell.NeutralAccountAggregate.48.png Account aggregate
You can create an account aggregate by adding or subtracting account values and account calculations. As with account calculation, you must give the account aggregate a name and assign it to an existing account group.

Image.Common.Edit.48.png Edit

Change the selected manual master value. It is also possible to edit account calculations, account aggregates and manual rounding values.

Image.Cell.Title.Edit.48.png Edit name

Edit the name of the selected master value. You can also rename account groups here.

Image.Common.Manager.Comment.Edit.48.png Edit comment

Create or edit a comment for a single value displayed in the Master value manager.

Image.Trans.Term.Delete.48.png Delete

Deletes the selected master value, account group, account aggregate, key date or manual rounding value from the MeetingPoint.

Image.Cell.CopyKeyDate.48.png Copy key date

You can copy the key date and the corresponding accounts in the Master value manager. A dialog opens in which you can assign a new key date to the accounts without having to go via the account workbook. This is a convenient way to prepare your values for the coming fiscal year.

Image.Cell.ExcelValue.Convert.48.png Convert transmitter value

Converts the selected transmitter value into a manual master value.

Firesys Icons BubbleTransparent 2 white background.png Informations

Image.Cell.CheckUsage.48.png Check use

Checks whether a transmitter value is used in cross-file validation. The list of recipient files then indicates in which files this transmitter value is used.

Image.Cell.AccountValue.History.48.png Display master value history

Here you can display the history of manual, sender and account values.

Firesys Icons BubbleTransparent 3 white background.png The list

In the list view, all master values, account groups, account calculations and account aggregates currently stored in the MeetingPoint are displayed. Further information on the individual values can be displayed at the top right of the Central Manager via the "Expand all" or "Reduce all" button.

Firesys Icons BubbleTransparent 4 white background.png View

Image.Common.Manager.AllItems.Expand.48.png Expand all/Image.Common.Manager.AllItems.Reduce.48.pngReduce all

Expands or reduces all objects in the list. This makes more information available to you.

Image.Common.Manager.Search.Orange.48.png Search & filter

Opens the search field to search the object list for certain information. Determine which objects are shown in the list. You can also filter by transmitter values, manual master values, account aggregates, error-free objects, warnings and problems. Multiple filters can be combined. The view can be reset by choosing “Remove filter”.

Image-Help.48.png Help

Opens the help area which supports you as you work.


Video: Display central value history


The explanation of each step in detail

How to display the master value history for manual, transmitter and account values:

  1. In the "*Content" ribbon, in the "Master values" group, click the "Master value manager" button.
    → The Master value manager opens.

  2. Select a value.

  3. In the Master value manager, in the "Information" group, click the "Master value history" button.
    → A results dialog opens that shows you the history of the values.

Video: Copy key date

The explanation of each step in detail

How to copy a key date in the Master value manager:

  1. In the "*Content" ribbon, in the "Master values" group, click the "Master value manager" button.
    → The Master value manager opens.

  2. Select the key date you want to copy.

  3. In the Master value manager, in the Administration group, click the "Copy key date" button.
    → A dialog opens.

  4. Where you can assign a new date for the key date copy.

  5. Confirm by clicking "OK".
    → The key date with the associated values was copied and given a new date.


See also

Navigation hoch.svg The functions of the master value manager
Navigation rechts.svg Additional functions in the master value manager


Further contents

firesys website
Customer area
YouTube