Note

An asterisk (*) indicates a required field or selection.

Select Properties

Click to select properties from the Select Properties pop-up. The report runs for all selected properties.

From Date

Printing the report calls for a date range to print from. Enter the first day of the date range using the format mm/dd/yyyy. Or use the Calendar Button to display a date.

Thru Date *

Printing the report calls for a date range to print from. Enter the last day of the date range using the format mm/dd/yyyy. Or use the Calendar Button to display a date.

From Building

Printing the report calls for a building range to print from. Enter the first number of the building range. Or use the drop-down to display a lookup list.

To Building

Printing the report calls for a building range to print from. Enter the last number of the building range. Or use the drop-down to display a lookup list.

From Apt

Printing the report calls for a unit range to print from. Enter the first number of the unit range. Or use the drop-down to display a lookup list.

To Apt

Printing the report calls for a unit range to print from. Enter the last number of the unit range. Or use the drop-down to display a lookup list.

Activity to include

Select what activity to include from the drop-down list. Options include: Rent/Other Activity or Security Deposit Activity.

- Rent/Other Activity (default)—All transaction detail for payments (3) is summed and printed on one line with a blank income code.

- Security Deposit Activity—All transaction detail for billings (1 or 9) are summed and printed on one line with a blank income code.

Include Subsidy

Select to filter based on the Income Code subsidy flag setting for charges, which indicates if they are subsidized (government paid) or non-subsidized (self paid). Options include:

- Subsidy and Non-Subsidy (default)—Show both subsidized and non-subsidized charges.

- Subsidy only—Show only subsidized charges.

- Non-subsidy only—Show only non-subsidized charges.

Sort By

Select how to sort the report data from the drop-down list. Options include:

- Transaction Date (default)—Data is sorted by the date of the transaction.

- Date of Record—Data is sorted by the date of record.

- Invoice Number—Data is sorted by the invoice number.

- Entry Order—Data is sorted in the order it was entered into the system.

- Due Date—Data is sorted by the transaction due date.

Summarize Payments by Check

Accept the unchecked default to list check payments as one line per check. Or, check to combine the sum of all check payments and list as one line item.

Summarize Billings by Invoice

Accept the unchecked default to list invoice billings as one line per charge. Or, check to combine the sum of all invoice billings and list as one line item.

Separate Page per Resident

Accept the unchecked default to print the pages of the report in one continuous cycle. Or, check to print the report as one resident per page.

Include Current Residents

Accept the checked default to include residents with a Current status. Or, uncheck to exclude them.

Include Applicants

Accept the checked default to include applicants with an Applicant status. Or, uncheck to exclude them.

Include Wait List Applicants

Accept the unchecked default to exclude residents with a Wait List status. Or, check to include them.

Include Canceled Applicants

Accept the unchecked default to exclude applicants with a Canceled status. Or, check to include them.

Include Previous Residents

Accept the unchecked default to exclude applicants with a Previous status. Or, check to include them.  

Select Report Style

Accept the Standard default to display the report data in a portrait layout. Or, select Compressed to  display it in a compressed layout.

Note

The following report details assume all defaults are selected. The display may vary depending on the criteria you select.

Resident Info

The building + unit number. For instance, 01-A101.

The primary occupant name. For instance, Sally Smith.

The resident status. For instance, Applicant or Current.

Beginning Balance

This number is calculated by taking the resident's current ending balance and backing out all activity after the From Date specified in the report date range.

Tran. Date

The date the transaction was entered into the system, typically the system log on date.

Date of Record

Every ledger transaction is assigned a date, the Date of Record which is associated with an accounting period through the accounting period tables. In order for a transaction to post, the accounting period must be active or the log on date must fall within the grace period as defined in global policies. For most transactions, the Date of Record equals the transaction date.

Due Date

The definition of a due date varies according to the transaction. If the transaction is a charge, then the due date is the date the charge is due to be paid. If the transaction is a payment, then the due date is the date the payment was made. If the transaction is a billing, then there is no due date. In this case, the field displays blank.

SC

The identifying source code. For a complete list of source codes, refer to Source Codes.

Desc.

A brief description of the transaction, for instance, Payment. For estimate or actual recovery charges that appear on the Resident History report, the description is pulled from the Transaction Description field on the Estimate Recovery or Actual Recovery tabs.

Invoice

The identifying invoice number assigned to the charge. If for a payment, then this is the actual invoice number of the charge paid. If this is for a prepayment, then the invoice number is 0.

Code

The income code applied to the transaction. For instance, RENT.

Billings

The transaction amount where the transaction type is 1 (recurring charge), or 9 (one-time charge) and the Receivable flag is set to Y.

Adjust.

The transaction amount where the transaction type is 2 (adjustment), or 6 (transfer balance) and the Receivable flag is set to Y.

Non-Rec. Adjust.

The transaction amount where the transaction type is 1 (recurring charge), 2 (adjustment), or 9 (one-time charge) and the Receivable flag is set to N.

Payments

The global policy, Display and print payments as credits affects this field.

The transaction amount where transaction type is 3 (payment) which may print with a reversed sign depending on the policy setting.

Ret.

The count of returned checks posted to the resident's account.

Refer.

If a reference number was entered during the transaction entry, it displays in this field. For instance, the number of the check the resident used for submitting payment.

Refunds

The transaction amount where the transaction type is 5 (refund).

Forfeits

The transaction amount where the transaction type is 4 (forfeit).

To

The transaction aging code. A transaction aging code is the same as an income code Apply To code. In other words, if Concession applies to Rent, then the transaction aging code for Concession is Rent. For instance, if you create a credit invoice in the amount of $100 for Concession, you are actually creating a credit invoice of $100 for Rent.

Write-Offs

The transaction amount where the transaction type is 8 (write-off).

Balance

This number is calculated the running receivable balance.

Resident Total

Security on Hand

Sum of Security 1 on hand from the lease table.

Other Deposits on Hand

Sum of Security 2 on hand from the lease table.

Billings

The sum of the detail for billings.

Adjust.

The sum of the detail for adjustments.

Non-Rec. Adjust

The sum of detail for non-recurring adjustments.

Payments

The sum of detail for payments, excluding returned items.

Ret.

The sum of detail for returned items.

Refunds

The sum of detail for refunds.

Forfeits

The sum of detail for forfeits.

Write-Offs

The sum of detail for write-offs.

Balance

The running receivable balance at the Thru Date specified in the report date range.

Property Total

Column totals are listed per property.

Grand Total

Sum of Property Totals for all selected properties.

Footer

Varies by criteria selected. For example, may indicate report is run for Current Resident, Applicants, Subsidy Transactions only.

1. From the eSite menu, select Reports—Audit Reports—Resident History.
2. Click Select Properties. Select the properties for which you want to print the report and click Done.
3. Select the information you want to see on the report (refer to the Selection Criteria for this report).
4. Select a Report Format option: Acrobat Reader (default), Crystal Viewer, Excel.
5. Click Display. If you selected the printing option, Excel, you are prompted to open or save the report Excel file. Otherwise, the report opens in your preferred format.

 

Copyright © 2018 Infor. All rights reserved. www.infor.com.