Data Collection Report (Financial Consolidation)

Data Collection Report gives you access to Data Management Tools where you can bring forward your balances and initialize permanent journal entries. You can access the outcomes in the following reports:

  • Trial Balance

  • Posting Journal

  • Intercompany Report

Finally, you see the overview of data validation results and active workflow statuses on the legal entity level.

Report Heading

The report heading is dynamically updated as various reporting options are selected. Below it shows the scope for Actual, 2020-12_YTD.

The logo can be changed in Administration; see Configuring Design Elements for more on report design. You can select your base elements in the ComboBoxes below the report heading:

The Version dimension separates actual figures from planning figures, see full article. The Month_YTD dimension accumulates float values from the beginning of the calendar year to the current date, while respectively holding the final figure for stock values. The Workflow field shows the status of a current workflow. In case there is no active workflow, the field remains empty.

Data Management Tools

The buttons are described as below:

Button Description Implementation
Bring Balances Forward

Brings the closing balance of the previous reporting period to the opening balance of the current reporting period: Copies balance sheet amounts from the closing transaction type of the prior reporting period to the opening transaction type of the current reporting period. The current reporting period is identified by the Version and Month_YTD selection. The prior reporting period is the combination of the previous version and the prior period.

Examples (depending on the configuration): The prior reporting period of Budget 2021-03_YTD is Forecast 6+6, 2020-12_YTD. The prior reporting period of Forecast 6+6 2020-12_YTD is Actual 2019-12_YTD.

The procedure operates only on the collected separate financial statements. For balance sheet accounts using the Historic conversion type, the converted amounts are brought forward as well.

Runs the xdac30_40_Bring balances forward_loop job from the Data Management Integrator project. The job is executed with the following parameters:

xfss05_SolutionDatabase: The database name (without connection)

xdpj03_Version_pattern: Selected version in quotes (e.g., to allow for a plus sign) and as RegEx pattern

xdpj03_Month_YTD_pattern: RegEx pattern denoting the yyyy consolidated element or one single yyyy-MM_YTD element.

The procedure identifies the previous version by the Previous Version attribute of the selected element in the Version dimension and the Prior Period attribute of the selected element in the Month_YTD dimension.

The procedures processes data from the slice Transaction Type:T999, Consolidation:Local GAAP, Scope:~, Balance Sheet_measure:Value and the LC and historic converted amounts in the Currency dimension. Data is written to the T000 (Closing) element of the Transaction Type dimension. For BS Account elements having the Conversion Type attribute set to Historic also the currency converted amounts for all target currencies (e.g., > USD) are copied to the historic converted base elements (e.g., USD_Historic) in the Currency dimension.

Initialize Permanent Journal Entries

Brings the journal entries of the previous reporting period to the current reporting period.

The current reporting period is identified by the Version and Month_YTD selection. The prior reporting period is the combination of the previous version and the prior period.

Runs the xdij01_170_Initialize_permanent_journal_entries job from the Posting Journal Integrator project.

The job is executed with the following parameters:

de02_Destination_Month_YTD: Time period where the journal entry is to be transferred to.

de02_Source_Month_YTD: Time period where the journal entry is saved before running the process.

de01_Destination_Version: Version where journal entry is to be transferred to.

de01_Source_Version: Version where journal entry is saved before running the process.

de02_RetainedEarningsAccount: Default Retained Earnings Account (ResourcesFinancialConsolidation!rngBSAccountRetainedEarnings) from Resources Report.

Reports

The Reports’ section links to the following reports:

  • The Trial Balance button opens the Financial Consolidation Trial Balance report, where you can see the assets movements dependent on the selected legal entity.

  • The Manual Journal Entries button opens the Financial Consolidation Posting Journal report, which gives you the journal entries’ overview.

  • The Intercompany Matrix button opens the Financial Consolidation Intercompany Matrix report, where you can see the number of intercompany amounts per legal entity.

Data Validation

The Data Validation table depicts the overview of failed data validations per Legal Entity and Cube. In case any configuration validation has failed, the user can access the Data Validation Results Report and the Data Validation Details Report to find the validation that has failed and why it has failed by clicking on the blue arrow in the according cell.

Workflow

The Workflow table depicts the workflow status overview per legal entity. Click on the blue arrow to see workflow details. In case no workflow is active, the fields remain empty.

Updated March 27, 2024