Copy amounts and journals task window
User
Application database > Data Processing tile > Jobs > Choose Job > 
> Show graph > Edit > Other activities > Copy amounts and journals
Application database > Navbar > Data Processing tile > Jobs > Choose Job > > Show graph > Edit > Other activities > Copy amounts and journals
Purpose of window¶
This window allows you to schedule the copying of amounts and journals.
Available options
| Element | Description |
|---|---|
| Gross amount | Copies gross amounts. |
| Entity journals | Copies entity journals. |
| Consolidation journals | Copies consolidation journals. |
General parameters¶
| Element | Description |
|---|---|
| Amount type | Source data type: - Original - Proportional - Converted - Consolidable |
| Markup | Coefficient 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. Note: for example, to convert EUR into thousands of EUR, enter 1000 as the coefficient. |
| 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. |
| Copy From | |
| Scenario | Source scenario(s). |
| Period | Source period. If the period is not specified, the copy is performed for every period, onto itself. This allows you to copy data for all open periods for the selected scenario. To copy data for several periods, you can use multi-selection if you want to copy only some of the scenario periods onto their target scenario counterparts. If you want to copy individual periods onto periods other than the target scenario, you need to repeat the copy function as many times as there are periods to be copied. |
| Copy to | |
| Process | Target process. |
| Scenario | Active original target scenario onto which to copy user-editable data. Only one can be selected. |
| Period | Target period. To be indicated in the following cases: - If the source period has been specified then that and the target periods should be specified. - The source period has not been specified and the open periods for the source scenario are different from those of the target scenario. This does not need to be indicated if the source period has not been specified and the open periods for the source scenario are the same as those of the target scenario. |
| 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 |
| Account hierarchy | Filters the source data according to the indicated hierarchy. |
| Account node | Filters source data based on one or more accounts related to the nodes of a given hierarchy defined on the account dimension. |
| Form | Filters source data based on the accounts present in the form or in the specified forms. |
| Advanced filters (Copy to) | |
| Origin | Enter the origin of the copied data: - COPY_GENERAL - COPY_ORIG: the system keeps the source origin for the copied data. - INPUT_WEB |
| Origin to delete | - COPY_GENERAL - COPY_ORIG: the system keeps the source origin for the copied data. - INPUT_WEB |
| 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 a certain form without affecting the values of other copied forms. |
Gross amounts & Entity journals¶
| Element | Description |
|---|---|
| Gross amount customisation | |
| Gross amount | Copies gross amounts. |
| Reconciliation account | Copies reconciliation accounts. |
| IC cockpit notes | Copies the notes inserted in the IC entry matching step. |
| IC amounts | Copies intercompany amounts. |
| Notes | Copies the notes inserted in the cells of a form. |
| Transactional form | Copies data entered in one or more transactional forms. |
| Copy From | |
| Entity | Source entity(ies). If the entity is not selected or if several entities are selected, the copy is performed from an entity onto itself. |
| Copy to | |
| Entity | Copy target entity code. This must be indicated to copy data onto a different entity from the one previously indicated in Copy From. This does not need to be indicated in the following cases: - if you want to copy data onto the same entity from which it will be read - if you want to copy data from several entities. In this case, the system performs the copy from an entity onto itself. |
| Gross amounts: advanced filters (Copy From) | |
| Category | Category on which to filter source data |
| Note - Category | Category on which to filter source notes |
| Transactional form - Category | Category on which to filter source data entered in transactional forms |
| Form | The system filters the data entered in the accounts contained in the selected forms |
| Gross amounts: advanced filters (Copy to) | |
| Category | Overrides the target category. If this is not specified, the data is copied onto the same category. |
| Note - Category | Overrides the category onto which to copy notes. If this is not specified, notes are copied onto the same category. |
| Transactional form - Category | Overrides the category onto which to copy data entered in transactional forms. If this is not specified, the data is copied onto the same category. |
| Entity journals: advanced filters (Copy From) | |
| Category | Overrides the category for which to filter the source journals. |
| Journal number | Filter journals based on journal number code. |
| Entity journals: advanced filters (Copy to) | |
| Category | Overrides the category onto which to copy journals. If this is not specified, the copy is performed while keeping the source category the same. |
Consolidation journals¶
| Element | Description |
|---|---|
| Copy From | |
| Entity 1 | Filters the source data based on the first entity of the relationship. |
| Entity 2 | Filters the source data based on the second entity of the relationship. |
| Copy to | |
| Advanced filters (Copy From) | |
| Category | Category on which to filter the source data. |
| Journal number | Allows you to select individual source journals to further filter the source data. |
| Advanced filters (Copy to) | |
| Category | Overrides the target category. If this is not specified, the copy is performed while keeping the source category the same. |