Opening Balance Transfer

<< >>

Opening Balance Transfer

Files: UI_P_IDT_OpeningBalance_FAS.xml

Using the Opening balance transfer task, you can transfer the closing balance from period 12 of the previous year (from the selected data type) to period 0 of the selected year as the opening balance. Inventory data (inventory value and margin and tax percents) from period 12 of the previous year is also transferred to the selected year as opening values. If necessary, the transfer can be performed more than once. The accounts of transfer are selected from the account hierarchy ACCHIER7P, the default selection is specified in the user interface task.

After the transfer input data calculations are run for the target data automatically.

The default target year for the transfer is the current year (set with the %GLOBAL YEAR% parameter). Note that you need to select the correct source year on the Source Options 1 tab. By default, cumulative figures are transferred (target option: Cumulative), and the cumulative figures of periods starting from 1 do not change.

Opening balance account: The cumulative total should remain unchanged for the whole year both in unit and group currency. The periodic data of period 1 is not changed, so if the transfer is executed after input to period 1, the cumulative period 1 amount might require manual adjustment.

Other accounts: The cumulative amount of period 1 remains the same after the run.

If you want the cumulative figures of period 1 to change, select the Periodical option on the Target Options tab.

The following conversion tables are used for the opening balance transfer:

Account conversion table: Account conversions for opening balance transfer, other than internal transactions (ID: AccountsOpeningBalanceFAS, Type: Account)

Period conversion table: Period conversion for opening balance transfer (ID: PeriodsOpeningBalance, Type: Period)

For more information about the Internal Data Transfer function, refer to Clausion Financial Performance Management Administrator's Guide.