Copy amounts and journals window
User
Application database > Processes tile > select process > Consolidator > select Summary/step tab > select entity > (Actions section) > Utility > Copy amounts and journals
Application database > Navbar > Processes > select process > Consolidator > select Summary/step tab > select entity > (Actions section) > Utility > Copy amounts and journals
Purpose of window¶
This window allows you to copy the following:
- financial statement data and entity journals from one scenario/period to another and from one entity to another
- journals from one scenario/period to another and between entities and scenarios/periods
Note: the copying of financial statements and journals can be scheduled as a job task in the task workflow of the process steps. For more details, see Copy amounts and journals task window.
Available options
| Element | Description |
|---|---|
| Filter set | Allows you to select a set of filters from among those previously saved. : allows you to update, rename or delete the set. |
| Gross and notes | Copies Gross and notes. |
| Entity journals | Copies entity journals. |
| Consolidation journals | Copies consolidation journals. |
| Customize | |
| Gross amount | Only for Gross and notes. Copies gross amounts. |
| Reconciliation account | Only for Gross and notes. Copies reconciliation accounts. |
| IC cockpit notes | Only for Gross and notes. Copies the notes inserted in the IC entry matching step. |
| IC amounts | Only for Gross and notes. Copies intercompany entries. |
| Notes | Only for Gross and notes. Copies the notes added to cells of forms. |
| User's details and date of origin | If selected, this records the user and date of the source data on the copied data. If not selected, it records the user as the user code that performed the copy and the date as the date/time at which the copy was performed. |
| Markup | Only for Gross and notes. To be applied to the copied amount to convert it into a different unit of measurement from the one used in Copy From in the scenario. 0: no coefficient to apply. For example, to convert EUR into thousands of EUR, enter 1000 as the coefficient. |
| Transactional form | Copies data entered in one or more transactional forms. See . |
| Copy From | |
| Scenario | Source scenario(s) visible to the user. The copy can be performed from several scenarios at the same time, by choosing from among the active original scenarios on which the user is authorised. |
| Period | Source period. Only to be indicated if a single scenario has been selected in Copy From. If the period is not specified, the copy is performed from every period onto itself. This allows you to copy data for all open periods for the selected scenario. To copy data related to several but not all periods of the selected scenario, the copy must be repeated as any times as there are periods to be copied. |
| Entity | Only for Gross and notes and Entity journals. One or several source Entities. If the entity is not selected or if several entities are selected, the copy is performed from all entities onto themselves. |
| Entity 1 | Only for Consolidation journals. Filters the source data based on the first entity of the relationship. |
| Entity 2 | Only for Consolidation journals. Filters the source data based on the second entity of the relationship. |
| Advanced filters (Copy From) | |
| Origin | Enter the origin of the source data. These origins are set by default: - BREAK_BACK - INPUT_DEFORM - INPUT_WEB - MAP - QDL Only for Entity journals and Consolidation journals: the origin refers to the journal rows, not the header. |
| Category | Category on which to filter the source data. |
| Account nodes | Filters source data based on the accounts associated with one or more nodes of a given hierarchy defined on the account dimension. |
| Journal number | Only for Entity journals and Consolidation journals. Allows you to select individual source journals to further filter the data. |
| Select accounts from form | Filters source data based on the editable accounts present in one or several forms. |
| Transactional forms | Only if the copy is performed from transactional forms. Filters the source data based on the transactional forms. |
| Copy To | |
| Scenario | Active and original target scenario, editable by the user. Only one can be selected. |
| Period | One or several target periods. Must be indicated in the following cases: - The source period has been specified, so one or several target periods must be specified. - No source period has been specified and, in the source scenario, the periods are different from those of the target scenario. It does not have to be indicated in the following cases: - No source period has been specified. - The periods of the source scenario are identical to those of the target scenario. |
| Entity | Only for Gross and note and Entity journals. Target entity code. Must be indicated in order to copy data onto a single entity other than the one already indicated in Copy From. Should not be indicated in the following cases: - To copy data onto the same entity from which it will be read. - To copy data from several entities. In this case, the system performs the copy from all entities onto themselves. |
| Advanced filters (Copy To) | |
| Origin | Enter the origin that will be assigned to the copied data: - COPY_GENERAL - COPY_ORIG: the system keeps the source origin for the copied data. - INPUT_WEB |
| Category | Overrides the target category. If this is not specified, the copy is performed while keeping the source category the same. |
| Deletion policy: based on input account | If a filter is applied to the accounts, this indicates whether that filter will also be applied during the deletion of any data existing in the copy target tables. This is useful when, for example, after performing the copy filtered on a number of forms, the user wants to rerun the same copy but only for one or more forms without affecting the values of other copied forms. |
Buttons on the page
| Element | Description |
|---|---|
| Save new filters set | Saves the filters set, to be reused later. |