Selecting Rows and Columns for the Report

You can select the rows and columns to display on the report. You can change these selections at any time.

The rows can display Entity Currency, Entity Curr Adjs, Entity Curr Total, Parent Currency, Parent Curr Adjs, Parent Curr Total, Parent Adjs, Parent Total, Proportion, Elimination, Contribution, Contribution Adjs, and Contribution Total.

The columns display the amount, Custom 1-4 accounts, ICP, debits, credits, ID, or remarks.

Table 7. Possible Values for the Remark Column  

Value Dimension

Remark

Entity Currency

  • Input

  • Calculated

  • Prior LID

  • Derived

Adjustments

  • Calculated

  • Group Label

  • Prior Journals

  • Derived

Proportion/Elimination

  • Nature

  • Prior Transactions

  • Derived

You can suppress the display of some transaction details or dimensions by deselecting the applicable options. For example, if you want the report to show only the journal details, you can deselect all other row display options, leaving only the journals option selected. If you want to also suppress the Custom 1, 2, 3 and 4 columns because they are not used for the account, you can also deselect these options from the column display.

The system always displays the Value and Amount columns. The Value column contains all of the Value members. If the currency of the parent member is the same as the currency of the entity, the system skips the display of the Parent Currency related Value members because it is duplicate information. The Amount column contains the amount from the data subcube. The amounts for each transaction detail are stored in the Debit or Credit column, depending on the sign of the data cell.

  To select report rows and columns:

  1. Start an Entity Transaction Detail Report.

  2. Select one or more Row Display Options:

    • Base Details

    • Line Items

    • Journals

    • Destination Transactions

    • Source Transactions

  3. Select one or more Column Display Options:

    • Entity

    • Account

    • Custom 1, 2, 3 or 4

    • ICP

    • Debit

    • Credit

    • ID

    • Remarks

  4. Click Refresh to view the report selections.