Vorlage:Video-Rundungs-Assistent-Manuelle Rundung erstellen-English: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
(Die Seite wurde neu angelegt: „center|808px|border <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800…“)
 
Keine Bearbeitungszusammenfassung
Zeile 3: Zeile 3:


<center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto>
<center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto>
<div style="font-weight:bolder;line-height:1.8;">Die Erklärung der einzelnen Schritte im Detail</div>
<div style="font-weight:bolder;line-height:1.8;">The explanation of the individual steps in detail</div>
<div class="mw-collapsible-content">
<div class="mw-collapsible-content">
<p align="left">To create a manual rounding for an account calculation/aggregate of accounts: <br><br>
<p align="left">To create a manual rounding for an account calculation/aggregate of accounts: <br><br>

Version vom 23. August 2021, 13:20 Uhr


The explanation of the individual steps in detail

To create a manual rounding for an account calculation/aggregate of accounts:

  • Open an Excel workbook and select the cell on the worksheet whose account calculation or account aggregate is to be provided with a rounding value.

  • Click on the “Insert” button in the “*Content” menu ribbon in the "Master values" group.

  • In the selection dialogue that then appears, select the option “Master value”. The task pane “Insert values” opens on the right.

  • Select “Account calculations and account aggregates” from the drop-down menu under “Data type”.

  • Then assign the desired account group and the desired key date.

  • Select an account calculation or account aggregate below.

  • Click on the symbol “Open the rounding wizard” in the group “Actions”. The rounding wizard opens.

  • Select manual rounding in the drop-down menu under “Rounding type”.

  • Enter the desired value under “Manual rounding value”.

  • Confirm your entry with “Ok”.

  • Select the rounded account calculation/account aggregate in the task pane.

  • Click on the button “Insert selected value” in the group “Actions”. The account calculation/account aggregate is inserted.