Extracting Journals

  To extract journals:

1. Open the application.

2. In the Browser View, expand Tasks and select Extract Tasks.

3. Select Extract Journals.

4. Select items to extract:

   • Templates

   • Recurring Templates

   • Journals

5. If you chose to extract Journals, you must specify a Scenario, Year, and one or more Periods from which to extract journals.

6. Optional: Select one or more Entity and Value dimensions to extract.

   To extract automated consolidation journals, you must select [Proportion} and/or [Elimination] as the Value member.

   Note:

   For the Period and Entity dimensions, if you do not select specific members, the system assumes that you want to extract all members for the dimension. However, if you specifically select members, the system displays a plus sign ( + ) next to the dimension to indicate multiple selections.

7. Optional: Enter the Label and Group for the journals to extract.

   You can use the percent sign ( % ) as a wildcard.

   For automated consolidation journals, in the Label field, you can query on the Nature value of the audit transaction that you specified in the consolidation rule. You cannot use a number for the label.

8. Select the check box next to each journal status, journal type, and journal balance type to extract.

9. For Delimiter Character, enter the character used to separate the journals data in the file. These characters are valid:

   , ~ @ $ % & ^ | : ; ? \

   Note:

   Use a character that is not used in the file name or in any other way in the file. For example, if you use the comma in an entity description, you cannot use the comma as the delimiter.

10. Click Extract.

11. Follow the download instructions displayed in the browser.