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

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(Eine dazwischenliegende Version von einem anderen Benutzer wird nicht angezeigt)
Zeile 2: Zeile 2:




<center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto>
<center>
<div style="font-weight:bolder;line-height:1.8;">The explanation of the individual steps in detail</div>
<div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto>
<div class="mw-collapsible-content">
<div style="font-weight:bolder;line-height:1.8;">The explanation of the individual steps in detail</div>
<p align="left">To create a manual rounding for an account calculation/aggregate of accounts: <br><br>
<div class="mw-collapsible-content">
<p align="left">
<ul>
  <li> <p align="left">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.</li>
  <li> <p align="left">Click on the “Insert” button in the “*Content” menu ribbon in the "Master values" group. </li>
  <li> <p align="left">In the selection dialogue that then appears, select the option “Master value”.
  The task pane “Insert values” opens on the right.  </li>
  <li> <p align="left">Select “Account calculations and account aggregates” from the drop-down menu under “Data type”. </li>
  <li> <p align="left">Then assign the desired account group and the desired key date. </li>
  <li> <p align="left">Select an account calculation or account aggregate below.</li>
  <li> <p align="left">Click on the symbol “Open the rounding wizard” in the group “Actions”.
  The rounding wizard opens. </li>
  <li> <p align="left">Select manual rounding in the drop-down menu under “Rounding type”.    </li>
  <li> <p align="left">Enter the desired value under “Manual rounding value”. </li>
  <li> <p align="left">Confirm your entry with “Ok”. </li>
  <li> <p align="left">Select the rounded account calculation/account aggregate in the task pane. </li>
  <li> <p align="left">Click on the button “Insert selected value” in the group “Actions”.
    The account calculation/account aggregate is inserted.  </li>  


</ul>
<p align="left">To create a manual rounding for an account calculation/aggregate of accounts: <br><br>
</p>


<ol>
<li> <p align="left">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.</li>
<li> <p align="left">Click on the “Insert” button in the “*Content” menu ribbon in the "Master values" group. </li>
<li> <p align="left">In the selection dialogue that then appears, select the option “Master value”.
<br> &rarr;  The task pane “Insert values” opens on the right.  </li>
<li> <p align="left">Select “Account calculations and account aggregates” from the drop-down menu under “Data type”. </li>
<li> <p align="left">Then assign the desired account group and the desired key date. </li>
<li> <p align="left">Select an account calculation or account aggregate below.</li>
<li> <p align="left">Click on the symbol “Open the rounding wizard” in the group “Actions”.
<br> &rarr;  The rounding wizard opens. </li>
<li> <p align="left">Select manual rounding in the drop-down menu under “Rounding type”. </li>
<li> <p align="left">Enter the desired value under “Manual rounding value”. </li>
<li> <p align="left">Confirm your entry with “Ok”. </li>
<li> <p align="left">Select the rounded account calculation/account aggregate in the task pane. </li>
<li> <p align="left">Click on the button “Insert selected value” in the group “Actions”.
<br> &rarr; The account calculation/account aggregate is inserted.  </li>
</ol>
</center>  
</center>  
 
</div>
</div></div>
</div>

Aktuelle Version vom 8. August 2023, 13:02 Uhr


The explanation of the individual steps in detail

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

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

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

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

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

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

  6. Select an account calculation or account aggregate below.

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

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

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

  10. Confirm your entry with “Ok”.

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

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