Show TOC

Function documentationCarry-Forward Business Rule Locate this document in the navigation structure

 

Carry-forward populates the opening balances for the new year with the closing balances of the last period of the prior year.

Features

Carry-forward rules give you the ability to generate the Opening Balance of any category based on the following properties:

  • Flow_Type in the Flow dimension

  • Category_for_ope, Opening_year, Opening_period in Category dimension

  • DataSrc_Type, Opening_Datasrc, Copyopening in the DataSrc dimension

  • Account, Opening_Account in Account dimension

  • Same_period and YTD

This procedure can be used to initialize a new reporting period with the closing balances of the last period from the previous year into the opening balances of the current period. It can also copy closing balances from a designated year and period to current period. The designated year and period can be an absolute or relative number. Sum up the balances of YTD to current period. Copy the same period balances to current period.

In a legal consolidation application, such balances are usually identified as members of the FLOW dimension. In simpler applications, however, it is also possible to store them as additional accounts in the ACCOUNT dimension.

Currently this procedure is limited to copying the opening balances as found in the DATASRC dimension members flagged as “I” and “M” in the DATASRC_TYPE property. The procedure copies only the input balances and their related manual adjustments. The balances generated automatically by the consolidation procedure (DATASRC members flagged as A) are taken care of during the consolidation process by the consolidation procedure itself.