To execute the Consolidation , open the BFC Process Manager Capsule, and click on the Consolidation Process Execution Button.
Now tick the check-box of the Scenario and Period and Consolidation Node (Scope) on which the Process should work and Click the central Button tooltipped as : "Execute Consolidation" .
Procedure Execution
> the procedure takes some times dependently from the general settings, the number of nodes and RULEs etc : thankful to the adopted data model the execution time doesn't vary too much even for large group.
> the procedure can run on the selection of ONE combination of Scenarios and Period. To prevent multiple choices a Validation is executed at the beginning of the 040 - Consolidation Procedure.
> the procedure can run on the selection of multiple nodes ; to improve performance restrict the selection to one or few nodes only.
> only the Open periods that have not been closed or archived yet are available for selection. This prevents the possibility to re-run the consolidation on locked data. Please refer to Scenario Manager section for details.
Depending
from the configuration of user privileges and licenses the user can potentially
alter the selections and re-run the Consolidation on closed period. To
prevent this there is a preliminary check of the Status of the Scenario
at the beginning of the 040 - Consolidation Procedure.
The Execution of the Consolidation Procedure can be "live" monitored using the Screen C - 010 Balance Sheet All Layers that also provides a first Data Verification Check.
Process Audit Trail
Clicking on the Master Layout Icon on a specific Scenario and Month the below report, indicates the Last Time a critical Process Step has been executed. This helps to check the update of the System and prevents that some steps are missed.
A pre-Defined List of Items is given :
| Task | Consolidation Step |
| 00 - Application Settings | Application Setup |
| 05 - Conso Scope Setup | Consolidation Scope Setup |
| 10 - Exchange Rate Setup | Consolidation Rates Setup |
| 15 - LEs TB Loaded | Legal Entities Trial Balances Loaded |
| 20 - LEs TBs Validated | Legal Entities Trial Balances Validated |
| 25 - LEs IC TBs reconciled | Reconciliation of IC Trial Balances |
| 30 - TBs Movements Done | Manual Data Entry of Movement Details |
| 40 - TBs IC Done | Manual Data Entry of IC Details |
| 50 - Group Adjustment Done | Group Adjustment Data Entry Completed |
| 60 - Local Adjustment Done | Local Adjustment Data Entry Completed |
| 70 - Consolidation Last Execution | Run of Consolidation Procedure |
| 80 - Consolidation Validated | Consolidation output Validated |
The report reports the last time they have been executed : if any changes occurred since then you must re-execute them, and anyway we suggest to re-executed them if the time gap from the last execution to the current date is wide.
The different Tabs report To Do Item by Category providing Time Stamp information.
The Local Task that must be validate at RU level reports a Progress Status (How many RUs completed a given task on RU Total). Drilling Down you can break down by RU.
For in depth discussion please refer to Chapter 5 - The Audit Trail Process
A Pop Up message indicates that the Consolidation Procedure has been successfully completed.