A common requirement for implementation of Apliqo FPM is to load the initial budget for the organisation. This can be done by load loading the budget through the FIN General Ledger TB cube. In the following exercise this training we are loading going to load the 2023 and 2024 budget budgets for Company 1000 using the Ad-hoc Data Intergration functionality. Once the budget has been loaded to the FIN General Ledger TB cube, we will use the Initialise Budget round trip to post the data to the FIN General Ledger cube and the planning cubes.
Ad-hoc Data Load
Ad-hoc data loads can be accessed at Administration > Data Integration > Data Processing > Stage Ad-hoc Data.
...
For this walk-through the 2023 budget for Company 1000 has been provide at in a CSV named, Budget_1000_2023.csv. This field file is already loaded in the SourceData directory as set in the Apliqo FPM Settings.
The field delimiter in the file is a ';'.
There are no thousand separates or quote makes around the values.
There is one header row.
The movement are in the same signature signage that we use for management reporting. That means the movements Liabilities and Revenues are expressed as positives and Expenses are expressed as negatives. For this reason, we are going to load the budget to OPV element in the FIN Consolidated Value Measure dimension, not under the TB consolidation.
The column of the are as follows:
...
Once the data source has been defined, mapped and restricted it is ready to be loaded to the target cube. This is done by clicking on the Load button on the Load to Target widget.
...
Currency Version
To calculate the reporting currencies the Currency version needs to be set for the FBUD version. This can be done Administration > Currency Conversion. Open the Version Setup popup to set the currency version for the FBUD version.
...
Roundtrip
Now the budget has load we need to run the roundtrip to calculate the FBUD version in the FIN General Ledger. Follow the walk-through to create the roundtrip to process the budget.
...
Exercise
Now that we have loaded the Budget 2023 repeat the steps to load 2024 Budget.
For this exercise the 2024 budget for Company 1000 has been provide at a CSV named, Budget_1000_2024.csv. This file is in the SourceData directory as set in the Apliqo FPM Settings.
The field delimiter in the file is a ';'.
There are no thousand separates or quote makes around the values.
There is one header row.
The movement are in the same signage that we use for management reporting. That means the movements Liabilities and Revenues are expressed as positives and Expenses are expressed as negatives. For this reason, we are going to load the budget to OPV element in the FIN Consolidated Value Measure dimension.
...