This chapter contains the following topics:
Section 1.1, "JD Edwards EnterpriseOne Enhanced Real Estate Management Overview"
Section 1.2, "JD Edwards EnterpriseOne Enhanced Real Estate Management Integrations"
Section 1.3, "JD Edwards EnterpriseOne Enhanced Real Estate Management Implementation"
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 real estate market in the United Kingdom and in China. 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.
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.
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.
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.
Manual billing was enhanced to process currency, unit accounting, and property VAT accounting.
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 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.
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 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 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).
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.
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.
JD Edwards EnterpriseOne Enhanced Real Estate Management provides two integrity reports to alert users of differences between the payment and accounting profiles.
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.
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 Enhanced Real Estate Management retrieves information from and updates information to the tables in the JD Edwards EnterpriseOne Real Estate Management system. The features described in this implementation guide provide additional functionality to meet requirements for the United Kingdom and China. 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 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 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.
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.
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 Software Updates Guide
This table lists the global implementation steps for the JD Edwards EnterpriseOne Enhanced Real Estate Management system:
Set up fiscal date patterns.
Set up accounts.
Set up General Accounting constants.
Set up multicurrency processing, including currency codes and exchange rates.
(Optional) Set up ledger type rules.
Enter address book records.
This table lists the core implementation steps for the JD Edwards EnterpriseOne Enhanced Real Estate Management system:
Set up additional company constants.
Set up user-defined codes.
Set up automatic accounting instructions.
Set up bill codes and adjustment reasons.
Set up billing patterns.
Set up default payment profile statuses.
Set up bank base rates.