A/P Prepayments Report

Overview

The A/P Prepayments Report gives you a list of all the miscellaneous deposits you have received.

The Miscellaneous Deposits Filter screen displays when you select Prepayments from the A/P Reports drop-down menu.

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.
Remit To Code	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 invoices with that code as the Remit To Party.
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.
Bank G/L	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.
Entity	Select the entity type from the drop-down list. The following are the valid entity types: · ARI = ACM: AR Invoice No. · ARC = ACM: AR Inv. Control No. · ARB = ACM: AR Inv. Batch No. · ECN = EXP: Container No. · ESP = EXP: Shipment No. · EMA = EXP: Master No. · EHS = EXP: House No. · BCN = BBM: Container No. · BCS = BBM: Consolidation No. · BMA = BBM: Master No. · BHS = BBM: House No. · BSB = BBM: Sub-House No. · BRF = BBM: Reference No. · BEN = BBM: Entry No. · CEN = CHB: Entry No. · CRF = CHB: Reference No. · CMA = CHB: Master No. · CHS = CHB: House No. · CSB = CHB: Sub-House No.	If you enter an Entity code, it will direct the system to search only for invoices with that Entity code.
Group By	Select how you want the A/P invoices to be grouped on the report. You have the following grouping options: · by Remit To · by Check number · by Check Date · by Entity code · by Service Code	This field allows you to select how you want the data to be grouped on the report.
Select	Select one of the following from the drop-down list: · Used · Unused · All	By clicking on the appropriate selection, you may indicate you would like to see just Used prepayment items, just Unused prepayment items, or All prepayment items (used and unused).
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.

Description of A/P Prepayments Report

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

· Check number

· Check Date

· Check Amount

· Remit To

· Control No.

· Service Code

· Service Description

· Service Amount

· Used (Yes or No)

· Entity code

· Entity number

· Check Name

· The total number of prepayments and prepayment amount for each Bank G/L Account is included at the bottom of the report, as well as, Grand Totals.

The order of the data will be determined by your selection of Group by and Sort by parameters on the Filter screen.

Next File

A/P Prepayments Report: