Largest Debtors - FINR300 - Financial - P12

01. OVERVIEW

This report lists the largest debtors along with the respective amounts in arrears, the total amount owed, the number of bills, and the total of days in arrears.

02. PARAMETERS

1. Number of Debtors?
   1. Enter the number of debtors you want to view in the report.
2. Days in arrears?
   1. Average 
      1. To get the average, the report calculates the number of days in arrears and divides it by the number of customer bills.
   2. Maximum Arrears Period
      1. The largest overdue period will be considered.
3. Which Currency? 
   1. Select the currency of the report. 
4. Other Currencies?
   1. Convert
      1. Select this if you want to consider bills issued in other currencies in the report.
   2. Do not print
      1. Select this if you want to consider only bills with the currency set in question 3.

03. EXAMPLE OF USE

In a scenario with three bills as detailed below, the report will be generated with the database on 11/7/2019.

The report displays two pages with information on the debtors ordered distinctly. The first ordering is by Largest Debtors, i.e., it considers all customer bills, including bills due. The second ordering is by Largest Values in Arrears, i.e., it considers only bills overdue when comparing the due date with the database. Interests, fines, and accessory values are projected and considered for bills overdue.
The first page displays the Largest Debtors, and the ordering is on column Total Due.

The second page displays the Largest Values in Arrears, and the ordering is on the Value in Arrears column.
Note: The bill with prefix 003 number 000003 is considered only in the Total Due column because the report is generated with the database on 11/7/2019, and the bill's due date is 11/8/2019.

04. TABLES USED