Journals book window (consolidator)
User
Application database > Processes tile > select process > Consolidator > select Summary or step tab > select entity > (Actions section) > Process reports > Journals book
Application database > Navbar > Processes > select process > Consolidator >select Summary/step tab > select entity > (Actions section) > Process reports > Journals book
Purpose of window¶
Allows you to extract a report with all the consolidation journals on the selected nodes.
Window sections
| Section | Description |
|---|---|
| Report format | Allows you to select the format of the report. |
| Scenario /Period | Allows you to select the desired scenario/period. |
| Journals filter | Allows you to specify any filters to be applied to journal headers, in order to extract only the desired journals and limit the volume of data extracted. Note: regardless of the filters applied, the system will only extract data from journals belonging to entities or consolidator nodes selected in the cockpit and in categories visible to the user. |
| Rows filter | Allows you to specify any filters to be applied to journal rows, in order to extract only the desired rows and limit the volume of data extracted. Note: regardless of the filters applied, only rows with amounts other than zero and rows on accounts visible to the user will be extracted. |
| Grouping and Sorting | Allows you to specify how the extracted data is grouped and sorted. |
Options in the sections
| Element | Description |
|---|---|
| Report format | |
| XLSX | Generates the report in XLSX format. |
| Generates the report in PDF format. This format has some limitations and must be extracted without journals grouping and with rows grouping set to summary with origin. Additionally, for the journal rows, it only displays the main information. This report is not available for processes with relationship type equal to by entity - custom dimension 2 or by entity - synthetic custom dimension 2. | |
| Scenario /Period | |
| Scenario type | Set the desired scenario type. - Original scenarios - Consolidation scenarios: extracts consolidable amount data Note: field is not visible to contributor users, who can only extract data from original scenarios. |
| Scenario /Period | Mandatory field. - With the Consolidation scenarios type selected, this allows you to choose an active consolidation scenario/period that is visible to the user and linked to the process. - With the Original scenarios type selected, indicates the scenario/period from which the cockpit was accessed. Can only be changed in single submission processes. |
| Journals filter | |
| Category type | Journal type to be exported. If not specified, both entity journals and consolidation journals will be extracted. The XLSX report contains one spreadsheet for entity journals and one spreadsheet for consolidation journals. In the PDF report, journals follow one another in the same file. Those journals appear on different spreadsheets in the XLSX report and in sequence in the PDF report. |
| Category | Only with Category node not selected. Allows you to select one or several categories from among those visible to the user. Allows you to select the Entity Journals, Consolidator Entity Journals and Consolidation Journals category types, in line with the value selected in Category type. |
| Category node | Only with Category not selected. Allows you to select a grouping of categories from among those with at least one category visible to the user. If a value is specified, the system extracts the journal data on categories belonging to the selected node, going down recursively to the last level. |
| Journal number | Allows you to select one or several journals belonging to the selected scenario/period. |
| Rows filter | |
| Show only main accounts | Only extracts the rows on the most important accounts involved in the journal, i.e. the accounts which are displayed as Main accounts on Journals in the data model. See . |
| Exclude Result accounts and Variation | Selected by default. The extraction excludes rows on accounts that belong to the set of result accounts specified from among the requirements of the process’s calculation logics. In particular, the P&L result account, the BS result account and their variations (determined taking account only of control groups belonging to the process) are excluded. |
| Account type | If specified, this only allows you to recover the rows on the indicated account type: - Detail - Variation - Normal (default) |
| Account nature | If specified, this only allows you to recover rows on accounts of the specified nature: - Profit & Loss - Balance Sheet - Memorandum - Other Variations - Other stocks |
| Show Counterparty | Enters information related to the counterparty (counterparty entity, CTP custom dimension 2, transaction currency, transaction currency amount, total CTP amounts) in the reports. |
| Hide rows set to 0 | The extraction excludes rows that, maintaining the same account, balance custom dimensions and counterparty. |
| Origin | Allows you to select one or several origins from among those that are consistent with the selected Scenario Type. |
| Grouping and Sorting | |
| Journals grouping | Ways in which journal headers must be grouped: - |
| Journals order | Ways in which journal headers can be ordered: - Journal number (default) - Category / Journal number |
| Rows grouping | Ways in which journal rows can be grouped: - Analytic (default): no grouping - Synthetic: grouping by account, custom dimensions and counterparty - Synthetic with origin: grouping by account, custom dimensions, counterparty and origin |
| Rows order | Ways in which journal rows can be ordered: - Account/Origin (default) - Origin/Account |
Buttons in the window
| Element | Description |
|---|---|
| Run | Runs the report. Once complete, the system displays a log window and downloads the report in XLSX format. |
| Cancel | Closes the window. |