Selection Criteria
Make the following menu selections to display this page:
Reports—Management Reports—Delinquency
This report shows a listing of resident delinquent and/or prepaid amounts. It has two forms; Summary and Detail, both of which may be printed independently. The summary report provides a single delinquent amount per resident. The detail report breaks down delinquencies by income code and ages them.
Recaps
Note
Depending on the criteria selected, the report may include an Aged Delinquency Summary Recap and Aged Prepaid Summary Recap, or a Delinquency Summary by Resident Status Recap. These are summaries of the detail information for each Income Code encountered while printing the report.
Select Properties
Click to select properties from the Select Properties pop-up. The report runs for all selected properties.
Print Aged Detail
By default, this check box is selected to include aged delinquency details on the report. If you do not want to include them, clear this check box.
Print Aged Delinquency Summary Recap
By default, this check box is selected to include summarized aged delinquencies on the report. If you do not want to include them, clear this check box.
Print Aged Prepaid Summary Recap
By default, this check box is selected to include summarized aged prepaids. If you do not want to include them, clear this check box.
Print Delinquency Summary by Resident Status Recap
By default, this check box is selected to include summarized delinquencies listed by resident status on the report. If you do not want to include them, clear this check box.
Print Delinquency Summary
By default, this check box is selected to include summarized delinquencies on the report. If you do not want to include them, clear this check box.
Print Delinquency Memos
By default, this check box is selected to include delinquency memos on the report. If you do not want to include them, clear this check box.
Include Delinquent Balances
By default, this check box is selected to include delinquent balances on the report. If you do not want to include them, clear this check box.
Include Prepaid Balances
By default, this check box is selected to include residents with a prepaid balance on the report. If you do not want to include them, clear this check box.
Include Zero Balances
Use the drop-down to select whether you want the report to include information for residents with zero balances:
Yes—always include residents with zero balances.
No—never include residents with zero balances. If you select No, the Always and Sometimes options are disabled in the Include Cancelled Applicants and Include Previous Residents drop-down lists.
If open items exist—include residents with zero balances only when open items are associated with the residents.
Include Current Resident
By default, this check box is selected to include current residents on the report. If you do not want to include them, clear this check box.
Include Applicants
By default, this check box is selected to include applicants on the report. If you do not want to include them, clear this check box.
Include Waiting List Applicants
By default, this check box is selected to include waiting list applicants on the report. If you do not want to include them, clear this check box.
Include Cancelled Applicants
Use the drop-down to select if and when to include applicants with a Cancelled status when the report is displayed.
Always—always include cancelled applicants regardless of their balance. This option is not available if you selected No from the Include Zero Balances list.
Sometimes—(default) only include cancelled applicants if they have a balance due. This option is not available if you selected No from the Include Zero Balances list.
Never—never include canceled applicants.
Include Previous Residents
Use the drop-down to select if and when to include residents with a Previous status when the report is displayed.
Always—always include previous residents regardless of their balance. This option is not available if you selected No from the Include Zero Balances list.
Sometimes—(default) only include previous residents if they have a balance due. This option is not available if you selected No from the Include Zero Balances list.
Never—never include previous residents.
The report details below assume all defaults are selected.
Recaps Note
Depending on the criteria selected, the report may include an Aged Delinquency Summary Recap and Aged Prepaid Summary Recap, or a Delinquency Summary by Resident Status Recap. These are summaries of the detail information for each Income Code encountered while printing the report.
Aged Delinquency Detail
Apt
The unit number. For instance, 101.
Name
Line 1 lists the name of the primary occupant and line 2 lists their telephone contact number.
Resident Status
The resident status. For instance, Leased. For a complete list of resident statuses, refer to Resident Statuses.
CR ST
The resident's credit status. For instance, N for Normal.
# LT
The number of times the resident has paid late.
# Rtn
The number of time the resident has had a returned check posted to their account.
Description
A brief description of the income code, one listed for each income code shown.
Total Due
The sum of Total Prepaid, Future, 0-30, 31-60, and so on. It is calculated as Prepaid + Future + 0-30 Days + 31-60 Days + 61-90 Days + Over 90 Days. This number ties to the Sum of Prepaid + Delinquent balances on the Reconciliation Report.
Total Prepaid
The sum of resident charges not yet due to be paid; which is the sum of any prepaid open items. A prepaid is an open item with a 0 invoice number and no due date. This number ties to the Total Prepaid field on the Aged Delinquency Reconciliation Report.
0-30 Days
The balance due, if due last month.
31-60 Days
The balance due, if due within the last 31-59 days.
61-90 Days
The balance due, if due within the last 61-89 days.
Over 90 Days
The balance due, if due 91 days and over.
Property Total
Sum amounts listed for Total Due, 0-30 Days, 31-60 Days, 61-90 Days and Over 90 Days.
Aged Delinquency Summary
This section of the report lists the total amount delinquent per income code and breaks down that amount by when that amount was originally due to be paid.
Description
A brief description of the income code, one listed for each income code shown.
Total Due
The sum of the detail for the income code; one line item listed for each income code shown.
Future
The sum of future charges not yet due to be paid.
0-30 Days
The sum of the detail for the income code; for delinquent balances only.
31-60 Days
The sum of the detail for the income code; for delinquent balances only.
61-90 Days
The sum of the detail for the income code; for delinquent balances only.
Over 90 Days
The sum of the detail for the income code; for delinquent balances only.
Aged Prepaid Summary
This section of the report lists the total amount prepaid for each income code.
Description
Total Due
Summary by Unit Status
Description
A brief description of the income code.
Total
The sum of the details for each income code listed.
Applicant
The sum of the detail for each income code listed per Applicant. This includes leases with a status of Applicant, Approved, Leased, or Transfer In.
Current
The sum of the detail for each income code listed per Current. This includes leases with a status of Current, Notice, or Transfer Out.
Previous
The sum of the detail for each income code listed per Previous. This includes leases with a status of Previous or Canceled.
Grand Total
Total Due
The sum of the detail for all properties listed.
Total Prepaid
The sum of the detail for all properties listed.
Future
The sum of the detail for all properties listed.
0-30 Days
The sum of the detail for all properties listed.
31-60 Days
The sum of the detail for all properties listed.
61-90 Days
The sum of the detail for all properties listed.
Over 90 Days
The sum of the detail for all properties listed.
To Display the Delinquency Report
See Also
Copyright © 2018 Infor. All rights reserved. www.infor.com.