Configure roll forward: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 3: Zeile 3:


<imagemap>Image:EN_Excel_Menüband_Inhalt_Vorrollen.jpg|1200px|center
<imagemap>Image:EN_Excel_Menüband_Inhalt_Vorrollen.jpg|1200px|center
rect 2 85 204 193 [[The_basic_functions_of_firesys]]
 
rect 211 82 515 192 [[The_account_workbook]]
rect 522 82 612 192 [[The_functions_of_the_master_value_manager]]
rect 614 81 698 191 [[Synchronise_and_detach]]
rect 884 82 1041 184 [[The_validation_basic_functions]]
rect 702 114 879 136 [[Synchronise_and_detach]]
rect 702 140 880 168 [[Insert_transmitter_values]]
rect 705 81 878 110 [[Insert_values_in_Excel]]
rect 1046 83 1181 190 [[An_overview_of_the_rolling_forward_function]]
desc none
desc none
</imagemap>
</imagemap>

Version vom 6. August 2020, 09:40 Uhr

When you work with firesys, you should ideally be able to work on your business reports on a long-term basis, and in doing so, prepare your report for the next quarter or financial year. The “roll forward” function can support you with this. You can use it to automatically transfer values that are located in one column in an Excel workbook to a different column after the setup process. You can use this master data to quickly and easily create a basis for additional reports.


<imagemap>Image:EN_Excel_Menüband_Inhalt_Vorrollen.jpg|1200px|center

desc none </imagemap>


The roll forward function

In the “*Content” menu ribbon, the "Roll forward" group contains all functions that you need for setting up and executing the roll forward function. The central working environment is the roll forward work area. You open and close the work area by clicking on the “Work area” button.



The figures that were located in the “2017” column are automatically transferred to the “2018” column when you execute the “roll forward” function. The roll forward function can be executed in firesys on all worksheets that are not locked and which do not contain any diagram or Pivot elements. The only requirement is that a print area is defined with which the dimensions of the table can be described in more detail. There are two different types of worksheets that can be rolled forward:


The various scenarios for rolling forward tables that....

...are newly prepared for rolling forward

→ Go to the detailed description

If you have

  • created a new table and want to prepare it generally to use the “roll forward” function,
  • or if you have a table to which the “roll forward” function was not yet applied,

you will find all of the information you require here.



...are newly prepared for rolling forward and contain values that are not dependent on key dates from the MeetingPoint

→ Go to the detailed description

If you have

  • created a new table that contains transmitter values or manual values and if you want to prepare it for using the “roll forward” function,
  • or if you have a table to which the “roll forward” function was not yet applied,


you will find all of the information you require here.



...already exist and contain values that are not dependent on key fates from the MeetingPoint

→ Go to the detailed description

If you have created a new table

  • that contains transmitter values or manual values and if you want to prepare it for using the “roll forward” function,
  • or if you have a table to which the “roll forward” function was not yet applied,

you will find all of the information you require here.



...already exist

→ Go to the detailed description

If you have

an existing table that was already used for the “roll forward” function which does not contain any numerical values from the MeetingPoint, you will find all of the information you require here.



...already exist and contain values that are dependent on key fates from the MeetingPoint

→ Go to the detailed description

If you want to edit an

existing table that was already used for the “roll forward” function and (in the meantime) contains transmitter or manual values from the MeetingPoint, you will find all of the information you require here.



...already exist and contain values that are dependent on key dates from the MeetingPoint

→ Go to the detailed description

If you want to edit an existing table

  • that was already used for the “roll forward” function and (in the meantime) contains account values or calculations from the MeetingPoint,
  • you will find all of the information you require here.



See also

Navigation hoch.svg Insert values in Excel
Navigation rechts.svg Rolling forward values from the MeetingPoint
Navigation rechts.svg Rolling forward case studies

Further contents

firesys website
Customer area
YouTube