Report selections

  • Access the Activity tab to select the activities included in the report.

    You can select an activity group list, an activity group, an activity list, or up to six specific activities.

    You can also further limit the report to activities that are associated with a specific account category group, account category type, or account category. An account category selection is not required.

  • Access the Options tab to select a display currency (base or transaction), a report sequence, and a report detail option.

  • You can access the Transaction tab to further limit the report to specific customers or transactions (not required).

    You can select a company, a company and customer, a customer group, or a customer list.

    You can also limit the report to a reason code or reason code type, a process level (requires a company), a User Field 1 value, a sales representative (requires a company), a credit analyst (requires a company) an operator, or a transaction currency.

Report Sequence options

  • If the Report Sequence is Activity (A), the sort order will be by activity, then by currency. Subtotals are by currency, and by activity (if currency has not changed). Report totals are only printed if currency has not changed across the report. Page breaking will occur at the lowest level (currency within activity)

  • If the Report Sequence is Contract (C), the sort order will be by contract, then by currency. Subtotals are by currency, and by contract (if currency has not changed). Report totals are only printed if currency has not changed across the report. Page breaking will occur at the lowest level (currency within contract).

  • If the Report Sequence is Activity Group/Contract (G), the sort order will be by activity group, then by contract, then by currency. Subtotals are by currency and by contract (if currency has not changed), and by activity group (if currency has not changed). Report totals are only printed if currency has not changed across the report. Page breaking will occur at the lowest level (Currency within Contract).

  • If the Report Sequence is Activity Group/Activity (P), the sort order will be by activity group, then by activity, then by currency. Subtotals are by currency, and by activity (if currency has not changed), and by activity group (if currency has not changed). Report totals are only printed if currency has not changed across the report. Page breaking will occur at the lowest level (currency within activity).

  • If the Report Sequence is Activity/Acct Category (T), the sort order will be activity, then account category, then currency. Subtotals are by currency, and by account category (if currency has not changed), and by activity (if currency has not changed). Report totals are only printed if currency has not changed across the report. Page breaking will occur at the lowest level (currency within account category).

Currency considerations

If the currency changes across the report, no report total will be printed. However, subtotals will be printed if currency has not changed for that subtotal level. For example:

  • Example 1: The requested sort is Activity Group/Activity; there are two activities for a given activity group, and each activity has a specific currency.

    Results: There will be currency-specific subtotals for each activity, and no activity group or report totals.

  • Example 2: The requested sort is Activity; for a single activity, there are transactions with different currencies.

    Results: Within that activity, there will be currency-specific subtotals, and no activity or report totals