Previous File

A/P Invoice Balances Report

A/P Invoice Balances Report

Overview

You have four (4) print options for the A/P Invoice Balances. You can see the data listed on this report in the following ways: · By Accounting Centers · Landscape or Portrait · By Services codes Note: The A/P Invoices Filter screen for the by Service Code options include a field to specify a range of Service Codes, if needed.

Screen

The A/PInvoices Filter screen displays when you select any of the A/P Invoices Balance Reports 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.
Application	Enter an application code to get a report for a single application, or leave the field blank to get a report that includes all applications.	This field allows you to search only for invoices from a particular application set. You have the following options for Applications: · BBMAS = Break Bulk / AMS Manager · CHB = Customs House Brokerage · EXPORT = Export (Freight Forwarding) · CHBEDI = CHB EDI · ACM = Accounting Manager · AES = Automated Export System · AII = Automated Invoice Interface · ABISVR = Questa ABI Server · AESSVR = Questa AES Server · ACCA = Accounting Centers Manager · ARINV = A/R Invoice · BB2CHB = BreaBulk to CHB Transporter · AMSSVR = Questa AMS Server · FF2AES = Freight Forwarding to AES
Vendor	Enter a Vendor code to get a report for a single Vendor, or leave the fields blank to get a report that includes all vendors. Note: To search for and select a Vendor, click on the box to the right of the Vendor field.	If you enter a Vendor code, it will direct the system to search only for invoices with that code as the Vendor. Leave the field blank to see all vendors.
Remit To	Enter a Remit To code to get a report for a single Remit To, or leave the fields blank to get a report that includes all Remit To’s. Note: To search for and select 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. Leave the field blank to see all Remit To’s.
Invoice Date	When you click on the Invoice 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 invoice dates, skip the Invoice 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 Invoice 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.
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.
Batch No	Enter an invoice batch number or a range of invoice batch numbers, or leave the field blank to get all invoice batch numbers.	You have the option of printing a report for a single invoice batch number, a range of invoice batch numbers, or al invoice batch numbers.
Service Code	Enter a service code or a range of service codes, or leave the field blank to get all service codes.	You have the option of printing a report for a single service code, a range of service codes, or all service codes.
Srv. Code Prefix	Enter the service code prefix.	You can select a single service code prefix, if needed.
Group by	Select how you want the A/P items to be grouped on the report. You have the following grouping options: · by Remit To · by Vendor · by Invoice Date · by Application	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: · Remit To · Vendor · Invoice Date · Invoice Number · Application · Due Date · Control Number · Batch Number	These check boxes allow you to select how you want the data sorted on the report.
Open Paid All	Click in the Open, Paid or All check box to indicate which invoices you would like to include on the report.	By clicking on the appropriate box, you may indicate you would like to see just Open items, just Paid items, or All items (open and paid).
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 ont he screen as prints out to the printer.
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 Invoice Balances Report:

Description of A/P Invoice Balance Report

The result of the A/P Invoice Balances Report filtering process will display the following data about each line item selected: · Accounting Center · Invoice Control No. · Remit To Code · Remit To Name · Vendor code · Invoice Date · Due Date · Application (APL) · Invoice Number · (Service Code and Service Description, if report is By Service Code) · Invoiced Amount · Payments · Balance The order of the data will be determined by your selection of Sort by parameters on the Filter screen.

Next File