CARRYFORWARD_AND_COMMIT

CARRYFORWARD_AND_COMMIT()

This formula performs a carry-forward of last year closing value into current period. CARRYFORWARD_AND_COMMIT requires the property OPE in the Account dimension (ID of the opening account). This formula must be executed from a DTS package in LGF format (prompting for category and time). For this reason it is not suitable to be used in a default formula sheet.

To use this formula, add a property called OPE to the account dimension, and enter the ID of the accounts where the opening value should be stored into the appropriate accounts.

Define a logic containing the line:

CARRYFORWARD_AND_COMMIT()

Then run this logic from a DTS package that calls it using explicitly the extension LGF.