BPM Country Reports

Outstanding Vendor Invoices

This section describes the fields and actions on the Outstanding Vendor Invoices workspace, as well as instructions on how to generate the report.

Quick Links: Selection Criteria | Generate Report | Report Fields | Limitations | Admin Setup

Overview

This report shows all of the outstanding invoices to be paid to the vendor based on the company number, statement date and all applicable prompt values from the AP Aging report. There are a couple of key differences between the AP Aging report and the Outstanding Vendor Invoices report. Specifically:

  • The Aging report filters out records that summarize to zero if these records also do so on the lowest drill-down level (that is, records that do not add to the balance on any level of detail). On the Outstanding report, such records are included because they add value and insight.
  • The Aging report may also list payments made without a corresponding invoice, while the Outstanding report does not because it concentrates on invoices and credit memos. For example, if a payment is made to a vendor in the General Journal even if there is no vendor invoice, that payment will appear in the Aging report as a negative balance, but is filtered out in the Outstanding report. However, if that same payment is reconciled against an invoice, the Outstanding report will list the invoice and the reconciled amount as the paid amount.
Note: While this report was created primarily to address an Australian statutory requirement, it can also be utilized by companies from other countries. Reach out to Consulting or Customer Care for more information.

Report Workspace

Navigation

To open the report workspace, select Reporting » Country Reports » Australia » Outstanding Vendor Invoices.

Or, go to Reporting » BI Launch Pad and click Open BI Launch Pad. The report is located on the Business Performance Management » Reporting » Australia folder.

Selection Criteria

Field Description
Currency Type Use this field to specify a currency type for the report.
Include Inactive Vendors Select this check box to include inactive vendors in the list.
Statement Date Use this field to filter the entries to be included in the report. Only open entries and reconciliations entered before or on the statement date you specify are included in the report.
Company No. Use this field to search for or enter a company number.
Vendor No. Use this field to search for or enter a vendor number.
Vendor Group Use this field to select a vendor group.
Control Account Use this field to select a control account.
Transaction No. Use this field to specify a transaction number.
Transaction Type Use this field to specify a transaction type.
Currency Use this field to specify a currency for the report.

Dimensions

Field Description
Location Name Use this field to filter entries by location.
Entity Name Use this field to filter entries by entity.
Project Name Use this field to filter entries by project.
Purpose Name Use this field to filter entries by purpose.
Spec. 1 - 10 Name Use this field to filter entries by other specs as needed.
Local Spec. 1 - 10 Name Use this field to filter entries by other local specs as needed.

Generate the Report

Export the Report

To generate the report:

  1. Go to Reporting » Country Reports » Australia » Outstanding Vendor Invoices.
  2. Enter the selection criteria for running the report.
  3. Click Run. The screen refreshes and displays the generated report.

    To keep a copy, click the Download icon. In the dialog box, specify the parameters for the export file (file type, reports and options), then click Export.

Submit the Report

Not applicable for this report.

Report Description

Export Fields and Descriptions

The vendor information above the data table includes the following:

Field Description
Currency This field displays the currency used in the report.
Country Number This field displays the country number.
Country This field displays the country name.
Vendor Number This field displays the vendor number.
Vendor Name This field displays the vendor name.
Contact Person This field displays the name of the contact person on the vendor side.
Telephone Number This field displays the telephone number of the vendor.
E-mail This field displays the e-mail address of the vendor.

The data table includes the following:

Top-Level Header Column Description
Invoice No. This field displays the invoice number.
Name This field displays the name or reference of the invoice.
Date This field displays the date an entry was invoiced.
Due Date This field displays when payment for the invoice is due.
Invoiced Excl. Tax This field displays the invoiced amount excluding taxes. The total is shown at the end of the column.
Tax This field displays the tax amount of the invoice. The total is shown at the end of the column.
Incl. Tax This field displays the invoiced amount including taxes. The total is shown at the end of the column.
Paid Incl. Tax This field displays the amount already paid (that is, reconciled) including taxes. The total is shown at the end of the column.
Outstanding Excl. Tax This field displays the outstanding amount excluding taxes. The total is shown at the end of the column.
Tax This field displays the outstanding tax amount.

Limitations

None reported.

Admin Setup

Maconomy Setup

Not applicable for this report.

External Setup

Not applicable for this report.