Version Management
- Adam Davis
Version
The financial data in Apliqo FPM is organised by versions. There are three different types of versions.
·        The ACT – Actual is a specific version used to store the Trial Balance and other statistical data used for reporting and planning. The actual version’s data is generally sourced from external systems that have been loaded into Apliqo FPM. The actual version should reconcile to the source version so that it is the source of truth for what has happened in the organisation. The actual version’s data is read only and cannot be modified by the Apliqo FPM clients.
·        Working Budgets and Forecasts are working plans that are being developed by Apliqo FPM planners. These working plan versions allow data entry that are dynamically calculated. In the Version and Time page, the FPM Module Administrator manages the planning parameters of the working plans.
·        Archived Forecasts are snapshot versions of the working plan that are taken at the end of the planning cycle by the FPM Module Administrator. They are used for reporting and analysis by Apliqo FPM clients. There are two special archived versions used to calculate the comparative versions. The FBUD – Final Budget holds the organisations financial targets. The Last Forecast version is the last working plan that the FPM Module Administrator has archived.
Comparative Versions do not appear on the Version and Time page. The comparative versions can be found in the Version filter under Relative Version Rollups and Rolling Versions. Comparative Versions are combinations of the above versions used for reporting and planning.
PYFBUD – LY Budget | The previous year’s final budget projected forward in the current year. |
PYACT – Last Year Actual | The actual movement for the same month from the previous year projected forward to the current year. |
PYACTPYPYACT - LY Actual / LLY Actual | The actual movement for the same month two years prior to the current year, projected forward to the current year. |
ACTFCST - Actual / Forecast | The year-to-date actual movements to the current month followed by the year-to-go movements from the Last Forecast. |
ACTBUD - Actual / Budget | The year-to-date actual movements to the current month followed by the year-to-go Final Budget movements. |
ACTPYACT - Actual / LY Actual | The year-to-date actual movements to the current month followed by the year-to-go prior year’s movements. |
The current month is determined by the server clock. The current month can be fixed by the FPM Module Administrator.
The FPM Module Administrator can create variance and percentage variances between the versions. Variances are calculated as (Version A – Version B). Percentage variances are calculated as (Version A – Version B) / Version A.
The FPM Module Administrator can add and delete Working Plan Versions and Archived Version in the Version and Time page. The number of versions and the amount of period data stored in Apliqo FPM affects the amount of memory and the startup time of the Apliqo FPM model. The rule of thumb is that 20% of the server memory should be free memory that is available to the Apliqo FPM model for its calculations cache. Â
See Related
Adding an Final Forecast or Final Budget Version.