This appendix contains the following topics:
Section B.1, "Understanding Enhanced Real Estate Management Reports"
Section B.3, "Viewing Detailed Information for Selected 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.
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 |
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.
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 enable you to specify the default processing for programs and reports.
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.
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.
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.
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.
Specify whether to select payable leases or receivable leases. Values are:
Blank: Payable leases.
1: Receivable leases.
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.
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.
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 enable you to specify the default processing for programs and reports.
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.
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.
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.
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.
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.
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 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.
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.
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 enable you to specify the default processing for programs and reports.
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.
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.
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.
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.
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.
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.
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.
Specify the ledger type to use to select the records to include in the report.
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.
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.
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.
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.
Specify whether to print the subledger on the report. Values are:
Blank: Do not print.
1: Print.
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.
Specify whether to print tax information on the report. Values are:
Blank: Do not print.
1: Print.
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 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.
These processing options are identical to the Non-Elected Property Report - Detail program (R74U0226).
These processing options are identical to the Non-Elected Property Report - Detail program (R74U0226).
Specify whether to print tax information on the report. Values are:
Blank: Do not print.
1: Print.
Specify whether to print integrity information on the report. Values are:
Blank: Do not print.
1: Print.
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 enable you to specify the default processing for programs and reports.
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.
Specify whether to sequence the information on the report by lease or critical date. Values are:
Blank: Lease number.
1: Critical date.
Specify whether to select all records or only those which are still unresolved. Values are:
Blank: Unresolved
1: Resolved and unresolved
Specify whether to print attachment information for the log lines selected. Values are:
Blank: Do not print.
1: Print.
Specify the log class that is set up for rent review for the system to use to select lease records.
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 enable you to specify the default processing for programs and reports.
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.
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.
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.
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.
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.
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.
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.
Specify the ledger type to use to select the records to include on the report.
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.
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.
Specify whether to print the subledger on the report. Values are:
Blank: Do not print.
1: Print.
Specify whether to print the bill code associated with the account on the report. Values are:
Blank: Print.
1: Do not print.
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 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.
These processing options are identical to Payment/Accounting Profile Reconciliation - Detail program (R74U0228).
These processing options are identical to Payment/Accounting Profile Reconciliation - Detail program (R74U0228).
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.