## Appendix: Enhanced Real Estate Management Reports

This appendix provides an overview of JD Edwards EnterpriseOne Enhanced Real Estate Management reports and discusses how to:

- View summary information for all reports.

- View detailed information for selected reports.

### Understanding Enhanced Real Estate Management Reports

You can use integrity programs to verify and resolve problems with consistency across different tables. For example, billing control information, billing control integrity, and batch control integrity.

### Viewing Summary Information for all Reports

This table lists, describes, and provides the navigation for the reports in the JD Edwards EnterpriseOne Enhanced Real Estate Management system. The reports are sorted alphanumerically by report ID number:

Report ID and Report Name | Description | Navigation
R74U0220 Rent List New Tenancies | Use this report to review tenant and lease information for any new tenancies after the lease start date that is entered in the processing options. | Tenant & Lease Reporting (G74U1514), Rent List New Tenancies
R74U0224 Mixed Residential/Commercial Rents | Use this report to review the percentage split of rental income between residential and commercial for all properties elected for value-added tax (VAT). | Tenant & Lease Reporting (G74U1514), Mixed Residential/Commercial Rents
R74U0225 Mixed Residential/Commercial Expenses | Use this report to review the actual input VAT percentage recovered for user-defined period for all properties elected for VAT. | Tenant & Lease Reporting (G74U1514), Mixed Residential/Commercial Expenses
R74U0226 Non-Elected Property Report - Detail | Use this report to review income and expenditure transactions for all properties not elected for VAT. | Tenant & Lease Reporting (G74U1514), Non Elected Property Report - Detail
R74U0227 Non-Elected Property Report - Summary | Use this report to review total income and expenditure for all properties not elected for VAT. | Tenant & Lease Reporting (G74U1514), Non Elected Property Report - Summary
R74U0228 Payment/Accounting Profile Reconciliation - Detail | Use this report to compare total payment profile values with total accounting profile values for user-defined periods or dates. The purpose of the report is to warn users of any integrity differences between rent billed (income/expense) and rent accounted for (revenue/accruals). | Global Updates (G74U15311), Payment/Accounting Profile Rec - Detail
R74U0229 Payment/Accounting Profile Reconciliation – Summary | Use this report to compare total payment profile values with total accounting profile values, for user-defined periods or dates. The purpose of the report is to warn users of any integrity differences between rent billed (income/expense) and rent accounted for (revenue/accruals). | Global Updates (G74U15311), Payment/Accounting Profile Rec - Summary
R74U0230 Rent Review Settled/Not Settled Report | Use this report to review leases that require rent reviews. Leases requiring rent reviews need to be set up with appropriate log classes (15/LG) and critical dates. | Tenant & Lease Reporting (G74U1514), Rent Review Settled/Not Settled Report

### Viewing Detailed Information for Selected Reports

These reports in the JD Edwards EnterpriseOne Enhanced Real Estate Management system are described in more detail in this appendix:

- R74U0220 - Rent List New Tenancies

- R74U0224 - Mixed Residential/Commercial Rents

- R74U0225 - Mixed Residential/Commercial Expenses

- R74U0226 - Non Elected Property Report - Detail

- R74U0227 - Non Elected Property Report - Summary

- R74U0230 - Rent Review Settled/Not Settled Report

- R74U0228 - Payment/Accounting Profile Reconciliation - Detail

- R74U0229 - Payment/Accounting Profile Reconciliation Summary Report

These reports and the processing options for each are described in the following topics. The reports are listed alphanumerically by report ID number.

#### R74U0220 - Rent List New Tenancies

Use this report to list tenant and lease information for any new tenancies after the lease start date selected in the processing options.

The report sequences information by tenant and lease number.

#### Processing Options for Rent List New Tenancies (R74U0220)

Processing options enable you to specify the default processing for programs and reports.

Selection

1. Lease Start Date | Specify the date to use to select the leases to include on the report. The system selects all leases with a date that is on or after the date that you specify. If you leave this processing option blank, the system uses today's date.
2. Lease Status | Specify the lease status to use to select the leases to include on the report. If you leave this processing option blank, the system does not use the lease status as selection criteria.
3. Lease Manager | Specify the address book number of the lease manager to use to select the leases to include on the report. If you leave this processing option blank, the system does not use the lease manager as selection criteria.
4. Lease Type | Specify the lease type to use to select the leases to include on the report. If you leave this processing option blank, the system does not use the lease type as selection criteria.
5. Payable or Receivable | Specify whether to select payable leases or receivable leases. Values are: Blank: Payable leases. 1: Receivable leases.
6. Versions | Specify the version to use to select the leases to include on the report. Values are: Blank: Include only lease versions that are active on the date entered in the Version Active Date processing option. 1: Include all versions of the lease on the report.
7. Version Active Date | Specify the date to use to select the lease versions to include on the report, if you did not enter 1 in the Versions processing option. If you leave this processing option blank, the system uses today's date.

#### R74U0224 - Mixed Residential/Commercial Rents

You use this report to show the percentage split of rental income between residential and commercial for all properties elected for VAT. The system selects records to include from the Lease Billings Master table (F1511B). The report sequences by company, property, and invoice date. Residential and commercial rents are defined at the bill code level.

Note. If a company number is not specified in the corresponding processing option, then the system includes all companies; therefore, report totals may be meaningless if they include more than one base currency.

#### Processing Options for Mixed Residential/Commercial Rents (R74U0224)

Processing options enable you to specify the default processing for programs and reports.

Selection

1. Company | Specify the company number to use to select records to include on the report. If you leave this processing option blank, the system selects all companies.
2. Currency Code | Specify the currency code to use to print transactions on the report. If you leave this processing option blank, the system prints amounts in the currency that is assigned to each company. The report does not print totals if you include more than one company for more than one currency.
3. From Date | Specify the date to use as the beginning date to select the records to include on the report. If you leave this processing option blank, the system uses today's date.
4. Date To | Specify the date to use as the ending date to select the records to include on the report. If you leave this processing option blank, the system selects records with dates that are up to 12 months from the date entered in the From Date processing option.
5. Date Source | Specify which date to use to select the records based on the values in the From Date and Date To processing options. Values are: Blank: Invoice date. 1: General ledger date. 2: Service/tax date.

#### R74U0225 - Mixed Residential/Commercial Expenses

You use this report to show the actual Input VAT percentage recovered over a user-defined period for all properties elected for VAT. The system selects records to include from the Lease Billings Master table (F1511B). The report sequences by company, property, and general ledger account number. Residential and commercial rents are defined at the bill code level.

Note. If a company number is not specified in the corresponding processing option, then the system includes all companies; therefore, report totals may be meaningless if they include more than one base currency.

#### Processing Options for Mixed Residential/Commercial Expenses (R74U0225)

Processing options enable you to specify the default processing for programs and reports.

These processing options are identical to the processing options for Mixed Residential/Commercial Rents program (R74U0224) except where noted.

Selection

6. Type of Property | Specify whether to include records for properties that are exempt from VAT tax. Values are: Blank: Include all properties regardless of the tax status. 1: Include only properties that are subject to VAT taxes.

#### R74U0226 - Non Elected Property Report - Detail

Use this report to review income and expenditure transactions for all properties not elected for VAT. The report sequences information by company, property, and general ledger account number.

Processing options enable you to select company, date ranges, tax code for VAT non-election, account ranges for income and expenditure, ledger type, and currency.

Note. If a company number is not specified in the corresponding processing option, then the system includes all companies; therefore, report totals may be meaningless if they include more than one base currency.

The system selects property transactions from the Account Ledger table (F0911) and provides details by account for each property. Processing options enable you to specify whether to include tax information (F0018),

#### Processing Options for Non-Elected Property Report - Detail (R74U0226)

Processing options enable you to specify the default processing for programs and reports.

Selection

1. Company | Specify the company number to use to select records to include on the report. If you leave this processing option blank, the system selects all companies.
2. From Date | Specify the date to use as the beginning general ledger date to select the records to include on the report. If you leave this processing option blank, the system uses today's date.
3. To Date | Specify the date to use as the ending general ledger date to select the records to include on the report. If you leave this processing option blank, the system selects records with dates that are up to 12 months from the date entered in the From Date processing option.
4. Date Source | Specify which date to use to select the records based on the values in the From Date and Date To processing options. Values are: Blank: Invoice date. 1: General ledger date. 2: Service/tax date.
5. Elected | Specify whether to include records for properties that are subject to VAT tax. Values are: Blank: Include all properties regardless of the tax status. 1: Include only properties that are exempt from VAT taxes.

Accounting Range

1. Income Accounting Range From and 2. Income Accounting Range To | Specify the first account or the last account in the range of income accounts to include on the report. If you leave these processing options blank, the system returns an error that the accounting range is incomplete.
3. Expenditure Accounting Range From and 4. Expenditure Accounting Range To | Specify the first account or the last account in the range of expenditure accounts to include on the report. If you leave these processing options blank, the system returns an error that the accounting range is incomplete.
5. Ledger Type | Specify the ledger type to use to select the records to include in the report.
6. Currency Code | Specify the currency code for which you want transaction amounts printed. If you leave this processing option blank, the system prints transaction amounts in the currency assigned to the company. If transactions are included for companies with different currencies, the report does not print totals.
7. Signs | Specify whether to print the debit and credit signs for amounts on the report. Values are: Blank: Print the report without signs. 1: Print the report with signs for debits and credits. 2: Print the report without signs, but display a negative margin if the expenditure for the selected period is greater than the income.

Other

1. Document Type | Specify the document type to use to select transactions to include on the report. If you leave this processing option blank, the system includes transactions for all document types.
2. Posted Trans (posted transaction) | Specify whether to select only transactions that are posted on the report. Values are: Blank: Include only transactions that are posted (posted code is equal to P). 1: Include all transactions, regardless of whether they are posted.
3. Unit Accounting | Specify whether to print the subledger on the report. Values are: Blank: Do not print. 1: Print.
4. Date Sequence | Specify the general ledger date sequence in which to print transactions on the report. Values are: Blank: Print transactions in date descending order; the system prints the most recent transactions first. 1: Print the transactions in date ascending order; the system prints the oldest transactions first. 2: Print the transactions by unit number, and then by date descending order. 3: Print the transactions by unit number, and then by date ascending order.
5. Tax | Specify whether to print tax information on the report. Values are: Blank: Do not print. 1: Print.

#### R74U0227 - Non Elected Property Report - Summary

Use this report to review total income and expenditure for all properties not elected for VAT. The report sequences information by company and property.

Processing options enable you to select company, date ranges, tax code for VAT non-election, account ranges for income and expenditure, ledger type, and currency.

Note. If a company number is not specified in the corresponding processing option, then the system includes all companies; therefore, report totals may be meaningless if they include more than one base currency.

The system selects property transactions from the Account Ledger table (F0911) and provides details by account for each property. Processing options enable you to specify whether to include tax information (F0018) and whether to report integrity differences between the general ledger and tax tables.

#### Processing Options for Non-Elected Property Report - Summary (R74U0227)

Processing options enable you to specify the default processing for programs and reports.

These processing options are identical to processing options for Non-Elected Property Report - Detail (R74U0226) except where noted.

Selection

These processing options are identical to the Non-Elected Property Report - Detail program (R74U0226).

Accounting Range

These processing options are identical to the Non-Elected Property Report - Detail program (R74U0226).

Other

1. Tax | Specify whether to print tax information on the report. Values are: Blank: Do not print. 1: Print.
2. Integrity | Specify whether to print integrity information on the report. Values are: Blank: Do not print. 1: Print.

#### R74U0230 - Rent Review Settled/Not Settled Report

Use this report to review leases that require rent reviews based on the log class and critical dates that are set up for the lease. You can specify whether to sequence the information on the report by either lease or critical date.

#### Processing Options for Rent Review Settled/Not Settled (R74U0230)

Processing options enable you to specify the default processing for programs and reports.

Selection

1. Up To and Including Critical Date | Specify the date to use to select the leases on the report. The system includes leases with a review date that is prior to or on the date that you enter.
2. Sequence | Specify whether to sequence the information on the report by lease or critical date. Values are: Blank: Lease number. 1: Critical date.
3. Resolved / Unresolved | Specify whether to select all records or only those which are still unresolved. Values are: Blank: Unresolved 1: Resolved and unresolved
4. Attachments | Specify whether to print attachment information for the log lines selected. Values are: Blank: Do not print. 1: Print.
5. Rent Review Property Log Class | Specify the log class that is set up for rent review for the system to use to select lease records.

#### R74U0228 - Payment/Accounting Profile Reconciliation - Detail

Use this report to review and compare the information stored in the Payment Profile table (F74U0205) and the Accounting Billing Profile table (F74U0212). Two reports are provided to show any reconciliation differences between these tables.

This report compares total payment profile values with total accounting profile values, for user-defined periods or dates. The purpose of the report is to warn users of any integrity differences between rent billed (income/expense) and rent accounted for (revenue/accruals).

The system selects transactions from the Account Ledger table (F0911) and subtotals them by subledger (unit), bill code, lease, and company to show any integrity differences at these levels.

The system sequences the information on the report by company, property, lease, bill code, subledger (unit), account number, and general ledger date.

Processing options enable you to select company, date ranges, income account ranges, income document types, revenue account ranges, revenue document types, ledger type, and currency.

Note. If a company is not selected, then all companies are selected; therefore, report totals may be meaningless if they include more than one base currency.

#### Processing Options for Payment/Accounting Profile Reconciliation - Detail (R74U0228)

Processing options enable you to specify the default processing for programs and reports.

Selection

1. Company | Specify the company number to use to select records to include on the report. If you leave this processing option blank, the system selects all companies.
2. From Date | Specify the date to use as the beginning bill date to select the records to include on the report. If you leave this processing option blank, the system uses today's date.
3. To Date | Specify the date to use as the ending bill date to select the records to include on the report. If you leave this processing option blank, the system selects records with dates that are up to 12 months from the date entered in the From Date processing option.

Accounting Range

1. Income Accounting Range From and 2. Income Accounting Range To | Specify the first account or the last account in the range of income accounts to include on the report. If you leave these processing options blank, the system returns an error that the accounting range is incomplete.
3. Restrict Income Document Type To | Specify the document type to use to select income account transactions. If you leave this processing option blank, the system selects all income accounts for the specified range, regardless of the document type.
4. Revenue Accounting Range From and 5. Revenue Accounting Range To | Specify the first account or the last account in the range of revenue accounts to include on the report. If you leave these processing options blank, the system returns an error that the accounting range is incomplete.
6. Restrict Income Document Type To | Specify the document type to use to select revenue account transactions. If you leave this processing option blank, the system selects all revenue accounts for the specified range, regardless of the document type.

Other

1. Ledger Type | Specify the ledger type to use to select the records to include on the report.
2. Currency Code | Specify the currency code for which you want transaction amounts printed. If you leave this processing option blank, the system prints transaction amounts in the currency assigned to the company. If transactions are included for companies with different currencies, the report does not print totals.
3. Signs | Specify whether to print the debit and credit signs for amounts on the report. Values are: Blank: Print the report without signs. 1: Print the report with signs for debits and credits. 2: Print the report without signs, but display a negative margin if the expenditure for the selected period is greater than the income.
4. Subledger/Unit | Specify whether to print the subledger on the report. Values are: Blank: Do not print. 1: Print.
5. Bill Code | Specify whether to print the bill code associated with the account on the report. Values are: Blank: Print. 1: Do not print.

#### R74U0229 - Payment/Accounting Profile Reconciliation Summary Report

Use this report to review and compare the information stored in the Payment Profile table (F74U0205) and the Accounting Billing Profile table (F74U0212). Two reports are provided to show any reconciliation differences between these tables.

This report compares total payment profile values with total accounting profile values for user-defined periods or dates. The purpose of the report is to warn users of any integrity differences between rent billed (income/expense) and rent accounted for (revenue/accruals).

The system selects transactions from the Account Ledger table (F0911) and subtotals them by subledger (unit), bill code, lease, and company to show any integrity differences at these levels.

The system sequences the information on the report by company, property, lease, bill code, subledger (unit), account number, and general ledger date.

Processing options enable you to select company, date ranges, income account ranges, income document types, revenue account ranges, revenue document types, ledger type, and currency.

Note. If a company is not selected, then all companies are selected; therefore, report totals may be meaningless if they include more than one base currency.

#### Processing Options for Payment/Accounting Profile Reconciliation - Summary (R74U0229)

Processing options enable you to specify the default processing for programs and reports.

These processing options are identical to processing options for Payment/Accounting Profile Reconciliation - Detail program (R74U0228), except where noted.

Selection

These processing options are identical to Payment/Accounting Profile Reconciliation - Detail program (R74U0228).

Accounting Range

These processing options are identical to Payment/Accounting Profile Reconciliation - Detail program (R74U0228).

Other

6. Posted Code | Specify whether to select only transactions that are posted on the report. Values are: Blank: Include only transactions that are posted (posted code is equal to P). 1: Include all transactions, regardless of whether they are posted.