Activity Report (AR296)

Run Activity Report (AR296) to print a report of all transactions, cash application adjustments, non-AR payment transactions, and miscellaneous distributions associated with each activity you select for the report.

Note: Payments that do not have an activity or contract value may appear on the report because of other elements such as an activity group.

Processing Effect

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

  • Select 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, customer group or transaction), a report detail option, and a report sequence.

    • If the Report Sequence is Activity (A), the sort order will be by activity, then by currency. Subtotals are by currency and transaction type by activity. Subtotals for Activity and Report totals are only printed if the include subtotals parameter is Yes. 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 transaction type by contract. Subtotals for Contract and Report totals are only printed if the include subtotals parameter is Yes. 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 transaction type by contract. Subtotals for Contract and Activity Group and Report totals are only printed if the include subtotals parameter is Yes. 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 transaction type by activity. Subtotals for Activity and Activity Group and Report totals are only printed if the include subtotals parameter is Yes. 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 transaction type by account category and by activity. Subtotals for Account Category and Activity and Report totals are only printed if the include subtotals parameter is Yes. Page breaking will occur at the lowest level (currency within account category).

More Information

In order for subtotals and report totals to print, the include subtotals flag must be set to yes. 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. The include subtotals field is set to No. 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 and the include subtotals field is set to No. There are transactions with different currencies. Results: Within that activity, there will be currency-specific subtotals, and no activity or report totals.
  • Example 3:The requested sort is Activity Group/Activity; there are two activities for a given activity group, and each activity has a specific currency. The include subtotals field is set to Yes. Results: There will be subtotals for each transaction type by activity and currency, and activity, activity group and report totals.