Previous File

A/P Check Register Report

A/P Check Register Report

 

Overview

The A/P Check Register Report gives you a list of all the payments made against open A/P checks.

 

Screen

The A/P Payments Report Filter screen displays when you select Payments Report from the A/P 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.

Check No

Enter a check number or a range of check numbers, or leave the field blank to get all check numbers.

You may have the option of printing a report for a single check number, a range of check numbers, or for all check numbers.

Check Date

When you click on the Check Date box, a small calendar window displays and you can select a check 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 check dates, skip the Check 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 Check Date parameters.

Remit To

Enter a Remit To code to get a report for a single Remit To, or leave the field blank to get a report that includes all Remit To’s.

Note: To search for a Remit To, click on the box to the right of the Remit To field.

If you enter a Remit To code, it will direct the system to search only for checks with that code as the Remit 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.

Group by

Select how you want the A/P checks to be grouped on the report. You have the following grouping options:

·          by Bank G/L number

·          Check number

·          Post Date

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:

·          Post Date

·          Check number

·          Remit To

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/P Check Register Report:

 


 

Description of A/P Check Register Report

The result of the A/P Check Register Report filtering process will display the following data about each line item selected:

·          Bank G/L number

·          Remit To code

·          Remit To Name

·          Post Date

·          Check number

·          Check Control number

·          Check Amount

·          The total check amount for each Accounting Center and each Remit 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