Transforming transaction 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:
- Data is loaded from the FactsTransactionCurrency integration table. YTD values for the selected period and entity are calculated by aggregating data from that selected period and all previous periods. Opening balances in the transaction currency are not available in Financial Consolidation. For example, for the selected entity and period 3-2022, the aggregated data includes periods 1-2022, 2-2022, and 3-2022 from the FactsTransactionCurrency table.
- YTD for period 12 is calculated by aggregating data from periods 1 to 12 and, if any records exist, from periods 13 to 16. For example, for the selected period 12-2022, the aggregated data includes periods 1-2022 to 16-2022 from the FactsTransactionCurrency table.
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 FactsTransactionCurrency table.
- Opening balances are not available for data in the transaction currency in Financial Consolidation.
- Only data for periods 1-12 can be loaded from the integration tables. 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.