Account Activity Report

The Account Activity Report shows all items (invoices, receipts, checks, and adjustments) for an account in the specified date range. The report also includes original, paid, and net due amounts.

Running the Report

To run the report:

1. On the Accounts submenu, click Account Activity Report.

   The Account Activity Report dialog box appears.

   Account Activity Report dialog box

   

   Field descriptions

   The following table describes the fields on the Account Activity Report dialog box.

   Field	Description
   Account Type	Type of account (Customer or Provider). The report will include items for this type of account only. It will be titled Customer Activity or Provider Activity, depending on this selection. Note: The Customer Activity report includes customer accounts only (no employee or vendor accounts).
   Account ID	Full or partial customer account ID or provider account ID, depending on the type of account selected in the Account Type field. If you specify a full account ID, the report will include items for this account ID only. Use the wildcard character (*) to specify a partial account ID, as shown in the following examples: 71* Includes items for account IDs that begin with "71" (for example, "7126" and "7153"). *71 Includes items for account IDs that end with "71" (for example, "2071" and "10071"). *71* Includes items for account IDs that contain "71" anywhere (for example, "7126", "10713", and "10071"). You can also specify @TAGGED to include items for tagged accounts only, or @ followed by a customer interest code (for example, @SKI) to include transactions for only accounts with that interest. Leave this field blank to include items for all accounts. To find and select a an account ID, click the lookup () button. The Find an Account ID screen appears. For details, see Using the Lookup Buttons and Screens.
   From (for date range)	Beginning date of a range of dates. For invoices, this date is the invoice date. Otherwise, it is the date on which the item was entered. Items within the specified range of dates will be included on the report. You must use this date in conjunction with the To date to define a range.
   To (for date range)	Beginning date of a range of dates. For invoices, this date is the invoice date. Otherwise, it is the date on which the item was entered. Items within the specified range of dates will be included on the report. You must use this date in conjunction with the From date to define a range.
   Branch	Branch. The report will include items for this branch only. Only the branches to which the employee has access display. If All is selected, all branches to which the user has access are considered. To find and select a branch, click the lookup () button. The Find Branch screen appears. For details, see Using the Lookup Buttons and Screens.
   Settle Type	Settlement type. The report will include items for this settlement type only. Leave this field blank to include items for all settlement types. For information about settlement types, see Basics of Invoices. Select one or more of the following options from the drop-down list: A ARC D Direct I Invoice T Tracking To select one settlement type, click the desired type in the drop-down list, and then press Enter or the Tab key. To select multiple settlement types, click the desired types in the drop-down list while pressing the Ctrl key, and then press Enter or the Tab key.
   Subtotal by Branch	Indicates whether to sort and subtotal the report by branch, then account. If not selected, the report will be sorted by account ID. Within account ID, the detail is sorted by date, then invoice versus non-invoice items, then branch, and then invoice/check number.
   New Page per Branch	Indicates whether to start each branch on a new page. This option is available only if Subtotal by Branch is selected.
   Include Plastic Items	Indicates whether to include invoice items with plastic (P) form of payment.
   Open Items Only	Indicates whether to include open items (general ledger status of O) only.
   On Account items Only	Indicates whether to include only items that are in the general ledger account for customer unapplied funds (generally 2040) or provider unapplied funds (generally 2045), depending on the type of account selected in the Account Type field.

2. Complete the fields as appropriate.

   Note: The date fields for Date Range are required.

3. Choose one of the following print options:

   • To print the report immediately, click PRINT.

     The Send to dialog box appears. Select a report destination. For more information, see Printing Overview.

   • To store the report as part of a batch for printing later, click BATCH.

     The Choose a Batch dialog box appears. For more information, see Batch Printing.

Report Example

Account Activity Report example

Report Notes

• Checks posted to multiple items will have a detail line for each item on the report.
• Checks and receipts to the general ledger are included and treated as paid in full.
• Voided invoice items, cash receipts, and checks are excluded from the report.

Customer Activity Report

The Customer Activity report includes the following information:

Total	The total cost (including discount/markup) for invoice items, and the original amount for non-invoice items.
Check #	The check number for checks and receipts, ADJ for adjustments, and CC PMT for group credit card payments.
Net Due	The total amount, less the amount paid.

Provider Activity Report

The Provider Activity report includes the following information:

Net Remit	The commission * -1 for plastic invoice items, the total less commission for non-plastic invoice items, the and original amount for non-invoice items.
Net Due	The total amount, less the amount paid.