Dear Expert,

I am working on the consolidation YTD model for the first time.

We are using the following logic for Flow dimension.

Op TB - F100 (At start of the Year)

Movements from SAP gets booked in F120 & F121 (For Assets addition & Reduction)

All Blank Flows come in F_Input (Will include P&L And BS accounts)

Consolidation works on F999 (i.e Closing flow).

Question:

1. I am not sure whether i am required to calculate the closing flow every month and carry forward to calculate the opening flow.

2. If it is required to calculate the closing flow every month then can it be done through Business rule or we have to write a script.

Regards