Automated Consolidation journals as the name suggests are created by default during the consolidation process. They provide an insight into the journals that are generated during the consolidation process, giving a clear picture of what values are rolled up from the child entity to the parent. Automated Consolidation Journals can be viewed in the [Proportion] and [Elimination] Value dimension members.
Set-up Required-
- Enable Consolidation Rules attribute – Under Application Settings -> Consoidation Rule attribute to be set to “Y”.
- Con Rule – This consolidation rule writes data to the [Proportion] and [Elimination] members of the value dimension from the [Parent Total]. The HS.Con function allows a multiplier and nature. Nature is any text and is used for tracing source and target intersections. The Nature parameter generates a journal entry label automatically. Put in a value (text string) in the Nature parameter of the HS.Con function in the Consolidation rules.
You may want to keep in mind that using the Nature parameter increases the size of the database and may impact consolidation performance.
- Appropriate role to view the automatic journals such as Read Journals or Journal Administrator Role.
Since Automated Consolidation Journals are auto generated you cannot load, edit, scan or delete them. Also all the process management steps for submit, approve, reject as well as post or unpost cannot be performed. However you can view, extract or print them.
Viewing or Printing Automated Consolidation Journals-
- Go to Consolidation -> Journals -> Manage.
- In the POV setting select Scenario, Year & Period as required.
- Select the Value dimension member as [Proportion] or [Elimination].
- A list of all the Automated Consolidation Journals is displayed.
Select a Journal and click Open. The journal is displayed. Click Print to print the selected journal.
Extracting Automated Consolidated Journals-
- Go to Consolidation -> Extract -> Journals.
- Select the Scenario, Year, Period POV as required.
- Select the Value dimension member as [Proportion] and/or [Elimination].
- Put in the delimiter to be used.
- In the label field, you can query on the Nature Value that you specified in the Consolidation Rule.
- Click Extract. Download the file. You can view and modify the (.jlf) file in a text editor.