Calculate Movements (from Closing Balance Input)

The Calculate Movements rule is optional and is based on Movement and Account dimension settings.

Level 0 Movement dimension members can be configured for use as the calculated movement member for one or more accounts. Accounts can then be configured to calculate the current period movement based on a Closing Balance Input amount. The calculated movement amount is posted to the selected movement for that account. A default movement can be applied whenever an individual level 0 account has not been assigned a calculated movement member.

The rule calculates the difference between the Closing Balance Input amount and the sum of the current period Opening Balance plus any other movement data already posted to the account. The calculated difference is posted to the movement member designated for the account. Note that the data posted by the system rule is treated as if it had been entered by a user. If subsequent data entry populates other movement members, the calculated member is not reset or recalculated until this rule is re-executed. If the designated movement for an account has been changed through metadata maintenance after the rule has been executed once, the originally calculated amount will not be cleared when the rule re-executes but will retain its value, as if a user had entered the data.

The Calculate Movements system rule can be enabled or disabled at any time from the Local Currency tab on the Consolidation: Process screen. Enabling or disabling of the rule is only editable on the Local Currency tab. If the rule is enabled at Local Currency, it is also enabled for Parent Input on the Translated tab, and Contribution Input on the Consolidated tab. If disabled on the Local Currency tab, it is disabled for all Input members on all tabs.

The Calculate Movements rule is only displayed on the Translated tab if Parent Input has been enabled from Application Creation or Enable Features. It is only displayed on the Consolidated tab if Contribution Input has been enabled.

To enable the Calculate Movements system rule:

  1. On the Home page, click Application, then click Consolidation.
  2. Select the Consolidation: Process tab if it is not already selected.
  3. To calculate movements from Closing Balance Input entries:
    1. Select the Local Currency tab.
    2. Select the Calculate Movements rule.
    3. From the right panel, change Enabled to Yes.

You can use a substitution variable to control the sequence of the Calculate Movements system rule. If you add the CalcMvmtsPostFCCS10 substitution variable and set the value to True, the Calculate Movements rule will run after the FCCS_10 rule. If this substitution variable does not exist, or exists but is not set to True, then the Calculate Movements system rule will run before the FCCS_10 rule.

For details of how to configure the Movement and Account metadata settings, see Defining Account Properties and Setting Account Attribute Values.


If you choose to unpost a journal posted at Closing Balance Input / Periodic of an account, it will not automatically recalculate your default movement calculation at this time.

If it is the only journal that affects the Closing Balance Input member at the same Point of View (Account, Data Source, Intercompany, Entity, Custom, Consolidation), you will need a fix journal to clear the data at the default movement of the same POV created. To do this:

  1. Create a fix journal with the reverse value that is in the default movement using appropriate debits and credits for corresponding account types.
  2. Post the journal that has the fix. The data will now be cleared for the default movement member.

Watch the following video to learn more about the Calculate Movements rule:

Video iconCalculating Movements from Closing Balance Input