Automatic Journals - the Define Tab
Here you create new or enable/disable automatic
journals to be used for reconciliation and elimination purposes.
If you want to create your own automatic journals, we recommend that you contact your IBM® Cognos® consultant for help.
All existing automatic journals (select one at a time from the list box) are displayed on this tab. You can use this function to view or define the following:
- The automatic journal code and name.
- Which automatic journal type it refers to.
- The level it is at, that is, the internal sequence of automatic journals
- The category used (technical IBM Cognos Controller term linked to the automatic journal type. Different categories work in different ways and use data from different database tables).
- Whether the automatic journal is enabled/disabled (disabled automatic journals do not appear in the list of available control tables).
- The use of the Enable Calculation of Change in Structure function. To get the effect of change in owned % to a separate account on each automatic journal type, the control table E300 must be selected. By selecting this check box, the structure change will be booked on the automatic journal type of the actual control table. If cleared, you will get a correct closing balance of minority etc. calculated, but the whole period change will be booked according to the usual control table (for example, E700 Minority).
- The use of No General Configuration Bookings (Alternative OB Method in earlier versions), meaning that the bookings performed by the general configuration will not take place. Select this option if you, for example, need to book a profit and loss based automatic journal on another account in the Analysis of Reserves than the one you have specified in the General Configuration.
- The use of Alternative Currency Translation. If the check box is cleared, the automatic journal is created in local currency and then currency converted. If the check box is selected, the automatic journal is created directly in all valid currencies for the company. Use this option if you have entered company journals in group currency, as these will otherwise not be the basis for the calculation and also if you use historical rates.
- The use of the Exclude the Automatic Journal from the Specific Consolidation Types. Select this to exclude an automatic journal from specific consolidation types.
- The use of Roll OB Values. If you select
this check box, OB values are rolled even though OB accounts are included
in the control tables. Note: This is only applicable in specific cases.
- A matrix containing functions and parameters relating to the automatic journal as a whole. Here you define default values and which columns should be used in the control table
- You must apply the same selection of No General Configuration Bookings, Alternative Currency Translation, and so on for all automatic journals posted on the same automatic journal type.
- Category 1 is usually suitable for user-defined automatic journals. If the automatic journal handles counterpart information, that is, it is based on an IC account, category 23 or 24 must be used so that the automatic journal is booked correctly.
- For minorities based on data on a counter company, for example E715, category 23 must be used. This is the only category that handles a crossed owned company in a correct way. That is, there should be minorities of this type booked if there is a minority on a subgroup already.