Carry-Forward Rules

You use carry-forward processing to initialize beginning balances when a new fiscal cycle starts.

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

Flow_Type in the Flow dimension
DataSrc_Type in the DataSrc dimension

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.

In a legal consolidation application, such balances are typically 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.

Note Note

Currently this procedure is only limited to the copy of the opening balances as found in the DATASRC dimension members flagged as I and M in the DATASRC_TYPE property. This means that the procedure only copies 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.

End of the note.

The copy-opening process is handled by a stored procedure called SPCOPYOPENING. This procedure is launched using the logic statement:

*RUN_STORED_PROCEDURE=SPCOPYOPENING(parameters list)

Example:

*RUN_STORED_PROCEDURE=SPCOPYOPENING([%APP%], [%CATEGORY_SET%], [%CURRENCY_SET%], [%SCOPETABLE%], [%LOGTABLE%] )

For information on required properties of the Category dimension, see Dimensions Setup for Consolidations. The following table describes the values you can enter for the carry-forward rules.

Field name	Description
Source account	This field controls the rule to apply to a given account. This field may contain the following values: A valid base level or parent level member ID from the `ACCOUNT` dimension A list of members of the `ACCOUNT` dimension, as defined filtering the members using a value of the `DIMLIST` property (or any property whose name begins with `DIMLIST`) in such dimension
Source flow	This field controls the applicability of the rule to a given member of the `FLOW` dimension. Typically this field contains the ID of the closing balance member. Valid values for this field are identical to the source account above.
Destination account	This is the destination account for the rule. Valid values for this field are identical to Source Account above. If left blank, the destination account is the same as the source account.
Destination flow	This field controls the ID of the destination `FLOW`. If left blank the `FLOW` is the same as the source `FLOW`. Valid values for this field are identical to the source account above.
Reverse sign	If selected, the system reverses the value of the amount.
Data source type	Input Only, Manual Only, or ALL.
Same period	If selected, the source `TIME` period is the same as the destination.
Apply to YTD	If selected, the YTD value to copy is calculated if it is a PERIODIC application.
Remark	A description for this rule.