This chapter contains the following topics:
Section 1.1, "JD Edwards EnterpriseOne Advanced Real Estate Forecasting Overview"
Section 1.2, "JD Edwards EnterpriseOne Advanced Real Estate Forecasting Integrations"
Section 1.3, "JD Edwards EnterpriseOne Advanced Real Estate Forecasting Implementation"
Use the JD Edwards EnterpriseOne Advanced Real Estate Forecasting system with the JD Edwards EnterpriseOne Real Estate Management system 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.
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 My Oracle Support website at https://support.oracle.com/
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 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).
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.
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 simultaneously.
See JD Edwards EnterpriseOne Tools Software Updates Guide
This table lists the implementation steps for JD Edwards EnterpriseOne Advanced Real Estate Forecasting:
Set up companies, fiscal date patterns, and business units.
See "Setting Up Organizations" in the JD Edwards EnterpriseOne Applications Financial Management Fundamentals Implementation Guide
Set up accounts and the chart of accounts.
See "Creating the Chart of Accounts" in the JD Edwards EnterpriseOne Applications Financial Management Fundamentals Implementation Guide
Set up the general ledger constants.
See "Setting Up Constants for General Accounting" in the JD Edwards EnterpriseOne Applications General Accounting Implementation Guide
Set up multicurrency processing, including currency codes and exchange rates.
See "Setting Up the General Accounting System" in the JD Edwards EnterpriseOne Applications General Accounting Implementation Guide
Set up ledger type rules.
See "Setting Up Ledger Types for General Accounting" in the JD Edwards EnterpriseOne Applications General Accounting Implementation Guide
Set up address book records.
See "Entering Address Book Records" in the JD Edwards EnterpriseOne Applications Address Book Implementation Guide
This table lists the core implementation steps for JD Edwards EnterpriseOne Advanced Real Estate Forecasting:
Upload the unit master information from JD Edwards EnterpriseOne Real Estate Management.
See Uploading Unit Master Information from JD Edwards EnterpriseOne Real Estate Management.
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.
Set up assumption header information and assumption detail information.
Set up unit master information.
Set up account status records.
Set up account association information.