Movement
The Movement dimension captures the movement details of an account. By default, the system provides members in the Movement dimension to capture the Opening Balance, Closing Balance, changes, and FX calculations.
It is also used for Cash Flow Reporting. System members named "FCCS_Mvmts_Operating", "FCCS_Mvmts_Investing", and "FCCS_Mvmts_Financing" are created as parent accounts to enable you to create additional movement details as needed for Cash Flow reporting.
The Movement dimension enables you to perform these tasks:
-
View details of the cash flow movements when viewing the Balance Sheet
-
Automatically generate the Cash Flow due to the segregation of movements based on cash flow categories
When you create an application, the Movement dimension is created by default with seeded members, and adds system members based on the optional features that you enable. During application creation, the system creates cash flow members and hierarchies for Cash Flow Reporting in the Movement and Account dimensions.
You can create your own Movement members, but only within the FCCS_Mvmts_Subtotal parent, not within the FCCS_Mvmts_FX_Total parent.
Watch this video to learn more about setting up the Movement dimension.
Adding Movement Dimension Members
If you add Movement members, make sure that every new Movement member (Mvmts_) is added to both the FCCS_ClosingBalance and the FCCS_CashFlow hierarchies. The new Movement child member's Data Storage property in the FCCS_ClosingBalance hierarchy must be "Never Share". The same new Movement child member's Data Storage property in the FCCS_CashFlow hierarchy must be "Shared".
- For Extended Dimensionality based applications, Parents added to the FCCS_ClosingBalance hierarchy must have the Data Storage property Dynamic Calc. The exception for this use case is when a Parent has only one child member. For a Parent with only one child member, the Parent's Data Storage property must be Never Share.
-
Parents added to the FCCS_CashFlow hierarchy must have the Data Storage property Dynamic Calc.
-
Under the FCCS_ClosingBalance hierarchy, the new Movement member should have a Consolidation Operator of Addition.
-
Under the FCCS_CashFlow hierarchy, the new Movement member should have a Consolidation Operator of Subtraction.
Note:
As a best practice, it is not recommended that you create member formulas for Movement dimension members, as they will have a significant impact on consolidation performance.
Restricted Movement Members
The FCCS_Mvment_Acquisitions and FCCS_Mvmt_Disposals
Movement members are reserved for seeded calculations. You can't use
these members as destination members in Configurable Calculation (Insertion Point)
rules, On Demand rules, Translation Override rules, Data Copy rules, Data Load,
Journal Input, and Configurable Consolidation rules.
Cash Flow - Movements Sign Reversal Logic
Indirect Cash Flow presents cash flow in terms of the movements of non-cash accounts (that is, the sources and uses of cash). When you record a movement on a non-cash account, any increase in assets or expenses (DR "normal sign" accounts) causes a matching decrease in cash. Equally, any increase in liabilities, equity or revenue (CR "normal sign" accounts) causes an increase in cash.
When you present the change in cash (operating, investing, financing) in terms of the non-cash account movements, the sign of the cash movement is opposite to the sign of the related non-cash account movement for assets and expenses and the same sign for liabilities, equity and revenue.
When you present the Cash Flow statement, you use the Movement dimension members to detail the rows in the report. You also need to specify an account. You can use the top-level Balance Sheet account against which to report all movements in the Cash Flow report, because the Cash Flow report rows are sufficient to define the detail. You only need one Balance Sheet account to "gather" all movements. Generally, the top-level Balance Sheet account (which should always net to zero) is set as an Asset account.
When you report a movement posted to an Asset account as a change in cash, you need to reverse the sign, because an increase in an Asset represents a decrease in cash. When you report a movement that was posted to a Liability account as a change in cash, you also need to reverse the sign, because you are reporting against a single Balance Sheet top member that is an Asset account. An amount posted as an increase to a base Liability account will be reported at the top Balance Sheet Asset account with the opposite sign and therefore as a decrease in the total Balance Sheet amount (because as the Liability account movement entry aggregates up through the account hierarchy, the Account Type changes from Liability to Asset and therefore the sign of the data is flipped). You need to flip the sign of all non-cash movements when presenting cash flow, regardless of the Account Type on which the original posting was made.