BPM Country Reports

AP Aging

This section describes the fields and actions on the AP Aging workspace.

Overview

This report is a copy of the standard AP Aging report, but this links to the Outstanding Vendor Invoices report. This report is found in the Australia folder.

There are a couple of key differences between the AP Aging report and the Outstanding Customer 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 Description

Universes

Copy to come.

Selection Criteria

Reporting » Statutory Reporting » Australia » A/P Aging

Field Description
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.
Vendor No. Use this field to search for or enter a vendor number.
Company No. Use this field to search for or enter a company number.
Transaction Type Use this field to specify a transaction type.
Vendor Group Use this field to select a vendor group.
Country Use this field to select a country.
Control Account Use this field to select a control account.

Selection Criteria, Dimensions

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

Print Control

Field Description
Include Inactive Vendors Select this check box to include inactive vendors in the list.

Currency

Field Description
Basis Select a currency type from the drop-down list. Available options are:
  • Company
  • Vendor
  • Enterprise
Export Fields and Descriptions
Column Description
No & Name This column displays the number and name of the current drill-down level. The drill-down levels are:
  • Company
  • Vendor
  • Transaction
Balance This column displays the total amount outstanding on vendor invoices, including entries that are not yet due, based on the statement date. Clicking the value in this field will take you to the Outstanding Vendor Invoices report.
0-30 days This column displays the amount outstanding that is up to 30 days old.
31-60 days This column displays the amount outstanding that is between 31 and 60 days old.
61-90 days This column displays the amount outstanding that is between 61 and 90 days old.
91-120 days This column displays the amount outstanding that is between 91 and 120 days old.
121+ days This column displays the amount outstanding that is more than 120 days old.

Limitations

Copy to come.

Generate the Report

Export the Report

To produce the Tax Return Report:

  1. Go to Reporting » Statutory Reporting » Australia » A/P Aging.
  2. Enter the selection criteria for running the report.
  3. To view the data export based on the selection criteria:
    • Click Open PDF Report to generate a PDF file.
    • Click Open Live Report to generate the WebI report.
      Note: When running reports, you may encounter error messages that inaccurately refer to the extension.ini file as server.ini. All updates for Statutory/BPM related settings must go to the extension.ini file only.

It is available on BI Launchpad, in the following folder: Business Performance Management » Reporting » Australia.

Note: The PDF file is not available in the Statutory Retrieval tab in Statutory Reporting workspace. To keep a copy, you must download it to your system.

Submit the Report

Copy to come.

Admin Setup

Maconomy Setup

Copy to come.

External Setup

Copy to come.