Verify Rules for Automatic Journals

You can use this function to generate a report that verifies how the control tables for automatic journals are set up. The report displays both configuration error messages (codes 01-03, and 05-14), and information messages (code 04). The report is primarily intended for an experienced consolidation user. If you need more information about how to interpret the details of this report, contact your IBM® Cognos® consultant.

Limitation

  • Only active automatic journals are verified in this report.

Before you begin

Automatic Journals Definitions

You define how the automatic journals are calculated and booked from the Maintain/Configuration/Automatic Journals/Define menu. For more information, see Define Automatic Journals. You define which accounts to use in the control tables from the Maintain/Configuration/Automatic Journals/Control Tables/Acquisition Calculations menu. For more information, see Define Control Tables for Automatic Journals regarding Acquisition Calculations.

Procedure

  1. On the Maintain menu, select Special Utilities/Verify Structures.

    The Verify Structures window opens.

  2. Under Report Selection, select the Check Rules for Automatic Journals check box.
  3. Click Preview.

    The report opens in a new window.

Results

In the first section of the report, all error messages (codes 01-03, and 05-14) are displayed, and in the last section of the report, the information messages (code 04) are displayed. Each section has the following sort order:
  1. Automatic journal number (column 'cevent')
  2. Error message code or information message code (column 'code')
  3. Target account (column 'konto_pf')
  4. Source account, first in the interval (column 'konto')
  5. Source account, last in the interval (column 'konto2')
  6. Opening balances account (column 'konto_ib')

The report has 10 columns that are each used differently due to the different error situations.

Table 1. Report column names and descriptions
Column Name Description
cevent The affected automatic journal number.
Code The error message code or information message code, with a short description about the problem.
Misc Info A more detailed description about the problem, for example, which account causes the problem. Misc Info is shown twice in the header, the first time above the account, code etc. that is causing the problem, and the second time above the more detailed information about how, where etc. this is causing a problem.
Default Value

The default value for the automatic journal, if applicable, applies to the whole journal.

If code 10 - 12 appears, there may be a problem with the investment register. If that is the case, the transaction date is shown in the Default Value column.
Source Account Interval

a. konto: from account 1 in the control table.

b. konto2: from account 2 in the control table.

If code 10 - 12 appears, the konto2 information can also refer to information from the investment register.
konto_ib

The opening balance account for the target account.

If code 10 - 12 appears, the konto_ib information can also refer to information from the investment register.
konto_pf The target account for the result (the to account (change) in the control table).
typ The account type, used for transfer of equity.
cc_ind The counter company indicator.

For more information about the error and information message codes, see Error and Information Message Codes.