Displaying Transaction Columns

You can display these columns for transactions: Transaction ID, Transaction Sub ID, Entity, Partner Entity, Account, Custom 1-4, Transaction Amount, Entity Currency Amount, Translated Transaction Currency Amount, Translated Entity Currency Amount, Conversion Rate, Transaction Date, Reference ID, Match Code, Reason Code, Comment 1 and Comment 2, User ID, Date, and Time. The order in which you select the items controls the order in which they are displayed in the columns.

The first column is always the Status column, which consists of both the Matching and Posting status. You cannot change the status in this column, however you can sort the column. For example, if you want to see all of your posted transactions at the top of the list, you can sort the posting status in descending order.

You can sort the columns by ascending or descending order, or you can specifying no sorting as the option for the column. For a dimension member, you can display the dimension member label, the corresponding description, or both. The column settings are saved when you exit the session.

If you do not specify any column filters, the system displays all of the transaction columns.

  To select the transaction columns to display:

  1. In the Browser View, expand Tasks and select IC Transaction Tasks.

  2. Select Process IC Transactions.

  3. From Filter, select Columns and select Column Filter .

  4. From Available Columns, select items to display and click Move Right button to move them to Selected Columns.

    The Selected Columns list shows a list of the columns as they are displayed from left to right in the Process Transactions window.

    Tip:

    To return items to the Available Columns list, select items from Selected Columns, and click Move Left button.

  5. Optional: To move items up or down in Selected Columns, select an item, and click the up or down arrow.

  6. 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.

  7. 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.

      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.

  8. Click Close.