Transforming local currency data into YTD in Financial Consolidation

Transforming periodic source data into YTD amounts

If the YTD Load property in the Entities business object is FALSE, then this logic is used for loading data:

  • YTD values for the selected period and entity are calculated by aggregating data from that selected period, all previous periods, and an opening balance. An opening balance is stored as period 0 in the BudgetingMain integration table. For example, for the selected period 3-2022, the aggregated data includes period 0-2022 from the BudgetingMain table and periods 1-2022, 2-2022, and 3-2022.
  • YTD for period 12 is calculated by aggregating data from periods 0 to 12 and, if any records exist, from periods 13 to 16. For example, for the selected period 12-2022, the aggregated data includes period 0-2022 from the BudgetingMain table and periods from 1-2022 to 16-2022.
Note: You can decide whether to load opening balances into Financial Consolidation. If you do not load opening balances, then you must run the Carry Forward process to calculate the opening and closing balances.

Transforming YTD source data into YTD amounts

If the YTD Load property in the Entities business object is TRUE, then this logic is used for loading data:

  • Loading YTD values consists of aggregation of all records from the selected period. For example, for the selected period 3-2022, the aggregated data includes all records from period 3-2022 from the BudgetingMain table.
  • Opening balances for each period are loaded by populating the corresponding opening balance element in the ScheduleDetail column. For example, for a record in which the group account has the D schedule assigned, the ScheduleDetail column for the opening balance must contain the D_OB value. See "Loading opening balances into Financial Consolidation" for details about schedule details and opening balances.
  • If the data set for each fiscal year period does not contain opening balances, then the YTD values are considered during a data load. Those YTD values already contain the opening balances. For example, if period 1-2022 does not contain an opening balance reference in the ScheduleDetail column in the BudgetingMain table, then the opening balance is included in the amount for period 1-2022.

Only data for periods 1-12 can be loaded from the integration tables with this logic. Records with other periods cannot be loaded. For example, records for periods 13 to 16 can be loaded only as periodic data. YTD source data for period 12 already includes data from periods 13 to 16.