Exact Globe

Overview on Accounts Receivable/Payable Aging Analysis Reports




Explanation of fields

Additional Criteria

Range Section

Currency Section




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




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.



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.



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.



Use this selection to filter the customers by their status.



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.



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.



Filter the report by selecting a range of projects.



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.



Another criterion to filter out unnecessary debtor accounts.



You can select the group of debtors by specifying the debtor scenario.



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.



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.




Click on this button to generate the report.



Clicking on this button exits the report selection and returns to the main menu.


 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 10.765.514
 Assortment:  Date: 10-06-2005
 Release:  Attachment:

No tags added
One moment please...