Skip to Content
avatar image
Former Member

Calculating Closing Flow in Consolidation YTD model

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers