Copying Company Journals

The Copy Company Journals function can be useful when you are booking the same or similar company journals from period to period or between different companies. The various options for copying in IBM® Cognos Controller are described next.

Copy Rules

The following description tells you how to copy company journals between periods and actualities in the same fiscal year or to another year.

Copy Journal Entries or Journals in Columns

You can copy both journal entries and journals entered in columns. What is copied depends on whether the periods that you are copying from and to have been defined to create company journals as journal entries or in columns. The copying process is controlled by the To period.

The following table shows what is copied, depending on how you have defined the periods:

Table 1. Period definitions for copying as journal entries or columns
From Period To Period Copy

Journal Entries

Journal Entries

Journals Entries

Columns

Columns

Columns

Journal Entries

Columns

Columns

Columns

Journal Entries

Nothing

Journal Number

If you are only copying fixed/reversing company journals, you can change the numerical order for the copied journal entries from the one in the period you copied from. If there are journal entries with the copy rule T in the number series, this means that the journal entries change numbers after copying, as the main rule specifies that there should be no gaps in the number series. This can be important for currency translation of company journals by transaction.

If you do not want to change the journal numbers when copying, you can always choose to copy all of them instead.

Recommendation: Always create temporary journals last, so that they do not affect the numerical order when only copying fixed/reversing company journals.

If you want make sure that the journal number order is not changed, another option is to change the main rule. Select Copy Journals Without Changing the Journal Number in the general configuration using the General 3 tab. However, this option can result in gaps appearing in the numerical order.

Note: A change in numerical order can create problems in currency translation, especially for accounts coded with conversion codes C and I.

For more information, see Currency Translation of Company Journals.