AR: Payments Report

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

Available for Clients using the Multi-Company feature. The Default Company Name for Report is populated from the Company Setup screen. The list contains all companies you have permission to access.

• If the User has permission to only one company, then just that one company will display in the list.
• If the User has permissions to more than one company, the list will contain all companies the User has rights to PLUS the default reporting company.

When the Group By Company option is selected, the default company prints on the Grand Total Page and the Report Criteria page. All other pages print the applicable company name. When the Group By Company option is NOT selected, the default company prints on every page of the report.

For more information see Learning about WinTeam Reports.

Use the Report Format option to choose the level of detail for 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.

Choose a single GL Cash Account Number as report criteria for more efficient reconciliation of cash receipts. If no GL Cash Account Number is selected, report runs for all cash accounts.

Select Settled/Paid to include only payments that are completely settled and paid in the report. Select Pending to include only pending ACH payments in the report. This applies to all export options for the report.

Note:  When Pending is selected, the title of the report is Pending Payments Report.

Deposit Dates

Use the Deposit Dates category to filter the report criteria by deposit dates.

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.

Select All to include all records regardless of the deposit dates.

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.

Payment Types

Use the Payment Types category to select the payment types to include on the report.

Select All to include all Payment Types on the report.

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

Companies

The Company Pick option filters for AR Invoice and Payment records. The Companies category is available for Clients using the Multi-Company feature.

Select the Companies to include on the report.

Select All to include all companies on the report.

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

Note:  When running reports using the Company Category/Record Pick and the company name exceeds the maximum number of characters, WinTeam will truncate the name.

Batches

Use the Batches category to select the batches to include on the report.

Select All to include all Batches on the report.

Select Pick to define specific batches for the report. When you select Pick, the batches display in descending ID order. The Description includes the type of payment and the payment date. Select the check box next to each Batch to include on the report.

User Names

Use the User Names category to select the payments to print based on who entered the records. This allows users to print their own work without printing the work of others. Select All to print payments for all users. Select Pick to define specific user names for printing payments.

This option is available to users who have more than one company, but is not selected by default. If selected, the default company prints on the Grand Total Page and the Report Criteria page. All other pages print the applicable company name. If not selected, the default company prints on every page of the report.

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

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

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

Note:   Multi-Company—WinTeam looks to the Job's Company logo to determine which Company logo to use on the Work Ticket Report and Work Tickets.

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

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

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

The AR Report Payments screen has its own Security Group, AR Report Payments.

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

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