Invoice Balances Reports

A/R Invoice Balances Report

Overview

You have five (5) print options for the A/R Invoice Balances. You can see the data listed on this report in the following ways:

o by Accounting Centers

o Landscape

o Portrait

o by Service Codes (with A/P items)

o by Service Codes (without A/P items)

Note: The A/R Invoices Filter screen for the by Service Code options include a field to specify a range of Service Codes, if needed.

Screen

The A/R Invoices Filter screen displays when you select any of the A/R Invoices Balance Reports 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.
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
Customer	Enter a Customer code to get a report for a single Customer, or leave the fields blank to get a report that includes all customers. Note: To search for and select 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. Leave the field blank to see all customers.
Bill To	Enter a Bill To code to get a report for a single Bill To, or leave the fields blank to get a report that includes all Bill To’s. Note: To search for and select 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. Leave the field blank to see all Bill 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.
Group by	Select how you want the A/R items to be grouped on the report. You have the following grouping options: · by Bill To · by Customer · by Invoice Date · by Application · by Batch	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 · Customer · 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/R Invoice Balances Report: