Outstanding Customer Invoices
This section describes the fields and actions on the Outstanding Customer Invoices workspace.
Overview
This report shows all of the outstanding invoices of the customer based on the company number, statement date, and all applicable prompt values from the AR Aging report. This report is found in the Australia folder.
There are a couple of key differences between the AR 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 by a customer in the General Journal even if there is no customer 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 » Outstanding Customer Invoices
| 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. |
| Company No. | Use this field to search for or enter a company number. |
| Customer No. | Use this field to search for or enter a customer number. |
| Customer Group | Use this field to select a customer group. |
| Job No. | Use this field to search for or enter a job number. |
| Project Manager No. | Use this field to search for or enter a project manager number. |
| Sales Person No. | Use this field to search for or enter a sales person number. |
| 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 Name | Use this field to filter entries by project name. |
| Purpose Name | Use this field to filter entries by purpose name. |
| Spec. 1 - 10 | Use this field to filter entries by other specs as needed. |
| Local Spec. 1 - 10 | Use this field to filter entries by other local specs as needed. |
Currency
| Field | Description |
|---|---|
| Currency Type | Use this field to specify a currency type for the report. |
| Currency | Use this field to specify a currency for the report. |
Print Control
| Field | Description |
|---|---|
| Include Inactive Customers | Select this check box to include inactive customers in the list. |
| Include Blocked | Select this check box to include blocked customers in the list. |
Export Fields and Descriptions
The customer 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. |
| Customer Number | This field displays the customer number. |
| Customer Name | This field displays the customer name. |
| Contact Person | This field displays the name of the contact person on the customer side. |
| Telephone Number | This field displays the telephone number of the customer. |
| This field displays the e-mail address of the customer. |
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
Copy to come.
Generate the Report
Export the Report
To produce the Tax Return Report:
- Go to Reporting » Statutory Reporting » Australia » Outstanding Customer Invoices.
- Enter the selection criteria for running the report.
- 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.