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

A/P statistics enquiry (FLR53501)

Related topics

This panel displays payment statistics in system currency.

The following selection criteria are available:

  • Supplier no
  • Cost centre (if Cost centre accounting is used)
  • Division (if the Division concept is used)
  • Cost centre and supplier
  • Division and supplier

Note: You can display the balance for the entire company if you leave the Supplier, Cost centre and Division fields 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 Payment stat method field in the A/P control file, 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.

Supplier no
Enter the number of the supplier for which you want information and click OK. The internal name and telephone number of the selected supplier will be shown next to the number. The available function keys give access to different kinds of information for the entered supplier.
Stat group
Displays the payment statistics group to which the supplier belongs.
Supp struct
Only displayed if the Business partner structure function is activated, and Supplier no has been completed. Indicates if the supplier exists in a supplier structure.
Grand total
The panel will show grand totals for this company if you leave the Supplier no, Cost centre and Division fields blank.
Cost centre
Enter the cost centre alone or in combination with a supplier number. If this field is completed, then Division must be blank.
Division
Enter a division alone or in combination with a supplier number. If this field is completed, then 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/P 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 suppliers 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.