Cash flow when BS movements are present in Accounts

Summary:

Implementing out-of-box cash flow in a scenario where CoA roll-up itself has movement breakup (eg. PPE - Opening, PPE - Additions, PPE - Disposals)

Content (please ensure you mask any confidential information):

We are trying to implement an automated cash flow for a client leveraging movement dimension in FCCS. However, we are facing the below challenge.

The CoA roll-up has different accounts for different movements that make up the closing balance (eg. PPE - Opening, PPE - Additions, PPE - Disposals) which represents movement in itself.

If we implement the OOB approach, the movement dimension would calculate an inaccurate cash flow movement. Also, for the opening balance codes, the client does roll forward from the movement GL codes to the opening GL codes in the ledger - leading to changes in Opening balance codes every period and FCCS would correspondingly assume a movement between periods which necessarily isn't a cash flow movement.