The Audit Trail process keeps track of the execution of some critical Consolidation Process Steps : this guarantees a strong audit on the Process Users as a valid Check that may help during troubleshooting.
The process is based on the To Do List Items. You can add or remove Item from the List as you can decide the Verification Level of the Check (General, per Scenario and Period, per Reporting Unit).
You can also decide if the Check must be manually done of if it is linked to some automatic Consolidation process Step.
How to Setup the Audit Process
Open the 095 - Audit Trail Setting Screen in the Administration Capsule
A pre-defined List of Tasks is provided. To add a new Task click on the Insert Member Icon in the Data-view Sliding Bar. Of course New Task must be linked to Consolidation Process Logics and can't count upon pre-defined track facilities.
Each Task must be given some attributes that drive its visibility and tracking capability :
> Active Y/N : if the Task is not Active it will not be visible in the Audit Trail Report.
The
Item is not delated it is not de-activated from automatic audit
logic. It will be simply filtered in the Reports (Filter Tab). These means
you can decide to Activate or de-Activate it as you like. Such attribute
influences only the Reports Visualization.
> Edit Y/N : you can check for each task its execution (Done Y/N) and the User and Timestamp who performed it. The track of this attributes can be triggered manually if Edit is Yes, clicking on the "Done" Button. Please refer to Audit Manager Section. If Edit is N it will not be possible for the User to manually certify the execution of the Task ("Done" Button hidden).
If
you change the Edit attribute from Y to N the Track Procedure will skip
the Track Sub-Procedure and the "Done" Button will be activated.
If you change it from N to Y you have of course to implement the Track
Procedure somewhere
> Task Process :
The Task must be grouped in Task Processes :
- 01 Preliminary Process : these Tasks are preliminary and must actions before any Consolidation happens. Normally the Check happens at Application Level
- 02 Consolidation Process (Global) : these Tasks impact the Consolidation Process. Normally the Check happens at Scenario - Period Level
- 03 Consolidation Process (Local) : these Tasks impact only the Local Process (eg Data Collection). Normally the Check happens at Legal Entity - Scenario - Period Level
This
grouping logic is used to Filter the Task in the Audit-Manager Screen
Tabs.
For the default Tasks the following configuration is provided :
| Task | Consolidation Step | Capsule |
Screen | Default EDIT (Y/N) |
Default Track Level |
| 00 - Application Settings | Application Setup | Administration |
Home - Update All Settings Action | N |
Application |
| 05 - Conso Scope Setup | Consolidation Scope Setup | Process Manager |
Conso Area and Method - Confirm Action | N |
Period-Scenario |
| 10 - Exchange Rate Setup | Consolidation Rates Setup | Process Manager |
Set Currency Rates - Confirm Action | N |
Period-Scenario |
| 15 - LEs TB Loaded | Legal Entities Trial Balances Loaded | Local Reporting Local Reporting |
Batch
Data Loading
Data Flow in FC (from Bulk loader) |
N |
Application |
| 20 - LEs TBs Validated | Legal Entities Trial Balances Validated | Process Manager |
Audit Trail (Manual Done Button) | Y |
Period-Scenario-Legal Entities |
| 25 - LEs IC TBs reconciled | Reconciliation of IC Trial Balances | Process Manager |
Audit Trail (Manual Done Button) | Y |
Period-Scenario-Legal Entities |
| 30 - TBs Movements Done | Manual Data Entry of Movement Details | Process Manager |
Audit Trail (Manual Done Button) | Y |
Period-Scenario |
| 40 - TBs IC Done | Manual Data Entry of IC Details | Process Manager |
Audit Trail (Manual Done Button) | Y |
Period-Scenario |
| 50 - Group Adjustment Done | Group Adjustment Data Entry Completed | Process Manager |
Audit Trail (Manual Done Button) | Y |
Period-Scenario |
| 60 - Local Adjustment Done | Local Adjustment Data Entry Completed | Process Manager |
Audit Trail (Manual Done Button) | Y |
Period-Scenario-Legal Entities |
| 70 - Consolidation Last Execution | Run of Consolidation Procedure | Process Manager |
Consolidation Execution | N |
Period-Scenario |
| 80 - Consolidation Validated | Consolidation output Validated | Process Manager |
Audit Trail (Manual Done Button) | Y |
Period-Scenario |
|
|
|
|||
|
|
|
How to Reset the Audit Process
Open the 095 - Audit Trail Setting Screen in the Administration Capsule , choose the Scenario and Period and Click on the Reset Button.
by default the Application Task are not reset. Open the 095 reset the
Audit Trail Procedure and un-tick the Comment Option on the Command Lines
to activate the reset on such Tasks too.