Balance sheet elimination continuity schedule

Once you enter the movement information, the variation calculation runs to recalculate the variation (Year 1)  amount. This form is similar to the Balance Sheet Continuity Schedule, but it only allows submission to elimination entities.  Select the Currency and Audit parameters.

Movement classification within the Financial Consolidation application allows administrators to control what Movements are displayed and which movement and account combinations are available for Input. It also enables defining which movement and account combinations require intercompany-level input. It means they'll be protected, and data will only be allowed to be input at the trading partner level.

The system requires these member tags for the Balance Sheet Elimination Continuity Schedule input form:

You must set these SysNames in the Movement dimension:

The system also requires global variables for the input form.

Audit members must be set as the p_Audit property in the entity dimension. Data input into the balance sheet continuity schedule will be input to the audit member set on the selected entity parameter.

To access the Balance Sheet Elimination Continuity Schedule input form:

1. Select the Explorer module.
2. Expand the Global > Consolidation > Input.
3. Right-click the form and select Open. Alternatively, double-click the form to open it.

The key parameters of the input form are:

Once you have selected the parameters, the input form displays:

• The account parameter selected.
• Columns display Movements. The account movement classification defines the movements displayed. Elements tagged under #CTA, and #Scope are always hidden.
  Refer to Movement Classification to know more.
• The last two columns should be the difference between closing – (Opening + all movements) and a check column showing if the difference is zero.

In the form, if the cell is:

• Pale yellow: The movement classification allows input for that account.
• Dark yellow: The movement classification requires intercompany input for that account. You can right-click on the cell and select Intercompany Detail to launch the form. 
• White: All white cells are protected.  

Dropdown lists in an input template that are selectable are white with blue text.

These columns, if displayed, are only in read-only mode:

• Opening
• Allocation
• Business Acquisition
• Variation (Auto)
• Variation (Year 1)
• Result of Period
• Closing
• Difference
• Check

These read-only columns are pulled from this intersection:

If you have a member tagged as #TotalIntercompanyLeaf, that member is used instead in the Intercompany dimension.

Data input into the form is submitted to the intersection below. 

Set the Global Attribute BSContinuity_SupressEmptyOpenClose to TRUE to suppress rows where both the closing and opening balances are zero in the Balance Sheet Elimination Continuity Schedule.