## Getting Started with JD Edwards EnterpriseOne Enhanced Real Estate Management for the United Kingdom

This chapter discusses:

- JD Edwards EnterpriseOne Enhanced Real Estate Management overview.

- JD Edwards EnterpriseOne Enhanced Real Estate Management integrations.

- JD Edwards EnterpriseOne Enhanced Real Estate Management implementation.

### JD Edwards EnterpriseOne Enhanced Real Estate Management Overview

The JD Edwards EnterpriseOne Enhanced Real Estate Management system from Oracle, a supplementary system to the JD Edwards EnterpriseOne Real Estate Management system, provides extra functionality to meet the requirements of the United Kingdom real estate market. The information in this guide describes only the enhanced functionality.

Features of the JD Edwards EnterpriseOne Enhanced Real Estate Management system are described in the following topics.

Additional Lease Information

The Lease Master Maintenance program (P74U1501) was enhanced to provide additional information for bank interest rates, alternative unit of measure conversion, and payment/accounting profile years. The P74U1501 also has functionality to automatically credit or credit/re-invoice tenants who have been billed in advance and who move out before the end of the billing period. The JD Edwards EnterpriseOne Enhanced Real Estate Management Lease Master Maintenance program replaces the standard program.

User-Defined Bill Patterns

JD Edwards EnterpriseOne Enhanced Real Estate Management uses bill patterns instead of billing frequencies that enable users to determine when and how often an account is billed. Bill patterns are used in recurring billing and expense participation processing.

Property VAT Accounting

JD Edwards EnterpriseOne Enhanced Real Estate Management allows you to set up tax rate areas and tax explanation codes for value-added tax (VAT) processing by property and unit. Manual billing, recurring billing, and expense participation use these as defaults instead of using the tax defaults from the customer or supplier master record.

Enhanced Manual Billing

Manual billing was enhanced to process currency, unit accounting, and property VAT accounting.

Recurring Billing with Payment and Accounting Profiles

The recurring billing process was enhanced for currency, unit accounting, and VAT accounting and to use bill patterns instead of billing frequencies. In addition, each recurring billing record generates both payment profiles and accounting profiles, which are used for billing generation and accounting accruals and deferrals, respectively.

Expense Participation by Bill Pattern

Expense participation was enhanced to use bill patterns instead of billing frequencies and to use the base currency of the building to determine its currency. In addition, enhanced expense participation now interacts directly with enhanced recurring billing for estimated costs or directly into a payment profile for actual costs. Although the enhanced expense participation replaces standard expense participation, the system continues to use a number of the standard expense participation programs.

Fees and Interest with Bank Rates

You can calculate interest using bank rates and manage changes in bank rates over the interest calculation period. The generation process now creates records in the payment profile instead of the Lease Billings Master table (F1511B), which enables fee and interest charges to be combined on the same invoice as the recurring billing charges. Enhanced fees and interest replace standard fees and interest.

Global Generation

Global generation is the process that converts payment profile records into records in the Lease Billings Master table (F1511B). The global generation process in JD Edwards EnterpriseOne Enhanced Real Estate Management replaces the standard recurring billing generation program. In addition, it processes fees and interest, and expense participation billings into the Lease Billings Master table (F1511B).

Accounting Generation

Accounting generation is the process that converts the accounting profile from the JD Edwards EnterpriseOne Enhanced Real Estate Management system into records in the Account Ledger table (F0911).

VAT Reporting

JD Edwards EnterpriseOne Enhanced Real Estate Management provides a number of additional reports to meet customs and excise requirements, including mixed rents, mixed expenses, and non-elected properties reports.

Global Updates

JD Edwards EnterpriseOne Enhanced Real Estate Management provides global updates for the enhancements, including global updates for rents, bank rates, payment profiles, and accounting profiles.

Integrities

JD Edwards EnterpriseOne Enhanced Real Estate Management provides two integrity reports to alert users of differences between the payment and accounting profiles.

Unit Accounting

JD Edwards EnterpriseOne Enhanced Real Estate Management allows users to automatically update unit balances into the general ledger as subledger entries. By providing this information in the general ledger, users can report on property transactions at both the property and unit levels.

### JD Edwards EnterpriseOne Enhanced Real Estate Management Integrations

The JD Edwards EnterpriseOne Enhanced Real Estate Management system integrates with these JD Edwards EnterpriseOne systems:

- JD Edwards EnterpriseOne Real Estate Management.

- JD Edwards EnterpriseOne Accounts Receivable.

- JD Edwards EnterpriseOne Accounts Payable.

- JD Edwards EnterpriseOne General Accounting.

JD Edwards EnterpriseOne Real Estate Management

JD Edwards EnterpriseOne Enhanced Real Estate Management retrieves information from and updates information to the tables in the JD Edwards EnterpriseOne Real Estate Management system. The enhancements described in this implementation guide provide additional functionality to meet requirements for the United Kingdom. Specifically, the JD Edwards EnterpriseOne Enhanced Real Estate Management system uses the JD Edwards EnterpriseOne Real Estate Management system exclusively for receipt processing, sales overage, sales analysis, and revenue fees. The JD Edwards EnterpriseOne Enhanced Real Estate Management system does not support escalations, FASB 13, or projected rent processing.

JD Edwards EnterpriseOne Accounts Receivable

JD Edwards EnterpriseOne Enhanced Real Estate Management generates invoice and receipt records for tenants in the JD Edwards EnterpriseOne Accounts Receivable system from Oracle. This system allows integration for credit and collection management, reporting, and accounting processes.

JD Edwards EnterpriseOne Accounts Payable

JD Edwards EnterpriseOne Enhanced Real Estate Management generates voucher and payment records for landlords in the JD Edwards EnterpriseOne Accounts Payable system from Oracle. This system allows integration for reporting and accounting processes.

JD Edwards EnterpriseOne General Accounting

JD Edwards EnterpriseOne Enhanced Real Estate Management generates journal entries from the accounting profile records. This functionality enables billing amounts that fluctuate by period to be recorded as fixed amounts.

### JD Edwards EnterpriseOne Enhanced Real Estate Management Implementation

This section provides an overview of the global and core steps that are required to implement the JD Edwards EnterpriseOne Enhanced Real Estate Management system.

In the planning phase of the implementation, take advantage of all JD Edwards EnterpriseOne sources of information, including the installation guides and troubleshooting information. A complete list of these resources appears in the preface in About This Documentation with information about where to find the most current version of each.

When determining which electronic software updates (ESUs) to install for JD Edwards EnterpriseOne Enhanced Real Estate Management, use the EnterpriseOne and World Change Assistant. EnterpriseOne and World Change Assistant, a Java-based tool, reduces the time required to search and download ESUs by 75 percent or more. It also enables you to install multiple ESUs at one time.

See JD Edwards EnterpriseOne Tools 8.98 Software Update Guide.

#### Global Implementation Steps

This table lists the global implementation steps for the JD Edwards EnterpriseOne Enhanced Real Estate Management system:

Step | Reference
1. Set up fiscal date patterns. | See Setting Up Organizations.
2. Set up accounts. | See Setting Up Organizations.
3. Set up General Accounting constants. | See Setting Up Constants for General Accounting.
4. Set up multicurrency processing, including currency codes and exchange rates. | See Setting Up General Accounting for Multicurrency Processing.
5. (Optional) Set up ledger type rules. | See Setting Up Ledger Type Rules for General Accounting.
6. Enter address book records. | See Entering Address Book Records.

#### Core Implementation Steps

This table lists the core implementation steps for the JD Edwards EnterpriseOne Enhanced Real Estate Management system:

Step | Reference
1. Set up additional company constants. | See Setting Up Additional Company Constants.
2. Set up user-defined codes. | See Setting Up User-Defined Codes.
3. Set up automatic accounting instructions. | See Setting Up Automatic Accounting Instructions.
4. Set up bill codes and adjustment reasons. | See Setting Up Bill Codes and Adjustment Reasons.
5. Set up billing patterns. | See Setting Up Billing Patterns.
6. Set up default payment profile statuses. | See Setting Up Default Payment Profile Statuses.
7. Set up bank base rates. | See Setting Up Bank Base Rates.