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.

National Tenant *

Select the National Tenant to include from the drop-down list.

Source of List: Setup—Global—National Tenants

Sort by Property

Use this option to determine if tenants should be listed on one report or broken out by property when you have tenants residing in multiple properties linked to the same National Tenant ID.

Options

From Date / Thru Date*

Enter the first date and last date to include in the report date range or select a date using the Calendar Button.

From Building / To Building

Enter the first building and last building to include in the report range or select a building from the lookup .

From Suite / To Suite

Enter the first suite and last suite to include in the report range or select a suite from the lookup .

Activity to Include

Use the drop-down to define what activity to include.
Options

Sort By

Select an option from the drop-down to use to sort the report. Options include: Transaction Date, Date of Record, Invoice Number, Entry Order, Due Date.

Summarize Payments by Check

Checked—report includes a check payment summary.
Unchecked—default, report does not include a check payment summary.

Summarize Billings by Invoice

Checked—report includes an invoice payment summary.
Unchecked—default, report does not include an invoice payment summary.

Separate Page per Tenant

Checked—report prints a separate page per tenant.
Unchecked—default, report does not print a separate page per tenant.

Include Current Tenants

Checked—default, tenants with a Current status are included.
Unchecked—tenants with a Current status are not included.

Include Previous Tenants

Checked—default, tenants with a Previous status are included.
Unchecked—tenants with a Previous status are not included.

Note

This topic provides report details for commercial properties only; that is, properties with the property type set to 6-Standard Commercial.

Sort By Property = Checked

Natl Tenant

The National Tenant ID.

Bldg – Suite

Identifies the building and suite number.

Res ID

The tenant ID.

Tenant Name

The tenant's business name. For instance, Joe's Shoes.

Status

Identifies the national tenant's lease status as: Current, Previous or New. This is based on the Report Select Date entered on the Select Properties Grid.

Beginning Balance

The National Tenant’s beginning balance listed in dollars and cents.

Trans Date

The date the transaction was entered into the system. Typically, the Log In 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. For a transaction to post, this accounting period must be active or the Log In date must fall within the grace period as defined by your Global Policy settings. For most transactions the Date of Record will equal the Transaction Date.

Due Date

The use of this date varies according to what it is related to. For a charge, this is the date the charge is due. For a payment, this is the date the charge is due, that the payment was applied to. This date does not apply if this is a prepayment.

SC

The source code used to identify the process that created the transaction.

Desc.

Transaction description.

Invoice

Identifies the invoice number of the charge. For a payment, this is the invoice number of the charge paid. For a prepayment the invoice number would be zero.

Code

Transaction income code.

Billings

Transaction amount where the Transaction Detail type is Recurring Charge or One Time Charge and the Receivable flag is set to Yes.

Adjust.

Transaction amount where the Transaction Detail type is Adjustment and the Transaction Detail Receivable flag is Yes.

Non-Rec. Adjust.

Transaction amount where the Transaction Detail type is Recurring Charge, Adjustment or One Time Charge and the Transaction Detail Receivable flag is set to No.

Payments

Transaction amount where Transaction Detail type is Payment.

Note

This amount may be printed with a reversed sign depending on the Global policy, Display payments as credits.

Ret/Type

Return flag. Indicates this payment was returned by the bank for insufficient funds.

Reference

Reference number or check number associated with the transaction.

Refunds

Transaction amount where the Transaction Detail type is Refund.

Forfeits To

Transaction amount where the Transaction Detail type is Forfeit.

Write-Offs

Transaction amount where the Detail type is Write-Off.

Balance

Running receivables balance.

National Tenant Totals

Sum of detail listed per tenant for the current property selection.

Sort By Property = Unchecked

Property

The property ID.

Bldg – Suite

Identifies the building and suite number.

Res ID

The tenant ID.

Tenant Name

The tenant's business name. For instance, Joe's Shoes.

Status

Identifies the national tenant's lease status as: Current, Previous or New. This is based on the Report Select Date entered on the Select Properties Grid.

Beginning Balance

The National Tenant’s beginning balance listed in dollars and cents.

Trans Date

The date the transaction was entered into the system. Typically, the Log In 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. For a transaction to post, this accounting period must be active or the Log In date must fall within the grace period as defined by your Global Policy settings. For most transactions the Date of Record will equal the Transaction Date.

Due Date

The use of this date varies according to what it is related to. For a charge, this is the date the charge is due. For a payment, this the date the charge is due, that the payment was applied to. This date does not apply if this is a prepayment.

SC

The source code used to identify the process that created the transaction.

Desc.

Transaction description.

Invoice

Identifies the invoice number of the charge. For a payment, this is the invoice number of the charge paid. For a prepayment the invoice number would be zero.

Code

Transaction income code.

Billings

Transaction amount where the Transaction Detail type is Recurring Charge, One Time Charge and the Receivable flag is set to Yes.

Adjust.

Transaction amount where the Transaction Detail type is Adjustment and the Transaction Detail Receivable flag is Yes.

Non-Rec. Adjust.

Transaction amount where the Transaction Detail type is Recurring Charge, Adjustment or One Time Charge and the Transaction Detail Receivable flag is set to No.

Payments

Transaction amount where Transaction Detail type is Payment.

Note

This amount may be printed with a reversed sign depending on the Global policy, Display payments as credits.

Ret/Type

Return flag. Indicates this payment was returned by the bank for insufficient funds.

Reference

Reference number or check number associated with the transaction.

Refunds

Transaction amount where the Transaction Detail type is Refund.

Forfeits To

Transaction amount where the Transaction Detail type is Forfeit.

Write-Offs

Transaction amount where the Detail type is Write-Off.

Balance

Running receivables balance.

National Tenant Totals

Sum of detail listed per tenant for the current property selection.

1. From the eSite menu, select Reports—Corporate Clients Reports—ResidentHistory.
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.