The master value manager: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 1: | Zeile 1: | ||
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 and account | 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. | ||
<imagemap>Image:EN_Excel Menüband Inhalt Zentralwerte Zentralwert-Manager.jpg|1200px|center | <imagemap>Image:EN_Excel Menüband Inhalt Zentralwerte Zentralwert-Manager.jpg|1200px|center | ||
Zeile 10: | Zeile 10: | ||
== The master value manager interface == | == 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 and account | 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. | ||
Zeile 21: | Zeile 21: | ||
[[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=2.0|The Add dialog in the master value manager]] | ||
Here you can add a manual master value, account calculation or account | Here you can add a manual master value, account calculation, account group or account aggregates to the MeetingPoint. | ||
==== Manual value ==== | ==== Manual value ==== | ||
Zeile 43: | Zeile 43: | ||
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 calculation in which you add or subtract account values. It is necessary to give the account calculation a name. | ||
==== Account aggregate ==== | |||
You can create an account aggregate by adding account calculations to account values. As with account calculation, you must give the account aggregate a name. | |||
=== Edit === | === Edit === | ||
Change the selected manual master value. It is also possible to edit account calculations. | Change the selected manual master value. It is also possible to edit account calculations and account aggregates. | ||
=== Edit name === | === Edit name === | ||
Zeile 58: | Zeile 62: | ||
=== Delete === | === Delete === | ||
Deletes the selected master value, account groups and key dates from the MeetingPoint. | Deletes the selected master value, account groups, account aggregates and key dates from the MeetingPoint. | ||
=== Convert transmitter value === | === Convert transmitter value === | ||
Zeile 74: | Zeile 78: | ||
== [[File:Firesys Icons BubbleTransparent 2 white background.png|link=|24px]] The list == | == [[File:Firesys Icons BubbleTransparent 2 white background.png|link=|24px]] The list == | ||
In the list view, all master values, account groups | In the list view, all master values, account groups, account calculations currently and account aggregates stored in the MeetingPoint are displayed. You can display the individual values at the top right of the Central Manager using the "Expand all" or "Reduce all" button. | ||
== [[File:Firesys Icons BubbleTransparent 3 white background.png|link=|24px]] View == | == [[File:Firesys Icons BubbleTransparent 3 white background.png|link=|24px]] View == | ||
Zeile 84: | Zeile 88: | ||
<b> Search & filter </b> | <b> 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”. | ||
<b> Help </b> | <b> Help </b> |
Version vom 22. März 2021, 12:07 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.
<imagemap>Image:EN_Excel Menüband Inhalt Zentralwerte Zentralwert-Manager.jpg|1200px|center
desc none </imagemap>
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.
Management
Add
Here you can add a manual master value, account calculation, account group or account aggregates to the MeetingPoint.
Manual value
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.
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”. |
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.
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.
Account aggregate
You can create an account aggregate by adding account calculations to account values. As with account calculation, you must give the account aggregate a name.
Edit
Change the selected manual master value. It is also possible to edit account calculations and account aggregates.
Edit name
Edit the name of the selected master value. You can also rename account groups here.
Edit comment
Create or edit a comment for a single value displayed in the Master value manager.
Delete
Deletes the selected master value, account groups, account aggregates and key dates from the MeetingPoint.
Convert transmitter value
Converts the selected transmitter value into a manual master value.
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.
Display master value history
Here you can display the history of manual, sender and account values.
The list
In the list view, all master values, account groups, account calculations currently and account aggregates stored in the MeetingPoint are displayed. You can display the individual values at the top right of the Central Manager using the "Expand all" or "Reduce all" button.
View
Expand all/reduce all
Expands or reduces all objects in the list. This makes more information available to you.
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”.
Help
Opens the help area which supports you as you work.
Display central value history
How to display the master value history for manual, transmitter and account values:
-
In the "*Content" ribbon, in the "Master values" group, click the "Master value manager" button.
→ The Master value manager opens. -
Select a value.
-
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.
See also
The functions of the master value manager
Additional functions in the master value manager