Show TOC

Function documentationJournal Reopen Translations Locate this document in the navigation structure

 

Before you can reopen journal transactions, you must define translation information for the dimensions used in the reopen tasks. The translation table defines the source and destination accounts. You typically do this for specific accounts, but you can do translations for other detail dimensions.

Features

When you open the translation table for the first time, the system opens a default table based on the application set's journal template. The default value is *, which is interpreted as any dimension member. You can modify the table as needed.

The following table describes the contents of the translation table:

Column Heading

Description

ACC_TYPE

Displays the four required account types: AST, EXP, INC, and LEQ. The first time the system creates the translation table for an application, it uses these required account types. You can add additional account types by adding new rows, but these account types must remain in the table.

ACCOUNT_PROPERTY

The property that returns a list of accounts to which the translation rule is applied.

The default property is Group, but if there is no Group property defined in the Account-type dimension, or if you want to use a different property (other than Group), specify it here.

Enter an asterisk (*) to use the property defined in the JRN_REOPEN_PROPERTY application set parameter.

s_<detail_dimension_ID>

Use this column to enter the name of the detail dimension from which you are copying the data. By default, an asterisk (*) indicates that the values have been moved from their source accounts to accounts with the same names. To copy dimension information to a different dimension, enter the source member ID.

d_<detail_dimension_ID>

Use this column to enter the name of the detail dimension into which you are copying the data. By default, an asterisk (*) indicates that the values have been moved from their source accounts to accounts with the same names. To copy dimension information to a different dimension, enter the source member ID.

Sign

Enter one (1) to keep the value in the same credit or debit position. Enter negative one (-1) to switch the value from the debit to credit, or credit to debit position.

Activities

From Interface for Excel, open the journal entry form and select   eJournal   Translation  . Insert a new row for each additional account type (AST,LEQ,INC,EXP) by choosing the Add Row button. Remove rows by choosing the Remove Row button. For each account or dimension you want to convert, enter the source and destination member IDs under the associated dimension.

More Information

Reopen Journal Entries