Introduction
Explanation
of fields
Additional
Criteria
Range Section
Currency
Section
Introduction
The Accounts Receivable (A/R) Aging Analysis report displays
the outstanding amount from debtors while the Accounts Payable (A/P) shows
amount due to creditors. These reports group the expected cash flows into
different aging groups in order for you to see how much is going in and out for
certain periods. You can view the A/R report using [Finance / Accounts Receivable
/ Receivables / Aging Analysis] and the A/P report using Finance / Accounts
Payable / Payables / Aging Analysis].
Explanation of fields
Criteria Section
Sorting
This selection allows you to choose how the report should be
sorted. Sorting by due date means by aging, which is dependent on the aging
criterion.
Age
The outstanding invoices are grouped by this aging
criterion.
Invoice Currency
You can choose to view the report by specific currency, the
system default currency, the invoice currency, etc.
Additional Criteria
Clicking on this button will prompt another selection window
as shown below.
The A/R additional
criteria screen
Debtor Data
Checking this option will display additional data about the
debtor such as the address, contact, bank account, etc.
Minimum Age
This criterion filters the age of outstanding amounts such
that only those above this number will be shown in the report.
New Page Every Debtor
By selecting this option, all debtors will be printed on a
new page.
Only with Notes
If you check this selection, the report will only show
transactions with notes attached.
Summarize
You can opt to view the amount owed by each debtor for each
aging group, without the invoice details using this selection.
Exclude Unknown Debtor
Checking this option will exclude unknown debtor from the
report.
The A/P additional
criteria screen
Include tax creditors
Select this criterion to also display amounts owed to tax
creditors.
Other fields are similar to the A/R screen, and thus have
the same functionality. Only differences are these options are now applicable
for creditors instead of debtors
Range Section
Reference Date
The report will only display transactions prior to the date
selected here.
Status
Use this selection to filter the customers by their status.
Type
You can specify whether to show only customer data or
employee data or even both.
Debtor / Name / Post Code / Classification
/ Due Date
This selection will change based on the Sorting order
selected, in which you can choose a range to show only the selected in the
report.
Items
Choosing all items will display all outstanding amounts, but
if you select Due, then only the amounts that are supposed to be paid before
the reference date will be shown in the report.
Project
Filter the report by selecting a range of projects.
CostCenter
You can also select to view only outstanding amounts of particular
cost centers.
Account Employee
Use this selection to filter which debtor accounts to be
included into the report.
Intermediary
Another criterion to filter out unnecessary debtor accounts.
Scenario
You can select the group of debtors by specifying the debtor
scenario.
Blocked
Choose to display only blocked amounts, to exclude blocked
amounts or to include them into the report.
Payment Method
Specify a payment method and only transactions using this
method will be shown in the report.
Currency Section
Summary: Foreign Currency
Checking this option will show a short summary for each
debtor and each currency for the total amounts owed. This selection is only
available when All – Default Currency is selected for Invoice Currency.
Exchange Rate
Amounts in foreign currency are converted to the default
currency in the report using different exchange rates. You can specify the type
of exchange rate to be used by choosing from this selection.
- Original – Uses the exchange rate
that was used when creating the invoice.
- Current – Uses the current date’s
exchange rate.
- Historical
– Uses a selected date’s exchange rate.
Date
You can select a particular date’s exchange rate to be used
in the report. This date selection is only enabled if Historical exchange rate
has been selected previously.
At the bottom of the screen, these buttons are available.
Start
Click on this button to generate the report.
Close
Clicking on this button exits the report selection and
returns to the main menu.