This report enables you to view the closing movement for the last period of the previous year, along with the opening movement for the period selected, and any difference between the amounts.

Prerequisites

The system requires these member tags for the report:

DimensionElementTag
AccountBalance Sheet#BalanceSheet
AuditContribution#Contribution
DataViewAll Values (Main DataView structure)#AllDataViews
EntityTotal Group (Main entity structure)#TotalGroup
IntercompanyTotal Group (Main entity structure)#TotalGroup
MeasureAmount#Amount
MovementClosing#Closing
MovementOpening#Opening
ScenarioActual#Actual

Note: Member tagging is done within the Anaplan Financial Consolidation Model Manager.

The system also requires global variables for the report.

Variable NameValue
CurrentPeriodThis should be set to the name of the current period element, for example: 2025 P3.

Access the report

To access the report:

  1. Select the Explorer module.
  2. Expand the Global > Consolidation > Reports.
  3. Right-click the Validation – Opening Period report, and select Open. Alternatively, double-click the report to open it.
    You can also open the report via the Opening Validation link in the Validations Rules form.

Note: Your administrator may have moved the report to another location, or it may be started as part of a process.

Parameters

The key parameters of the report are:

Variable NameValue
EntitySelect an Entity member.
AuditSelect an Audit member.
CurrencySelect a Currency.
PeriodIt defaults to the value set in the Global Variable CurrentPeriod.
ScenarioIt defaults to the Scenario tagged as #Actual.

Note: You are required to select the parameters only if the report is run directly from the Explorer and not through the Movement Validation link in the Validation Rules form.

View the report

After selecting the parameters, the report shows the balance sheet information for both the closing and opening movements. This includes a column indicating any discrepancies in the movements. The report displays:

DimensionMember(s)
Columns

Movements:

  • Closing, last period of previous year, and Opening, Date parameter selected.
  • The difference column shows Opening – Closing. It's highlighted in red, if not 0.
  • The Check column shows a green checkmark if the difference is 0. Otherwise, a red X will be displayed.
RowsAccounts: Members under the account tagged as #BalanceSheet.