## Getting Started with JD Edwards EnterpriseOne Advanced Real Estate Forecasting

This chapter discusses:

- JD Edwards EnterpriseOne Advanced Real Estate Forecasting overview.

- JD Edwards EnterpriseOne Advanced Real Estate Forecasting integrations.

- JD Edwards EnterpriseOne Advanced Real Estate Forecasting implementation.

### JD Edwards EnterpriseOne Advanced Real Estate Forecasting Overview

Use JD Edwards EnterpriseOne Advanced Real Estate Forecasting in conjunction with JD Edwards EnterpriseOne Real Estate Management to forecast budget amounts for specific accounts. JD Edwards EnterpriseOne Advanced Real Estate Forecasting is fully integrated with these features of JD Edwards EnterpriseOne Real Estate Management:

- Unit master

- Recurring billing

- Sales overage

- Expense participation

- Management fees

JD Edwards EnterpriseOne Advanced Real Estate Forecasting generates forecasted amounts for:

- Revenue (rent and nonrent).

- Expense participation.

- Sales overage.

- Management fees.

- Capital expenditures, expenses, and any other specified account.

With JD Edwards EnterpriseOne Advanced Real Estate Forecasting, you can generate a forecast for up to 15 years in the future. When units are leased, the system retrieves revenue amounts directly from JD Edwards EnterpriseOne Real Estate Management. When units are vacant, the system uses the assumption rules that you assign to the unit in JD Edwards EnterpriseOne Advanced Real Estate Forecasting to calculate revenue amounts. If you set up the dates to generate a forecast in JD Edwards EnterpriseOne Real Estate Management, the system uses that information as the basis for calculating the budget amounts. Otherwise, the system uses the information in JD Edwards EnterpriseOne Advanced Real Estate Forecasting.

To forecast revenue amounts, the system multiplies the area of the unit by the market rate that you specify, which is an amount per square foot, and then applies an annual growth pattern that you specify. The growth pattern can be an annual amount, percentage, or amount per square foot. To forecast capital expenditure amounts or amounts associated with other accounts, the system applies a growth pattern to beginning balances that you retrieve from the Account Balances table (F0902).

You set up the components and rules that the JD Edwards EnterpriseOne Advanced Real Estate Forecasting system uses to generate a budget by property or building and revision number. After you set up the information for one revision number, you can easily copy the setup information to another revision number, and then revise that information as necessary. Using a revision number enables you to generate multiple budgets for the same building and units that you can use to perform what-if analyses. The system provides a building constants program, which enables you to specify default rules, so that you need only set up unit master information when the rules differ.

After you generate the budget amounts for the accounts specified, you can revise them and lock the accounts to prevent future updates. To determine how the system calculated specific budget amounts, you can run an audit report. The audit report prints the source of the information that the system used or the formulas for each calculation. When you are satisfied with the budget results, you can copy them to the F0902 table to be incorporated with budgets from other systems.

### JD Edwards EnterpriseOne Advanced Real Estate Forecasting Integrations

The JD Edwards EnterpriseOne Advanced Real Estate Forecasting integrates with these JD Edwards EnterpriseOne systems from Oracle:

- JD Edwards EnterpriseOne Real Estate Management

- JD Edwards EnterpriseOne General Accounting

The JD Edwards EnterpriseOne Advanced Real Estate Forecasting system works with other JD Edwards EnterpriseOne systems to ensure that all information is fully integrated into the general ledger. We discuss integration considerations in the implementation chapters in this implementation guide. Supplemental information about third-party application integrations is located on the Oracle | PeopleSoft Customer Connection website.

JD Edwards EnterpriseOne Real Estate Management

JD Edwards EnterpriseOne Advanced Real Estate Forecasting uses information that is set up in JD Edwards EnterpriseOne Real Estate Management for budget processing including, leases, expense participation information, sales overage information, recurring billing and management fees.

JD Edwards EnterpriseOne General Accounting

JD Edwards EnterpriseOne Advanced Real Estate Forecasting uses the account information that is set up in JD Edwards EnterpriseOne General Accounting to define the accounts to use for budgets. The system generates budget records in the Account Balances table (F0902).

### JD Edwards EnterpriseOne Advanced Real Estate Forecasting Implementation

This section provides an overview of the steps that are required to implement JD Edwards EnterpriseOne Advanced Real Estate Forecasting.

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 Advanced Real Estate Forecasting, 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, and 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 implementation steps for JD Edwards EnterpriseOne Advanced Real Estate Forecasting:

Step | Reference
1. Set up companies, fiscal date patterns, and business units. | See Setting Up Organizations.
2. Set up accounts and the chart of accounts. | See Creating the Chart of Accounts.
3. Set up the general ledger constants. | See Setting Up Constants for General Accounting.
4. Set up multicurrency processing, including currency codes and exchange rates. | See Setting Up the General Accounting System.
5. Set up ledger type rules. | See Setting Up Ledger Types for General Accounting.
6. Set up address book records. | See Entering Address Book Records.

#### JD Edwards EnterpriseOne Advanced Real Estate Forecasting Implementation Steps

This table lists the core implementation steps for JD Edwards EnterpriseOne Advanced Real Estate Forecasting:

Step | Reference
1. Upload the unit master information from JD Edwards EnterpriseOne Real Estate Management. | See Uploading Unit Master Information from JD Edwards EnterpriseOne Real Estate Management.
2. Set up Advanced Real Estate Forecasting (AREF) user-defined codes, AREF growth patterns, AREF recurring bill code rules, AREF sales overage rules (optional), AREF expense participation rules (optional), AREF security (optional), AREF building constants, and AREF building constant models. | See Setting Up JD Edwards EnterpriseOne Advanced Real Estate Forecasting.
3. Set up assumption header information and assumption detail information. | See Setting Up Unit Assumptions.
4. Set up unit master information. | See Setting Up Unit Master Information.
5. Set up account status records. | See Setting Up Account Status Information.
6. Set up account association information. | See Setting Up Account Association Information.