One moment please...
 
Exact Globe
  
 

Overview on Accounts Receivable/Payable Aging Analysis Reports

Outstandingitem

 

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.

 

   
 
 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:
 Disclaimer