Displaying Transaction Rows

You can select the rows to display on the transaction list and filter the list of transactions. You can view transactions from partners if you have the appropriate security rights. See Viewing Partner Entity Transactions. You can view Entity transactions, Partner transactions, or both.

You can specify more than one account cell for the filter. Use a semi-colon (;) as the separator for each account cell. For example, you can specify these accounts:

A#RecItIC.C1#Increases;A#SalesIC.C1#Closing

You can also specify a parent account and the system automatically enumerates all of the base members for that account.

You can use the percent (%) symbol as a wildcard in these fields marked with an asterisk (*): Transaction ID, Transaction Sub ID, Reference ID, Match Code, or leave a text box blank to avoid filtering. The row settings are saved when you exit the session.

If you do not specify row filters, the system displays all transaction rows.

Note:

Depending on the setup of your database, text boxes might be case-sensitive. For example, filtering with “testgroup” might return different results than filtering with “TestGroup.”

  To select transaction rows to display:

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

  2. Select Process IC Transactions.

  3. From Filter, select Rows and select Row Filter.

  4. Select filter options for rows:

    1. For Entity, either use the default entity from the Process IC Transactions window, enter an entity, or click Browse and select a member.

    2. For Partner, either use the default partner entity from the Process IC Transactions window, enter a partner entity, or click Browse and select a member.

    3. If you select to display Entity Transactions, for Entity Account, enter an account, or click Browse and select an account.

    4. If you select to display Partner Transactions, for Partner Account, enter a partner account, or click Browse and select an account.

    5. For Transaction ID, enter an ID.

    6. For Transaction Sub ID, enter a sub ID.

    7. For Reference ID, enter an ID.

    8. From Transaction Currency, select a currency.

    9. For Match Code, enter a match code

    10. For Transaction Amount, enter a range of amounts.

    11. From Reason Code, select a code, or All, or None.

    12. For Transaction Date, select a range of dates.

  5. From Include, select one or more options: Matched, Unmatched, Mismatched, Posted, or Unposted.

  6. Optional: From Options, select a value for the Scale Factor and Decimal Override for the amounts displayed for the transactions.

  7. From Display, select Entity Transactions, Partner Transactions, or both.

    Tip:

    To restore rows to their default settings, click Restore Defaults.

  8. Click Close.