1. Home
  2. /
  3. Panel Help
  4. /
  5. Financials
  6. /
  7. A/R statistics enquiry (FKR53501)

A/R statistics enquiry (FKR53501)

Related topics

This panel displays payment statistics in system currency. The following selection criteria are available:

  • Debtor no
  • Cost centre (if Cost centre handling is used)
  • Division (if Division handling is used)
  • Cost centre and debtor
  • Division and debtor

Note: You can display the balance for the entire company if you leave Debtor, Cost centre and Division blank.

The system always calculates statistics for average overdue days. The calculation is based on two different methods. Calculated values from both methods are stored in the Payment statistics file. In the A/R control file (the Payment stat method field) you define according to which method the average overdue days should be presented whenever displayed or printed. See the Avg odue field on this panel for more information about the calculation methods.

Function keys





For more information about additional functions accessible from this panel, see Functions in function list.

Debtor no
Enter the number of the debtor for which you want information and click OK. The internal name and telephone number of the selected debtor will be shown next to the number. The available function keys give access to different kinds of information for the entered debtor.
Stat group
Displays the payment statistics group to which the debtor belongs.
Cust struct
Only displayed if the Business partner structure function is activated, and Debtor no has been completed. Indicates if the debtor exists in a customer structure.
Grand total
The panel will display grand totals for this company if you leave Debtor, Cost centre and Division blank.
Cost centre
Enter the cost centre alone or in combination with a debtor number. If cost centre is completed, Division must be blank.
Division
Enter a division alone or in combination with a debtor number. If division is completed, Cost centre must be blank.
Period name
The values are shown for the previous twelve months as well as for the actual month. If you have entered transactions for a period which is later than the actual period, then these will not be included in the statistics.
Year
Displays the applicable year.
Inv/Cred nts
Displays the total amount of invoices and credit notes for the period.
Payments
Displays the total amount of payments for the period.
Avg odue
Displays the average overdue days for the period. The value in this field is presented according to the payment statistics method specification made in the A/R control file.

No total amount of days is shown for the past year or this year. If the number of days is a negative number, the debtors in this group paid the invoices, on average, before they were due. This column is updated when a batch is closed.

Statistics method description:

Calculation example:

Turnover
Displays the turnover amount, which can be the invoice amount less VAT per period and in system currency. The amount does not include the value of interest invoices.