Report: Open Vendor Invoices

The Open Vendor Invoices report is a cash management tool for your agency. It provides information regarding vendor invoices with a payable balance as of the report date. You can run the report with invoice-level detail, or with summarized totals only.

The Open Vendor Invoices report is also available as a Quick Report from the sidebar menu on the Bank and Financial Centers. The Quick Report provides a means of quickly accessing open vendor invoices as of a specified end date.

Report Selections

When the report is accessed from a Quick Reports menu, some selections are pre-filled by default. You can change default entries as needed.

Report Selections

What is this?

Reporting End Date

Option	What is this?
From List	Use this option to select a pre-defined end date from the list. The default option is Current Month.
Select Date	Use this option to type in a specific end date that is not covered by the choices in the From List option.

Vendor

The default is All; you can select a specific or multiple vendors.

Payment Division

The default is All; you can select a specific or multiple business units.

For this report, user business unit security applies to the payment division, not the allocation business units. A user who has access to the payment division will see all related allocations, even if the user is not authorized for those allocation units.

Bank

The default is All; you can select a specific or multiple banks.

The list is based on the Payment Division selected.

Sort Option

From the list, select a group by which you would like to organize the results. Choices include:

Bank
Pay Date
Payment Division
Vendor

The default sort order is Vendor. Whichever Sort Option you choose, the open invoices group and subtotal by that sort option.

Print Cover Page

Allows you to include a cover page with the report, which lists the selected options included in the report.

This option defaults as unchecked.

Format

Select one of these options, Summary or Business Unit Allocation.

If you select the Business Unit Allocation option, the report includes all subtotals paid on an invoice by each distinct Business Unit.

The report Summary does not include this specific information.

Description

Accept the default description, or enter a new one that describes the report you are requesting.

>Report Fields

Summary Report Fields

The sequence of these fields depend on the report Sort Order you select.

Your Sort Order selection appears as a header row at the top of each report section. The header row is not repeated as a column within the report section. Instead, for that specific Sort Order, the column is hidden.

Example If you select Vendor as your Sort Order, then each section on the report includes the vendor's name in the header row. There is no "Vendor" report field within each section.

Report Fields	What is this?
Pay Date	Pay Date as entered in the Vendor Invoice form: payment check date for the invoice.
Due Date	Vendor due date for payment, as entered on the Vendor Invoice form.
Vendor	Vendor firm name, or last name and first name of individual.
Bank/Division	Name of the bank and agency payment division, through which this invoice payment will be made.
Description	Description of the charge, as it appears in the Vendor Invoice data entry form.
GL#	General Ledger account number to be charged when the invoice is paid.
Div/Branch/Dept/Group	The agency Business Unit on the transaction.
Invoice	Vendor invoice number, as entered on the Vendor Invoice data entry form.
Pay Amount	The open amount to be paid on the invoice.

Business Unit Allocation Report Fields

The sequence of these fields depend on the report Sort Order you select.

Example: If you select Vendor as your Sort Order, then each section on the report includes the vendor's name in the header row. There is no "Vendor" report field within each section.

Report Fields	What is this?
Pay Date	Pay Date as entered in the Vendor Invoice form: payment check date for the invoice.
Due Date	Vendor due date for payment, as entered on the Vendor Invoice form.
Vendor	Vendor firm name, or last name and first name of individual.
Bank/Division	Name of the bank and agency payment division, through which this invoice payment will be made.
Description	Description of the charge, as it appears in the Vendor Invoice data entry form.
Invoice	Vendor invoice number, as entered on the Vendor Invoice data entry form.
Pay Amount	The open amount to be paid on the invoice.

CSV Columns

CSV Columns	Description
AsofDate	Date selected as the Reporting End Date under the Select Date option, or under the From List option.
Bank Name	Name of the bank through which this invoice payment will be made.
BankDivName	The agency Division associated with this bank account.
BankGL	The agency general ledger asset account number to which this bank's account transactions post.
PayDate	Pay Date as entered in the Vendor Invoice form: payment check date for the invoice.
DueDate	Vendor due date for payment, as entered on the Vendor Invoice form.
Vendor	Firm name, or last and first name of individual.
Description	Description of the charge, as it appears in the 1279162 data entry form.
Invoice	Vendor invoice number, as entered on the Vendor Invoice data entry form.
InvPayAmount	Amount to be paid (owed) on this invoice.
AllocationGL#	The general ledger account number to be used for posting the invoice expense portion allocated to this transaction's specific business unit. This number corresponds to the GL Number as it appears in the GL Distribution section of the Vendor Invoice data entry form.
AllocationDivision	Division associated with the Allocation GL #, as it appears in the GL Distribution section of the Vendor Invoice data entry form.
AllocationBranch	Branch associated with the Allocation GL#, as it appears in the GL Distribution section of the Vendor Invoice data entry form.
AllocationDepartment	Department associated with the Allocation GL #, as selected in the GL Distribution section of the Vendor Invoice data entry form.
AllocationGroup	Group associated with the Allocation GL #, as selected in the GL Distribution section of the Vendor Invoice data entry form.
AllocationPayAmount	The portion, in dollars, of the invoice pay amount allocated to this business unit for this transaction.