Journals

You use journals to record and make adjustments to data in the database.

This is typically done as part of the month-end or quarter-end process. For example, administrators load general ledger information into a model using Data Manager. Before the close, line managers can review the data and make adjustments as necessary using a journal entry form.

Prerequisites

At least one journal template has been created for the model.
You have the appropriate rights to perform given tasks.

Features

The following table describes the available Journal tasks and explains how to perform each one. You perform these tasks in Start of the navigation path Consolidation Central Next navigation step Journals End of the navigation path .

Task	Navigation	What You Should Know
Create a journal entry	Click New in the toolbar of the Journals page.	For more information, see Journal Entries.
Modify a journal entry	Select a journal entry from the list in the Journals page and click Open in the toolbar. In the Journal Entries tab, make your changes to one or more journal entry rows, then click Save.	You can modify saved and unposted journal entries. For more information, see Journal Postings.
Copy one or more journal entries	Select one or more journal entries in the Journals page. To select non-contiguous journal entries, hold down the `CTRL` key as you make your selections. Select Copy To from the toolbar, specify whether to keep the same Time, Category, and Datasource dimension members and confirm.	You can copy selected entries to another member of one of the header dimensions.
Preview line item detail of a journal entry	Select a journal entry from the list on the Journals page and select the Preview option in the toolbar. The details on the journal entries appear below the list of journal entries.	You can review detail lines of a journal entry for the entries to which you have View rights. For more information, see Journal Queries.
Open one or more journal entries	Select a journal entry from the list on the Journals page and click Open in the toolbar. You view the details of the journal entries in the Journal Entries tab. You can open additional journal entries and toggle between them using the tabs that appear with each open journal entry.	You open journal entries to view or edit them. For more information, see Journal Entries.
Post one or more journal entries	Select one or more journal entries from the list on the Journals page and click Post in the toolbar. All the selected entries are posted. To select non-contiguous journals, hold down the `CTRL` key as you make your selections.	When you post an entry, the system applies the values in the journal entry to the database, so that model data is appended. You can configure a journal entry to be posted with multiple header dimensions or multiple values. For more information, see Journal Postings.
Unpost one or more journal entries	Select one or more journal entries from the list on the Journals page and click Unpost in the toolbar. All the selected journal entries are unposted. To select non-contiguous journal entries, hold down the `CTRL` key as you make your selections.	The system reverses the original entry to the model. For more information, see Journal Postings.
Ungroup journal entries	Select one of the journal entries in a journal group and click Ungroup in the toolbar. All the journal entries in the group are ungrouped.	For more information, see Journal Groups.
Search for journal entries	In the Filter by menu located in the toolbar of the Journals page, choose Advanced Query. In the Advanced Query dialog box, define your query and click OK.	If a large number of journal entries are written to a model, use the Advanced Query to define queries so you can search for specific entries. The Advanced Querysearches through both header and detail dimensions. If you have multiple journal entries, they are grouped under the first entry. For more information, see Journal Queries.
Lock and unlock journal entries	Select a journal entry from the list in the Journals page and click Lock in the toolbar. To unlock the journal entry, select it and click Unlock in the toolbar.	When you lock a journal entry, you cannot make changes to the line item details.
Reopen journal entries	Select one or more journal entries from the list on the Journals page and click Reopen in the toolbar.	To reopen one or more single journal entries to new single journal entries in a subsequent time period, see Reopen Journal Entries.
Require balanced journal entries	Select the Enforce Balanced Journals option in the journal model parameters.	A balanced journal entry is one in which the debits equal the credits in the journal entry. If this option is set, you cannot post the journal entry until it is balanced. For more information, see Journal Model Parameters.
Print a journal report	Select one or more journal entries from the list on the Journals page and click Report in the toolbar. To select non-contiguous journals, hold down the `CTRL` key as you make your selections. In the Journal Report tab that opens, click Print.	You can generate reports based on journal entries. For more information, see Print Journal Reports. Note To use this task, users must have one or more task profiles related to Journals, including CreateJournal, PostJournals, ReviewJournals and UnpostJournals.
Delete one or more entries	Select one or more journal entries from the list on the Journals page and click Delete in the toolbar. To select non-contiguous journals, hold down the `CTRL` key as you make your selections.	When you delete an entry that has been unposted, its status changes to Deleted. When you delete saved entries, they are deleted from the system. An entry that has been posted cannot be deleted until it is unposted. For more information, see Reopen Journal Entries.
Define journal reopen rules	In Planning and Consolidation Administration, select Features Journal Templates. Open a journal template and click the Reopen Rules tab.	Design a template of translation information for the dimensions you want to reopen. For more information, see Reopen Journal Entries.