Rows (Entity Journals) page
User
Processes tile > select process > Contributor > Detail summary tab or Step tab > (Actions) Edit windows > Edit Entity Journals > select header > 
> Rows
Processes tile > select process > Consolidator > Overview tab or Step tab > (Actions) Edit windows > Edit Entity Journals > select header > > Rows
Processes tile > select process > Step tab > from a workflow task > select task whose type is entity journals > Run > select header > > Rows
Navigation panel > Processes > select process > Contributor > Detail summary tab or Step tab > (Actions) Edit windows > Edit Entity Journals > select header > > Rows
Navigation panel > Processes > select process > Consolidator > Overview tab or Step tab > (Actions) Edit windows > Edit Entity Journals > select header > > Rows
Navigation panel > Processes > select process > Step tab > from a workflow task > select an entity journals task > Run > select header > > Rows
Purpose of the page¶
This page allows you to insert the entries that comprise the individual journal. The origin is also shown for every entry.
Entries inserted manually have “INPUT_WEB” indicated as their Origin.
Note: you can configure CCH Tagetik so that entries with different origins are different colours. See Colours by origin option in the .
The page may show a subset of journal rows depending on the filters set by default in the journal rules (Journal rules and settings page) or set specifically for the page (
).
Filters on the page
The most significant filters for the page and the results that they give you are described below.
| Element | Description |
|---|---|
| Show only main accounts | Allows you to view only accounts that are defined in the process data model as “main accounts on journals” (). This hides the accounts that are less significant for the journal. |
| Exclude Result accounts and their variations | This allows you to exclude accounts belonging to the set of result accounts specified from among the requirements of the process’s calculation logics (). In particular, the Profit & Loss result account, the Balance Sheet result account and their variations, determined taking account only of control groups belonging to the process, are excluded. |
| Account type | Allows you to view only accounts of the type indicated by the Journals data entry: account type option, unless “Any” is selected (Default settings window). |
| Account nature | Allows you to view only accounts of the selected nature. |
| CTP Custom dimension 2 allocations | Only present if custom dimension 2 is managed, the process’s relationship type is “entity - custom dimension 2” or “entity - synthetic custom dimension 2”, and the Spreading - Show CTP custom dimension 2 override type option is active in the process’s gross and IC amount rules. - Original data: excludes rows whose origin is “PROC_IC_SPREADING” or “PROC_IC_SPREADING_CB”. - Only reallocation: shows only rows whose origin is “PROC_IC_SPREADING”. |
Icons on this page
| Element | Description |
|---|---|
| Row just added but not yet saved | |
| Row being deleted but not yet saved | |
| The rows cannot be edited. The reason for the lock is reported, e.g. “Row already posted” if the user has tried to assign the journal draft status. | |
| Draft Journal. |
Actions on this page
| Element | Description |
|---|---|
| Spreadsheet view: shows the data in a spreadsheet. | |
| List view: shows the data in a table. Default view. | |
| Allows you to access specific actions for the rows, see Actions from the journal rows. |
Attributes on the page
Not all attributes are editable.
| Field | Description |
|---|---|
| Scenario | Scenario set in the header. Not editable. |
| Period | Period set in the header. Not editable. |
| Journal number | Journal number in the header. Not editable. |
| Entity | Entity set in the header. Not editable. |
| Account | Account on which a value is entered. The chosen account must meet the following requirements: - Editable for the user. - Linked to the data model process associated with the entity to which the journal belongs. - Start date and end date, if set, must be between the start date and end date of the scenario/period to which the journal belongs. If the CTP entity field is defined, it must allow intercompany data management. |
| Category | Category set in the header. Not editable. |
| Custom dimension | For every custom dimension that is managed and enabled in the process’s journal rules, you can select an element of the custom dimension which meets the following requirements: - Editable for the user. - Visible from the entity to which the journal row belongs. - Visible from the selected account. If no value is selected, the custom dimension will be shown as the entity’s default custom dimension or the custom dimension with the lowest code from among those which meet the above requirements. IMPORTANT: the custom dimension 2 is managed even if it is not enabled in the process’s journal rules, but the process’s relationship type is “entity - custom dimension 2” or “entity - synthetic custom dimension 2”. |
| CTP entity | Counterparty entity in the journal. An entity can be chosen, provided it meets the following requirements: - Belong to the selected process. - Must belong to the selected scenario/period. - Start date and end date, if present, must be between the start date and end date of the selected scenario/period. You can define a list of most frequently used counterparty entities, see . To use only a subset of entities as counterparties, it may be useful to create a group of counterparties (Dynamic counterparty groups). You can also declare IC data in the context of the same entity (and therefore use the same code for both the entity and the counterparty). This is only possible if the Allow intercompany declarations towards same Declaring entity option is active (Amount & Intercompany rules page). For example, this is useful for eliminating dividends received from group companies towards profits carried forward, or for eliminating self-invoicing results. |
| CTP custom dimension 2 override type | Only present under the following conditions: - Custom dimension 2 is managed. - The process’ relationship type is “entity - custom dimension 2” or “entity - synthetic custom dimension 2”. - The Spreading - Show CTP custom dimension 2 override type option is active in the process’s gross and IC amount rules. - The user’s role contains function 0002274. It can be set as follows: - To allocate - None - Override |
| Counterparty custom dimension 2 | Only present under the following conditions: - Custom dimension 2 is managed. - The process’ relationship type is “entity - custom dimension 2” or “entity - synthetic custom dimension 2”. It is only mandatory under the following conditions: - A CTP entity has been specified. The field is only editable if the Spreading - Display CTP custom dimension 2 override type option is active in the process’s gross and IC amount rules, or if that option is active and: - The user’s role contains function 0002274. - CTP custom dimension 2 override type is not “To allocate” If the field is editable, it is defined as the CTP entity’s default custom dimension 2 or, if the Spreading - Show CTP custom dimension 2 override type and Show CTP custom dimension 2 with entity’s default element options are not active in the process’s gross and IC amount rules, the field is defined as the default custom dimension 2 element specified in the custom dimension 2 settings. |
| Company currency | Currency set in the header, not editable. |
| Entity currency amount | Amount expressed in the entity currency. Regardless of the number of decimals inserted, amounts are shown with a number of decimals that is consistent with those assigned to the currency in which they are expressed, with the exception of “Other stocks” and “Other variations” accounts where the Manage maximum number of decimals option is active (see ). For these accounts, it is possible to insert up to 9 decimals. The amount may be shown in two different columns: Entity currency amount - debit and Entity currency amount - credit. This happens if the Amounts option is set to Write amounts in Debit & Credit columns in absolute value in the journal rules definition (Default Settings window). |
| Override FX rate | Only present if the transaction currency is managed on entity journals in the process’s journal rules. If selected, you can edit all the amounts in the current row, thereby indirectly overriding the field applied to change from the entity currency amount to the transaction currency amount. Otherwise, only the transaction currency will be editable, but the transaction currency amount will not be. On saving, it automatically defines the amount in the transaction currency based on the account’s conversion type. |
| Transaction currency | Only present if the transaction currency is managed on entity journals in the process’s journal rules. If not entered, it will be defined as the entity currency. |
| Transaction currency amount | Only present if the transaction currency is managed on entity journals in the process’s journal rules. If the transaction currency has not been entered or is the same as the entity currency, the field is defined as the entity currency amount. Otherwise, if the Override FX rate option is not selected, the entity currency will be defined automatically based on the account’s conversion type. For the rest, the considerations made for the Entity currency amount will be valid. |
| Notes | Any explanatory notes |
| Additional notes | Any additional notes |