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 Transaction tab define a posting date range for the report and to optionally further limit the report to specific customers or transactions.

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

    You can also limit the report to a range of process levels (requires a company), or a transaction currency.

    You can also select a display currency (base or transaction), a report detail option, and a report sequence.

Report Sequence option

  • 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). This is the default.

  • 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