Previous File

A/R Payments Report

A/R Payments Report

Overview

The A/R Payments Report gives you a list of all the payments made against open A/R invoices.

Screen

The A/R Payments Report Filter screen displays when you select Payments Report from the A/R Reports drop-down menu.

Procedure

The following table describes the fields on the screen and their data entry requirements.

Field Name	Data Entry	Description
Accounting Center	Select the accounting center(s) to be searched.	You can search the Accounting Center you are logged into or any Accounting Center below your Accounting Center in the Accounting Center hierarchy.
Include Branches	Check this box to include branches.	If you check the Include branches box you will be able to search through the Accounting Center you are logged into plus ALL the Accounting Centers below your Accounting Center in the Accounting Center hierarchy.
Customer	Enter a Customer code to get a report for a single Customer, or leave the field blank to get a report that includes all Customers. Note: To search for a Customer, click on the box to the right of the Customer field.	If you enter a Customer code, it will direct the system to search only for invoices with that code as the Customer.
Bill To Code	Enter a Bill To code to get a report for a single Bill To, or leave the field blank to get a report that includes all Bill To’s. Note: To search for a Bill To, click on the box to the right of the Bill To field.	If you enter a Bill To code, it will direct the system to search only for invoices with that code as the Bill To Party.
Bank	Select the bank G/L number from the drop-down list or skip the field.	If you select a G/L number from the list, it will direct the system to search only for checks with that G/L number as the Bank G/L. To get all Bank G/L numbers, skip the field.
Post Date	When you click on the Post Date box, a small calendar window displays and you can select an invoice date range from the calendar. Or you can click on Today if you would like to print a report either beginning with or ending with today’s date. To include all post dates, skip the Post Date fields.	You have the option of printing a report for a single day, a range of dates, or all dates. Note: For all dates, skip the Post Date parameters.
Invoice No	Enter an invoice number or a range of invoice numbers, or leave the field blank to get all invoice numbers.	You may have the option of printing a report for a single invoice number, a range of invoice numbers, or for all invoice numbers.
Invoice Control No.	Enter an invoice control number or a range of invoice control numbers, or leave the field blank to get all invoice control numbers.	You have the option of printing a report for a single invoice control number, a range of invoice control numbers, or all invoice control numbers.
Group by	Select how you want the A/R invoices to be grouped on the report. You have the following grouping options: · by Bill To · by Bank G/L number	This field allows you to select how you want the data to be grouped on the report.
Sort by	Click on the check box next to the sorting option you would like for this report. Your options are sorting by: · Bill To · Bank · Post Date · Invoice number · Invoice Control number · Check number · Check Amount · Remainder Amount	These check boxes allow you to select how you want the data sorted on the report.
Clear	Press this Clear button if you would like to re-select the report parameters on this screen.
Display	Select the Display button if you would like to display the data on the screen rather than print it out to the printer.	The same data displays on the screen as prints out.
Print	Select the Print button if you would like to begin the printing process based on the selections displaying on the screen.	The document printing window will display.
Cancel	Select the Cancel button if you would like to close the screen without displaying or printing the data.

A/R Payments Report:

Description of A/R Payments Report

The result of the A/R Payments Report filtering process will display the following data about each line item selected: · Bill To code · Bill to Name · Bank G/L number · Post Date · Invoice number · Suffix · Invoice Control number · Check Amount · Check number · Credit Amount · Remainder Amount · The total check amount for each Accounting Center and each Bill To is calculated and included, as well as, the grand total check amount, credit amount, and remainder amounts are included at the bottom of the report. The order of the data will be determined by your selection of Group by and Sort by parameters on the Filter screen.

Next File