Displaying Transaction Report Columns

You can select the items to display in the report columns, and the order in which you would like to see them. For a dimension member, you can select whether to display the dimension member label, corresponding description, or both. You can sort the columns by ascending or descending order, or select no sorting. If you select the Totals option, a subtotal is displayed for the amounts in the column.

You can select whether to repeat the information in every row. For example, if you select the Repeat option for the entity label, the system displays the entity label for all of the selected transactions for that entity. If you do not select the Repeat option, the system displays the entity label for the first transaction but not the labels for subsequent transactions with the same label.

Table 21. Entity Column with Repeat Option Selected

Entity	Partner	Account
A	B	ICRec1
A	B	ICRec2
A	B	ICPay1
B	C	ICRec1
B	D	ICRec2

Table 22. Entity Column without Repeat Option Selected

Entity	Partner	Account
A	B	ICRec1
A	B	ICRec2
A	B	ICPay1
B	C	ICRec1
B	D	ICRec2

To display transaction report columns:

In the Browser View, expand Tasks and select IC Transaction Tasks.
Select Process IC Transactions.
From Reports, select Transaction.
Select Column Filter.
From Available Columns, select items to display and click to move them to Selected Columns.
The Selected Columns list shows a list of the columns as they are displayed from left to right on the report.
Tip:
To return items to the Available Columns list, select items from Selected Columns, and click .
Optional: To move items up or down in Selected Columns, select an item and click the up or down arrow.
If you selected to display Transaction Currency Amount and Entity Currency Amount, from the Common Currency drop-down, you must select a currency for translation.
To set column attributes:
1. From Selected Columns, select the columns.
2. Click Sort Options, and select No Sort, Ascending or Descending.
3. Click Display Options and select Label, Description, or Both.
4. To repeat the information in every row, click Repeat.
5. To display the subtotal for the amounts, click Totals.
  The system displays a summary of the selected columns and their attributes to the right of the Selected Columns list. You can also right-click in the table and select column attributes.
  Tip:
  To restore the columns to their default settings, click Restore Defaults.
Click Close.