Standard Report Update - Version 1450

REPORT VERSION: 1450

RELEASE DATE: 25/05/2020

New Right Click Reports

Accounts Payable Invoice

This report is run from the right click menu 'Show accounts payable invoice' on an invoice under the Accounts Payable Invoices tree in the employer manager. This report will display the organisation, invoicee, invoicee bank account details and invoice details. The image loaded into the Organisation Wizard will also display in the top right hand corner. This report is only available to customers who have the Agent Commissions add-on. 

Accounts Payable Receipt

This report is run from the right click menu 'Show accounts payable receipt' on a payment record under an accounts payable invoice within the Accounts Payable Invoices tree in the employer manager. This report will display a Remittance Advice including the organisation, payee, and payment details. The image loaded into the Organisation Wizard will also display in the top right hand corner. This report is only available to customers who have the Agent Commissions add-on. 

Agency Enrolments Report

This report is run from the right click menu 'Show agency enrolments report' on the Agency enrolments node in the employer manager. This report will display a list of enrolments where the employer has been selected as the agency in the Enrolment wizard. Includes Client, Enrolment, Agent, Full Invoiced Amount, Commissionable Invoiced Amount, Commission Rate Percentage, Commission from Invoiced Amount, Commission Rate Flat Amount and Accounts Payable Invoiced Amount. This report is only available to customers who have the Agent Commissions add-on. 

Agent Enrolments Report

This report is run from the right click menu 'Show agent enrolments report' on the Agent enrolments node in the client manager. This report will display a list of enrolments where the client has been selected as the agent in the Enrolment Wizard. Includes Client, Enrolment, Full Invoiced Amount, Commissionable Invoiced Amount, Commission Rate Percentage, Commission from Invoiced Amount, Commission Rate Flat Amount and Accounts Payable Invoiced Amount. This report is only available to customers who have the Agent Commissions add-on. 

Commission Rule Report

This report is run from the right click menu 'Show commission rules report' on the Commission Rules node in the configuration manager. This report will display a list of all commission rules entered under this node. Includes Name, Code, Description, Commission Model, Ledger, Rate Percentage, Rate Amount, Generate Agency Commission Invoice and Pricing Items. This report is only available to customers who have the Agent Commissions add-on. 

Employer Accounts Payable Invoice Summary Report

This report is run from the right click menu 'Show accounts payable invoice summary report' on the Accounts Payable Invoices node in the employer manager. This report will display a list of all accounts payable invoices for the employer. Includes Invoice Number, Invoice Date, Agent(s), Commission Source Invoice and Enrolment, GST, Amount (inc GST), Payments and Outstanding Amount.  This report is only available to customers who have the Agent Commissions add-on. 

Generate Agent Commission Summary Report

This report is run when selecting the 'Print commission summary report' option at the end of the Generate Agent Commissions Wizard. This report will display a list of all accounts payable invoices that are created at the time of finishing the wizard. This report will display a list of all accounts payable invoices for the employer. Includes Agent, Invoice Number, Invoice Date, Invoice Amount and Commission Source Invoice and Enrolment.  This report is only available to customers who have the Agent Commissions add-on. 

Recipient Created Tax Invoice

This report is run from the right click menu 'Show RCTI' on an invoice under the Accounts Payable Invoices tree in the employer manager. This report will display the organisation, invoicee, invoicee bank account details, invoice details as well as commission source details. The image loaded into the Organisation Wizard will also display in the top right hand corner. This report is only available to customers who have the Agent Commissions add-on.

Updated Right Click Reports

Client Invoice Summary Report

1. Formatting Changes. The fonts and margins have been changed to align with the formatting of the standard reports.
2. Exclude Accounts Payable Invoices. Updated the report to exclude Accounts Payable Invoices when the Agent Commissions feature is used.
3. Invoice #. Updated the Invoice # column to display the invoice number, previously it was displaying an internal identifier for the invoice.

Clients Report

1. Formatting Changes. The fonts and margins have been changed to align with the formatting of the standard reports.
2. Client Status Update. The report has been updated to work with the Pending client status.

Employer Contact Report

1. Agent Column. A column has been added to display whether the employer contact is an agent. This column will only display when the employer is an agency. The agent and agency flag is only available to customers who have the Agent Commissions add-on.

Employer Contract Report

1. Formatting Changes. The fonts and margins have been changed to align with the formatting of the standard reports.

Employer Detail Report

1. Agency Details. Added agency and bank account details when the employer is flagged as an agency. The agency flag is only available to customers who have the Agent Commissions add-on.
2. User and VT Code. Updated the Employer Code field label to VT Code to align with the field name in VETtrak and added the User Code.

Employer Invoice Summary Report

1. Formatting Changes. The fonts and margins have been changed to align with the formatting of the standard reports.
2. Exclude Accounts Payable Invoices. Updated the report to exclude Accounts Payable Invoices when the Agent Commissions feature is used.

Funding Model Report

1. Schedule Rule. Added a column to display the schedule rule selected against each pricing item.
2. National. Updated the report to work with national funding models.

Invoice Schedule Report

1. New Columns. Added Ledger and Schedule Rule columns.

Invoice Statement Report

1. Exclude Accounts Payable Invoices. Updated the report to exclude Accounts Payable Invoices when the Agent Commissions feature is used.

Occurrence Invoice Summary Report

1. Exclude Accounts Payable Invoices. Updated the report to exclude Accounts Payable Invoices when the Agent Commissions feature is used.

Occurrence Payments Report

1. Formatting Changes. The fonts and margins have been changed to align with the formatting of the standard reports.
2. Exclude Accounts Payable Invoices. Updated the report to exclude Accounts Payable Invoices when the Agent Commissions feature is used.
3. Amount Total. Added a total of all payments to the end of the report.

Programmes Report

1. Formatting Changes. The fonts and margins have been changed to align with the formatting of the standard reports.
2. New Columns. Added columns to display Programme Type, Bar Colour, Shown in Waitlists, Allows Tasks and Available in VETembark.

Updated Standard Reports

Client Reports\Client Information Export Report

1. Client Status Filter. Updated the Client Status Filter to include the new Pending option.
2. Client Status Column. Added a column to display the Status as found on the first page of the Client Wizard.

Enrolment Reports\Enrolment Export Report

1. Client Status Filter. Updated the Client Status Filter to include the new Pending option.

Enrolment Reports\Enrolment Pricing Item Report

1. Schedule Rule Records. Updated the report to show scheduled pricing items that do not have a fixed date such as those that have a Schedule Rule applied.

Financial Reports\Aged Receivables Report

1. Invoice Type Filter. Added an Invoice Type filter to the report to filter by Invoices (Debtor) and Accounts Payable invoices.
2. Accounts Payable Invoices. The report will now group Accounts Payable Invoices separate to normal invoices. Accounts payable invoice types are only able to be recorded by customers with the Agent Commissions add-on.

Invoice Reports\Invoice Item Export Report

1. Invoice Type Filter. Added an Invoice Type filter to the report to filter by Invoices (Debtor) and Accounts Payable invoices.
2. Invoice Type Column. Added an Invoice Type column to display whether the invoice is an Accounts Payable Invoice. Accounts payable invoice types are only able to be recorded by customers with the Agent Commissions add-on.
3. Credit Terms. Added columns to display the Credit Term information selected against the invoice.

Invoice Reports\Invoice Item Report

1. Invoice Type Filter. Added an Invoice Type filter to the report to filter by Invoices (Debtor) and Accounts Payable invoices. Accounts payable invoice types are only able to be recorded by customers with the Agent Commissions add-on.
2. Invoice Number Filter. Added an Invoice Number filter to the report to filter by a single invoice number or a number range.

Invoice Reports\Invoice Report

1. Invoice Type Filter. Added an Invoice Type filter to the report to filter by Invoices (Debtor) and Accounts Payable invoices. Accounts payable invoice types are only able to be recorded by customers with the Agent Commissions add-on.
2. Invoice Number Filter. Added an Invoice Number filter to the report to filter by a single invoice number or a number range.

Invoice Reports\Invoice Schedule Report

1. Payment Due Date Filter. A date range option has been added to filter on Payment Due Dates.
2. Schedule Rule Filter. A filter has been added to filter on the Schedule Rule applied to the pricing item.
3. Schedule Rule Column. Added a column to display the Schedule Rule applied to the pricing item.
4. Exclude Archived/Inactive Filters. Added a check box above the Pricing Item filter option to exclude archived/inactive records from the selections. This will be checked by default.

Invoice Reports\Invoice by Invoice Number or Date Range

1. Exclude Accounts Payable Invoices. Updated the report to exclude Accounts Payable Invoices when the Agent Commissions feature is used.

Payment Reports\Payment Breakdown Export Report

1. Invoice Type Filter. Added an Invoice Type filter to the report to filter by Invoices (Debtor) and Accounts Payable invoices.
2. Invoice Type Column. Added an Invoice Type column to display whether the invoice is an Accounts Payable Invoice. Accounts payable invoice types are only able to be recorded by customers with the Agent Commissions add-on.

Payment Reports\Payment Breakdown Report

1. Invoice Type Filter. Added an Invoice Type filter to the report to filter by Invoices (Debtor) and Accounts Payable invoices.
2. Invoice Type Column. Added an Invoice Type column on the Excel Export side of the report to display whether the invoice is an Accounts Payable Invoice. Accounts payable invoice types are only able to be recorded by customers with the Agent Commissions add-on.

Payment Reports\Payment Breakdown Report by Ledger

1. Invoice Type Filter. Added an Invoice Type filter to the report to filter by Invoices (Debtor) and Accounts Payable invoices.
2. Invoice Type Column. Added an Invoice Type column on the Excel Export side of the report to display whether the invoice is an Accounts Payable Invoice. Accounts payable invoice types are only able to be recorded by customers with the Agent Commissions add-on.

Payment Reports\Payment Information Report

1. Invoice Type Filter. Added an Invoice Type filter to the report to filter by Invoices (Debtor) and Accounts Payable invoices. Accounts payable invoice types are only able to be recorded by customers with the Agent Commissions add-on.

Payment Reports\Payment Report

1. Invoice Type Filter. Added an Invoice Type filter to the report to filter by Invoices (Debtor) and Accounts Payable invoices.
2. Invoice Type Column. Added an Invoice Type column on the Excel Export side of the report to display whether the invoice is an Accounts Payable Invoice. Accounts payable invoice types are only able to be recorded by customers with the Agent Commissions add-on.

Payment Reports\Payment Report by Ledger

1. Invoice Type Filter. Added an Invoice Type filter to the report to filter by Invoices (Debtor) and Accounts Payable invoices.
2. Invoice Type Column. Added an Invoice Type column on the Excel Export side of the report to display whether the invoice is an Accounts Payable Invoice. Accounts payable invoice types are only able to be recorded by customers with the Agent Commissions add-on.

Payment Reports\Receipt by Receipt Number or Date Range

1. Exclude Accounts Payable Invoices. Updated the report to exclude Accounts Payable Invoices when the Agent Commissions feature is used.