Journal book window
User
Navigation panel > Processes > select process > Reports > Journals book
Purpose of window¶
Allows you to extract a report with all the Entity and/or Consolidation journals
Window sections
| Section | Description |
|---|---|
| General | Allows you to select the report format, scenarios/periods and the desired journal type. |
| Filter journals by | 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 only extracts data of journals belonging to entities and categories visible to the user. |
| Filter rows by | 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 |
|---|---|
| General | |
| Report format | Allows you to select the desired report type: - XLSX (default) - PDF The PDF 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. |
| Run on | Set the desired scenario type: - Original scenario (default) - Consolidation scenario: extracts consolidable amount data Note: field not visible to contributor users, who can only extract data from original scenarios. |
| Scenario /Period | Mandatory field. - When Run on Original Scenario is selected, it specifies the scenario/period used to access the dashboard. However, it is possible to change it by selecting an active original scenario/period, visible to the user and linked to the process - When Run on Consolidation Scenario is selected, it allows the selection of an active consolidation scenario/period, visible to the user and linked to the process |
| Run on Entity journals Run on Consolidation journals | Allows you to choose the type of journals that will be extracted. It is mandatory to select at least one among: - Run on Entity journals (selected by default) - Run on Consolidation journals (selected by default) In the XLSX report, the report contains one sheet for entity journals and one for consolidation journals. In the PDF report, journals follow one another in the same file. Note: this field is not visible to contributor users, who can only extract data from entity journals. |
| Filter journals by | |
| Entity filter | Allows you to apply an Entity filter: - None (default) - Entities. Allows you to select one or more Entities belonging to the selected process and scenario/period, provided they are not only counterparties or only belong to the consolidator, and are visible to the user. - Consolidator nodes. Allows you to choose one or more nodes to be consolidated that belong to the process and are visible to the user |
| Category filter | Allows you to apply a category filter: - None (default) - Category. Allows you to choose one or more categories belonging to the process, which are visible to the user and are of a type consistent with the selection made for Run on entity journals and Run on consolidation journals - Journal number. Allows you to choose one or more journals belonging to the selected scenario/period that are consistent with the selection made for Run on entity journals and Run on consolidation journals |
| Filter rows by | |
| Account type | If specified, this only allows you to recover the rows on the indicated account type: - Details - Variation - Sentence case |
| Account nature | If specified, this only allows you to recover rows on accounts of the specified nature: - Profit & Loss - Balance Sheet - Order - Other Variations - Other Stocks |
| Origin | Allows one or more sources to be selected from those consistent with the selected scenario type (Original Scenario or Consolidation Scenario). |
| 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. |
| Show only main accounts | Only extracts the rows on the most important accounts involved in the journal, or those displayed as Main accounts on Journals in the process data model. See Entity journals. |
| 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. |
| 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. When execution is complete, the system displays a log window and downloads the report in the format chosen by the user. |