AR: Customer Activities Report

Overview

The Customer Activities report is used to view account activity for a customer, a group of customers, or all customers during a specified date range. Use this report to find invoice totals, credit memos, payment information, adjustment details, and unapplied cash.

You may filter the report by Customers or Customer Types.

You can filter, group, and print by Tiers, allowing for total customization of the report. To make filtering easier, for any Tier, you can include All, Pick/Create or Exclude parameters. Using Tier Templates to set up and save report templates makes it easy to generate a specific report each time you need it, without having to recreate the criteria. See Using Tier Templates for more information.

The report contains the customer number and name, invoice information (date, reference, number, and amount), payment information (date applied, reference, check number, amount, and date), miscellaneous adjustments and balance due.

The recap section displays total amounts for invoices, credit memos, cash/checks, EFTs, CC's. The recap includes the total amount for adjustments (discounts, write-offs, finance charges, and revenue adjustments). Total amounts for invoices, payment information and balances are displayed in computing the Grand Total.

Key Functionality

The AR Report Customer Activities screen has its own Security Group, AR Report Customer Activities.

The AR Report Customer Activities screen is part of the AR Reports ALL Security Group.

Tip:  For more information see Security Groups Overview and Security Groups By Module.

Type a description to name the report. This description prints above the Report Title.

The Default Company Name for Report is populated from the Company Setup screen. The list contains all companies for which you have security permissions to view. If you have permission for only one company, that will be the only one displayed in the list. If you have permissions to multiple companies, the list will display those companies PLUS the default reporting company.

When discernible, WinTeam will print the appropriate company name and logo on each page; otherwise the Default Company Name will print. That is, if a Company level is included in the tiered section and is displayed in the tiered information at the bottom of the page, then that company's Report Name and Logo (if selected) prints on that page.

If there is not a Company identified in the tier area of the page, then the Default Company Name for Reports is used. The default Company Name and Logo is also used for the Total Enterprise report. For more information see Learning about WinTeam Reports.

Use the Customer Status option to include active Customers, inactive Customers, or both for the report.

Click Active to include only active Customers on the report.

Click Inactive to include only inactive Customers on the report.

Click Both to include active and inactive Customers on the report.

Use the Sort By option to sort report data by Customer Number or Customer Name.

Click Number to sort report data by Customer Number.

Click Name to sort report data by Customer Name.

Use the Invoice Dates group to filter the report by invoice dates.

Select All to include all invoices regardless of the invoice date.

Select Date Range to define a range of dates for the report. When you select Date Range, the date range fields display. Type the beginning date in the From field and the ending date in the To field, or use the Date Control to select a date.

Cut Off

This field displays if you selected 'Date Range' under Invoice Dates.

The cut off date determines what Payments (not which invoices are being included) to include on the report. All payment information through the cut off date will be included on the report.

The cut off Date defaults to today's date.

Customers

Select the Customers to include on the report.

Select All to include all Customers on the report.

Select Range to define a range of Customer Numbers for the report. When you select Range, the Customer Number range fields display. Type the beginning Customer Number in the From field and the ending Customer Number in the To field.

Select Pick to define specific Customers for the report. When you select Pick, the Customer list displays. Select the check box next to each Customer to include on the report.

Select Create to define your own list of Customers. When you select Create, a small grid displays to the right. Enter the Customer Numbers you want to include in the list, or use the Lookup to locate the Customer Numbers.

Select Exclude to identify records that should not be included. When you select Exclude, a small grid displays to the right. Enter the Customer Numbers you want to exclude in the list, or use the Lookup to locate the Customer Numbers.

Customer Types

Select the Customer Types to include on the report.

Select All to include all Customer Types on the report.

Select Pick to define specific Customer Types for the report. When you select Pick, the Customer Types list displays. Select the check box next to each Customer Type to include on the report.

Use the Tier Template to define and save customized settings for a report. To use an existing template, select the template from the list and click Load.

To create a new template, you can load an existing template, make the necessary modifications, click Save, and define a new template name in the Save As dialog box. Alternatively, you can start with a blank template by clicking the Clear button.

To modify an existing template, load the template, make the necessary modifications, and then click Save. The name of the existing template display in the Save As dialog box. Click OK.

For more information see Using Tier Templates and Using Tier Parameters.

When tiers are used, following is how unapplied cash appears on this report:

Customers with a default job in the CMF–Unapplied cash displays under the default job tier. It could display under the balance sheet job tier if that tier is selected and no other job default tiers are selected.

Customers without a default job in the CMF–Unapplied cash displays under the balance sheet job tier if that tier is selected, and no other tiers. The balance sheet job is set in SYS: Company Setup

Select to group the information by Parent Customer. This check box is NOT selected by default.

The Print Company Totals check box is available to users who have only one company, and may be selected to print company totals on the report.

The Print Enterprise Totals check box is available to users who have more than one company, and may be selected to print enterprise totals on the report. This check box is selected by default.

If this is not selected, the report prints only the tiered reports that are marked for printing.

Select this check box to print the company logo on the report. It is selected or cleared by default based on the option selected in SYS:Defaults. However, you can modify the setting on each report.

Select this check box to include a list of the report options selected for the report. The Report Criteria page includes any ranges specified and each Category/Record selection made for the report. This check box is cleared selected by default.

Preview

Click the Preview button (or use the shortcut key, ALT + V) to view the report before printing.

Print

Click the Print button (or press ALT + P) to send the report to your default printer.

Export

Click the Export button (or press ALT + X) to export the report to a specified format. Reports may be exported to Adobe Acrobat (PDF), Excel, Comma-Separated Values (CSV), Grid View and E-mail (available for premise-based clients only).