Accounts Receivable Reports

Standard System Enquiries and Reports

Customer Aged Debt Enquiry

Location: Main Menu > Accounts Receivable > AR Enquiries > Aged Debt Enquiries > Customer Aged Debt Enquiry

Here, an on-line Aged Debtors for all customers can be displayed by selecting the appropriate company and clicking ok in the Selection screen.

Entering other values into the selections will filter your enquiry to the detail required.

The Customer Aged Debt List screen displays the breakdown of customer aged debt balances for the selections provided.

The following similar Aged Debt enquiries are also available as standard to all greater flexibility of the output you require.

• Structure Aged Debt Enquiry
• Location Aged Debt Enquiry
• Historic Aged Debt Enquiry

Account Enquiries

Location: Main Menu > Accounts Receivable > AR Enquiries > Transaction Enquiries > Customer Account Enquiry

Here, an on-line overview for all customers can be displayed by selecting the appropriate Ledger and clicking ok in the Selection screen.

Entering other values into the selections will filter your enquiry to the detail required.

The Account List screen displays the breakdown of customers and their outstanding balances.

You can filter your selection further using the extended selection.

Transaction Enquiries

Location: Main Menu > Accounts Receivable > AR Enquiries > Transaction Enquiries > Transactions by Customer

You can view a list of all transactions by customer account by entering the Ledger and Customer you want to view.

Entering other values into the selections will filter your enquiry to the detail required.

The Transaction List screen displays a header containing key Account information such as address and balance information, as well all transactions relative to your selections.

The following similar Transaction enquiries are also available as standard to all greater flexibility of the output you require.

• Transactions by Transaction Ref
• Transactions by Order Ref
• Transactions by Structure Point

Ad Hoc Reports

AR1.1 Aged Debt Balance by Ledger - Ad Hoc View Report

An example Aged Debtors can be found in Accounts Receivable > Sample Reports > Ad Hoc views and Reports and lists all Customer Accounts with an outstanding balance, grouped by Ledger, and displaying values relative to their ageing bands.

The report is linked to the AR1.1 Aged Debt Balance by Ledger - Ad Hoc View, so you can take a copy, amend the fields and filters, and create a similar report that meets your requirements.

The report is linked to the AR1.1 Aged Debt Balance by Ledger - Ad Hoc View, so you can take a copy, amend the fields and filters, and create a similar report that meets your requirements.

AR1.2 Aged Debt Balance by Department and Ledger - Ad Hoc View Report

An example Aged Debtors can be found in Accounts Receivable > Sample Reports > Ad Hoc views and Reports and lists all Customer Accounts with an outstanding balance, grouped by Ledger, and displaying values relative to their ageing bands.

The report is linked to AR1.2 Aged Debt Balance by Department and Ledger - Ad Hoc View, so you can take a copy, amend the fields and filters, and create a similar report that meets your requirements.

AR1.3 Outstanding Customer Accounts - Ad Hoc View Report

The Outstanding Customer Accounts report in Accounts Receivable > Sample Reports > Ad Hoc views and Reports lists Customer and address details for those with filtered minimum balance and ranking.

The report is linked to AR1.1 Aged Debt Balance by Department and Ledger - Ad Hoc View so you can take a copy, amend the fields and filters, and create a similar report that meets your requirements.

AR2.1 Transaction Listing - Ad Hoc View Report

This report, found in Accounts Receivable > Sample Reports > Ad Hoc views and Reports and produces a list of transactions for all customers, filtered by Ledger.

AR3.1 Forward Cash Flow Report by Ledger Ad Hoc View Report

This report holds values in buckets of 30 days, showing due amounts, overdue amounts, and unallocated cash. Ledger codes, total debt value and account ranges can be used to filter the data.

The report is linked to AR3.1 Forward Cash Flow Report by Ledger Ad Hoc View so you can take a copy, amend the fields and filters, and create a similar report that meets your requirements.

AR3.2 Forward Cash Flow Report by Department and Area Ad Hoc View Report

This report holds values in buckets of 30 days, showing due amounts, overdue amounts, and unallocated cash, grouped by Department and Area. Ledger codes, total debt value and account ranges can be used to filter the data.

The report is linked to AR3.1 Forward Cash Flow Report by Ledger Ad Hoc View so you can take a copy, amend the fields and filters, and create a similar report that meets your requirements.

AR4.0 Total Owed Dashboard Component-Ad Hoc View Report

This report Displays the top 6 Ledger/Account debt values as a pie chart and can be used independently or, for example, as a component within a dashboard.

The report is linked to AR4.0 Total Owed Dashboard Component-Ad Hoc View so you can take a copy, amend the fields and filters, and create a similar report that meets your requirements.

ARX.1 Accounts and Credit Limits Ad Hoc View Report

This report shows Customer Account credit limits, the output can be filtered by, Ledger Codes, credit limit values, and balance type.

The report is linked to ARX.1 Accounts and Credit Limits Ad Hoc View so you can take a copy, amend the fields and filters, and create a similar report that meets your requirements.

ARX.2 Overdue and Due Balances Ad Hoc View Report

This report allows you to filter the data by ledger and element, total overdue values, and balance type. Overdue / Due Debt and Future Period debt is displayed by Ledger / Account.

The report is linked to ARX.2 Overdue and Due Balance Ad Hoc View so you can take a copy, amend the fields and filters, and create a similar report that meets your requirements.

This report allows you to filter the data by Ledger, Credit Limits, and Highest Balance YTD The report lists the Primary Credit limits by Ledger and Account and also shows Temporary Credit Values and Highest Balance YTD figures

The report is linked to ARX.2 Overdue and Due Balance Ad Hoc View so you can take a copy, amend the fields and filters, and create a similar report that meets your requirements.

ARX.6 Average Days To Pay - Ad Hoc View

This report allows you to filter the data by Ledger and Account Codes and “Average Days to Pay YTD.” This report lists Average Days to Pay for Ledger and Account in buckets of period offsets.

The report is linked to ARX.2 Overdue and Due Balance Ad Hoc View so you can take a copy, amend the fields and filters, and create a similar report that meets your requirements.

Dashboards

Debt Dashboard

An example Debt Dashboard can be found in Accounts Receivable > Sample Reports > Dashboard and makes use of the reports in the Accounts Receivable/Sample Reports/Dashboard/Components folder. In addition, a number of the charts within the dashboard can be drilled on so that the user can investigate further detail.

Please note this is a demonstration dashboard and although it may be filtered to give accurate data, this cannot be guaranteed as the fields/filters used the component reports may not match the structural setup of you Advanced Financials system.

You can take a copy of the Dashboard, add/remove/relocate reports components and filters to create your own dashboards.

Changing the 

option to

will enable you to move or remove reports/charts on the current dashboard as well as create new content, add other existing reports, and change the filters being used.

Transaction Types & Debts Dashboard

A Dashboard showing Transaction Types & Debts can be found in Accounts Receivable > Sample Reports > Dashboard and makes use of the reports in the Accounts Receivable/Sample Reports/Dashboard/Components folder. In addition, a number of the charts within the dashboard can be drilled on so that the user can investigate further detail.

Please note this is a demonstration dashboard and although it may be filtered to give accurate data, this cannot be guaranteed as the fields/filters used the component reports may not match the structural setup of you Advanced Financials system.

You can take a copy of the Dashboard, add/remove/relocate report components and filters to create your own dashboards.

Changing the 

option to 

will enable you to move or remove reports/charts on the current dashboard as well as create new content, add other existing reports, and change the filters being used.