Go to main content
1/17
Contents
List of Figures
Title and Copyright Information
Preface
Audience
JD Edwards EnterpriseOne Products
JD Edwards EnterpriseOne Application Fundamentals
Documentation Accessibility
Related Documents
Conventions
1
Introduction to JD Edwards EnterpriseOne Advanced Real Estate Forecasting
1.1
JD Edwards EnterpriseOne Advanced Real Estate Forecasting Overview
1.2
JD Edwards EnterpriseOne Advanced Real Estate Forecasting Integrations
1.2.1
JD Edwards EnterpriseOne Real Estate Management
1.2.2
JD Edwards EnterpriseOne General Accounting
1.3
JD Edwards EnterpriseOne Advanced Real Estate Forecasting Implementation
1.3.1
Global Implementation Steps
1.3.2
JD Edwards EnterpriseOne Advanced Real Estate Forecasting Implementation Steps
2
Uploading Unit Master Information from JD Edwards EnterpriseOne Real Estate Management
2.1
Understanding Unit Setup
2.2
Uploading Unit Master Information
2.2.1
Understanding the Upload Process
2.2.2
Running the Load AREF Unit Master
2.2.3
Setting Processing Options for the Load AREF Unit Master (R15L1012)
2.2.3.1
Defaults
2.2.3.2
Process
2.2.3.3
Print
3
Setting Up JD Edwards EnterpriseOne Advanced Real Estate Forecasting
3.1
Understanding the Setup Requirements for JD Edwards EnterpriseOne Advanced Real Estate Forecasting
3.2
Prerequisite
3.3
Setting Up AREF User-Defined Codes
3.4
Setting Up AREF Growth Patterns
3.4.1
Understanding Growth Pattern Information
3.4.2
Forms Used to Set Up AREF Growth Patterns
3.4.3
Setting Processing Options for the AREF Growth Patterns Program (P15L105)
3.4.3.1
Defaults
3.4.4
Setting Up Growth Patterns
3.5
Setting Up AREF Recurring Bill Code Rules
3.5.1
Understanding Recurring Bill Code Rules
3.5.1.1
Example of Budget Calculation for Nonrent Bill Codes
3.5.2
Forms Used to Set Up Recurring Bill Code Rules
3.5.3
Setting Processing Options for the AREF Recurring Bill Code Rules Program (P15L106)
3.5.3.1
Defaults
3.5.3.2
Versions
3.5.4
Setting Up Recurring Bill Code Rules
3.6
Setting Up AREF Sales Overage Rules (optional)
3.6.1
Understanding Sales Overage Processing
3.6.2
Understanding Sales Overage Rules
3.6.3
Understanding Sales Overage Computation Methods
3.6.3.1
Setup Information - Single Breakpoint and Multiple Breakpoints
3.6.3.2
Computation Method 1 (Each Period) - Single Breakpoint
3.6.3.3
Computation Method 1 (Each Period) - Multiple Breakpoints
3.6.3.4
Computation Method 2 (Cumulative) - Single Breakpoint
3.6.3.5
Computation Method 2 (Cumulative) - Multiple Breakpoints
3.6.3.6
Computation Method 3 (Cumulative Pro-Rata) - Single Breakpoint
3.6.3.7
Computation Method 3 (Cumulative Pro-Rata) - Multiple Breakpoints
3.6.3.8
Computation Method 4 (Modified Cumulative) - Single Breakpoint
3.6.3.9
Computation Method 4 (Modified Cumulative) - Multiple Breakpoints
3.6.4
Understanding the Natural Breakpoint Calculation
3.6.4.1
Setup Information
3.6.4.2
Calculation for Natural Breakpoint
3.6.5
Forms Used to Set Up Sales Overage Rules
3.6.6
Setting Processing Options for the AREF Sales Overage Rules Program (P15L103)
3.6.6.1
Defaults
3.6.6.2
Versions
3.6.7
Setting Up Sales Overage Rules
3.7
Setting Up AREF Expense Participation Rules (optional)
3.7.1
Understanding Expense Participation Rules
3.7.1.1
Expense Participation Rule Types
3.7.1.2
Tenant's Pro-Rata Share
3.7.1.3
Exposure Amount per Square Foot and Expense Participation Class
3.7.2
Prerequisites
3.7.3
Forms Used to Set Up Expense Participation Rules
3.7.4
Setting Processing Options for the AREF E.P. Rules Program (P15L104)
3.7.4.1
Defaults
3.7.4.2
Versions
3.7.5
Setting Up Expense Participation Rules
3.8
Setting Up AREF Security (optional)
3.8.1
Understanding AREF Security
3.8.2
Forms Used to Set Up AREF Security
3.8.3
Setting Processing Options for the AREF Permissions List Program (P15L200)
3.8.3.1
Defaults
3.8.3.2
Versions
3.8.4
Setting Up Permission Lists
3.8.5
Setting Processing Options for the AREF Security Setup Program (P15L202)
3.8.5.1
Defaults
3.8.5.2
Versions
3.8.6
Adding Permission Lists by Building and Revision Number
3.8.7
Adding Permission Lists to Multiple Buildings
4
Setting Up Unit Assumptions
4.1
Understanding Unit Assumption Information
4.2
Prerequisites
4.3
Setting Up Assumption Header Information
4.3.1
Understanding Assumption Header Information
4.3.2
Forms Used to Set Up Assumption Header Information
4.3.3
Setting Processing Options for AREF Unit Assumptions (P15L102)
4.3.3.1
Defaults
4.3.3.2
Process
4.3.3.3
Versions
4.3.4
Setting Up Unit Assumption Header Information
4.4
Setting Up Assumption Detail Information
4.4.1
Understanding Assumption Detail Information
4.4.2
Understanding Calculation Methods for Detail Assumptions
4.4.3
Understanding Calculation Method Examples
4.4.3.1
Setup Information for Calculation Examples
4.4.3.2
AREF Unit Maintenance (P15L101)
4.4.3.3
AREF Unit Assumptions (P15L102)
4.4.3.4
Recurring Billing Revisions (P1502)
4.4.3.5
AREF Growth Patterns (P15L105)
4.4.3.6
AREF Budget Calculation (R15L1091)
4.4.3.7
Abbreviations Used in Formulas
4.4.3.8
Calculation Method 1 for Years Leased (Forecasted Amount for Years 1 through 6)
4.4.3.9
Calculation Method 1 for Years Vacant (Forecasted Amount for Years 7 through 10)=
4.4.3.10
Calculation Method 2 for Years Leased (Forecasted Amount for Years 1 through 6)
4.4.3.11
Calculation Method 2 for Years Vacant (Forecasted Amount for Years 7 through 10)
4.4.3.12
Calculation Method 3 for Years Leased (Forecasted Amount for Years 1 through 6)
4.4.3.13
Calculation Method 3 for Years Vacant (Forecasted Amount for Years 7 through 10)
4.4.3.14
Calculation Method 4 for Years Leased (Forecasted Amount for Years 1 through 6)
4.4.3.15
Calculation Method 4 for Years Vacant (Forecasted Amount for Years 7 through 10)
4.4.3.16
Calculation Method 5 - Monthly Fixed Market Rate
4.4.3.17
Calculation Method 6 - Fixed Market Rate
4.4.3.18
Calculation Method 7 for Years Leased (Forecasted Amount for Years 1 through 6)
4.4.3.19
Calculation Method 7 for Years Vacant (Forecasted Amount for Years 7 through 10)
4.4.3.20
Calculation Method 8 – Square Foot Amount
4.4.3.21
Calculation for Other Assumptions for Years Leased (Forecasted Amount for Years 1 through 6)
4.4.4
Form Used to Set Up Assumption Detail Information
4.4.5
Setting Up Unit Assumption Detail Information
4.5
Setting Up Recycle Assumption Rules
4.5.1
Understanding Recycle Rules
4.5.2
Forms Used to Set Up Recycle Rules
4.5.3
Setting Processing Options for AREF Recycle Rules (P15L107)
4.5.3.1
Versions
4.5.4
Setting Up Recycle Rules
5
Setting Up Constants
5.1
Setting Up AREF Building Constants
5.1.1
Understanding Building Constants Information
5.1.2
Forms Used to Set Up AREF Building Constants
5.1.3
Setting Processing Options for the AREF Building Constants Program (P15L100)
5.1.3.1
Defaults
5.1.3.2
Versions
5.1.4
Setting Up Building Constants Information
5.1.4.1
Defaults
5.1.4.2
NPV and IRR
5.2
Setting Up AREF Building Constants Using Models
5.2.1
Understanding Building Constants Models
5.2.2
Prerequisite
5.2.3
Forms Used to Revise Building Constant Records
5.2.4
Setting Processing Options for the AREF Building Constants Models Program (P15L1001)
5.2.4.1
Defaults
5.2.4.2
Versions
5.2.5
Setting Up Model Building Constant Records
5.2.6
Updating Building Constant Records Using a Model
6
Setting Up Unit Master Information
6.1
Adding Units Manually
6.1.1
Understanding Unit Information
6.1.2
Forms Used to Add Units Manually
6.1.3
Setting Processing Options for the AREF Unit Maintenance Program (P15L101)
6.1.3.1
Defaults
6.1.3.2
Versions
6.1.4
Adding Units Manually
6.1.4.1
Unit Info
6.1.4.2
REM Lease Renewal
6.2
Assigning Assumption Rules
6.2.1
Understanding Assumption Rules
6.2.1.1
Multiple Assumption Rules and Effective Dates Example
6.2.2
Understanding Global Assumption Assignments
6.2.3
Prerequisites
6.2.4
Form Used to Assign Unit Assumptions
6.2.5
Setting Processing Options for the AREF Unit Assumption Assignment Program (P15L1011)
6.2.5.1
Defaults
6.2.5.2
Versions
6.2.6
Assigning Assumption Rules to Units Manually
6.2.6.1
Assumption Rules
6.2.7
Assigning Assumption Rules to Units Globally
6.3
Reabsorbing Units
6.3.1
Understanding Unit Maintenance
6.3.2
Forms Used to Reabsorb Units
6.3.3
Reabsorbing Units
7
Setting Up Account Status Information
7.1
Understanding Account Status Information Retrieval
7.2
Retrieving Account Status Records
7.2.1
Understanding the AREF Account Status Program
7.2.2
Understanding the AREF Global Account Status Retrieval Program
7.2.3
Prerequisites
7.2.4
Forms Used to Retrieve Account Status Records
7.2.5
Setting Processing Options for the AREF Account Status Program (P15L110)
7.2.5.1
Defaults
7.2.5.2
Versions
7.2.6
Retrieving Account Status Records Manually
7.2.6.1
Account Master
7.2.6.2
Account Balances
7.2.6.3
Budget Results
7.2.6.4
Write To
7.2.7
Running the Global Account Status Retrieval Program
7.2.8
Setting Processing Options for the AREF Global Account Status Retrieval Program (R15L1099)
7.2.8.1
Defaults
7.2.8.2
Process
7.2.8.3
Account Balances Selection
7.2.8.4
Budget Results Selection
7.3
Working with Account Status Records
7.3.1
Understanding Account Status Records
7.3.2
Forms Used to Work with Account Status Records
7.3.3
Revising Account Status Records
7.3.3.1
Lock / Unlock Periods
7.3.3.2
Detail Area
7.3.4
Assigning Details to Account Status Records
8
Forecasting for Sales Overage
8.1
Reviewing and Revising Sales Amounts
8.1.1
Understanding the Process to Review Sales Amounts
8.1.2
Forms Used to Review and Revise Uploaded Sales Information
8.1.3
Running the AREF Load Forecasted Sales Program
8.1.4
Setting Processing Options for AREF Load Forecasted Sales (R15L3011)
8.1.4.1
Defaults
8.1.5
Revising Uploaded Sales Amounts
8.2
Entering Sales Amounts for Sales Overage
8.2.1
Understanding Sales Amounts Entry for Sales Overage
8.2.2
Form Used to Enter Sales Amounts for Sales Overage
8.2.3
Entering Sales Amounts for the Unit
8.2.4
Entering Recapture Amounts for the Unit
9
Forecasting Expense Participation
9.1
Understanding Occupancy Data for Expense Participation
9.2
Refreshing Occupancy Data
9.2.1
Prerequisites
9.2.2
Running the AREF Occupancy Refresh Program
9.2.3
Setting Processing Options for AREF Occupancy Refresh (R15L1092)
9.2.3.1
Defaults
9.2.3.2
Process
9.2.3.3
Print
9.3
Revising Occupancy Data
9.3.1
Understanding Occupancy Data Revisions
9.3.2
Forms Used to Revise Occupancy Data for Forecasting
9.3.3
Reviewing Occupancy Data
9.3.3.1
Selection
9.3.4
Revising Occupancy Data
10
Generating Budget and Forecast Amounts
10.1
Generating the Budget
10.1.1
Understanding the AREF Budget Calculation Program (R15L1091)
10.1.2
Prerequisites
10.1.3
Running the AREF Budget Calculation Program
10.1.4
Setting Processing Options for AREF Budget Calculation (R15L1091)
10.1.4.1
Defaults
10.1.4.2
Process
10.1.4.3
Sales Overage
10.1.4.4
Expense Participation
10.1.4.5
Straight-line Rent
10.1.4.6
Versions
10.2
Setting Up Account Association Information
10.2.1
Understanding Account Association Information
10.2.2
Forms Used to Add Account Association Information
10.2.3
Adding Account Association Information
10.3
Revising Forecasted Budget Amounts
10.3.1
Understanding Forecasted Budget Revisions
10.3.2
Forms Used to Revise Forecasted Budget Amounts
10.3.3
Setting Processing Options for AREF Edit Budget (P15L109)
10.3.3.1
Defaults
10.3.3.2
Versions
10.3.4
Locking Calculated Budget Records
10.3.5
Revising Budget Amounts
10.4
Reviewing the AREF Share Factor Denominator Audit
10.4.1
Understanding the AREF Share Factor Denominator Audit
10.4.2
Prerequisite
10.4.3
Forms Used to Review Share Factor Denominator Audit Information
10.4.4
Reviewing the Denominator Value in the Share Factor Calculation
10.4.5
Reviewing the Unit Value in the Share Factor Calculation
10.5
Reviewing the AREF Tenant Exclusion Rule Audit
10.5.1
Understanding the AREF Tenant Exclusion Rule Audit
10.5.2
Prerequisite
10.5.3
Forms Used to Review Tenant Exclusion Rule Audit Information
10.5.4
Reviewing the Tenant Exclusion Rule Total
10.5.5
Reviewing the Tenant Exclusion Rule Amounts by Unit
10.6
Reviewing the AREF Gross Up Adjustments Audit
10.6.1
Understanding the AREF Gross Up Adjustments Audit
10.6.2
Prerequisite
10.6.3
Forms Used to Review Gross Up Adjustments Audit Information
10.6.4
Reviewing the Gross Up Adjustment Total
10.6.5
Reviewing the Gross Up Adjustment Details
10.7
Calculating the Gross Up Processing Area
10.7.1
Understanding the Gross Up Processing Area Calculation
10.7.2
Example: Calculating the Gross Up Processing Percentage Using Area Values from the F15L101 and F1514 Tables
10.7.3
Example: Calculating the Gross Up Processing Percentage Using Area Values from the F15L141 Table
10.8
Generating Budget Revisions
10.8.1
Understanding Budget Revisions
10.8.2
Running the AREF Copy Revisions Program
10.8.3
Setting Processing Options for AREF Copy Revisions (R15L1094)
10.8.3.1
Defaults
10.8.3.2
Process
10.9
Copying Budget Results to the General Ledger
10.9.1
Understanding the Process to Update Budget Results to the General Ledger
10.9.2
Prerequisite
10.9.3
Running the AREF Copy Results to Ledger Program
10.9.4
Setting Processing Options for AREF Copy Results to Ledger (R15L1093)
10.9.4.1
Defaults
10.9.4.2
Process
10.10
Purging Budget Results
10.10.1
Understanding the Process to Purge Budget Results
10.10.2
Prerequisite
10.10.3
Running the AREF Purge Budget Results Program
10.10.4
Setting Processing Options for AREF Purge Budget Results (R15L109P)
10.10.4.1
Defaults
10.10.4.2
Process
10.10.4.3
Print
A
Tables Used in JD Edwards EnterpriseOne Advanced Real Estate Forecasting
A.1
Tables Used in JD Edwards EnterpriseOne Advanced Real Estate Forecasting
B
JD Edwards EnterpriseOne Advanced Real Estate Forecasting Reports
B.1
JD Edwards EnterpriseOne Advanced Real Estate Forecasting Reports
B.2
Prerequisites
B.3
JD Edwards EnterpriseOne Advanced Real Estate Forecasting Reports: A to Z
B.4
JD Edwards EnterpriseOne Advanced Real Estate Forecasting Reports: Selected Reports
B.4.1
R15L001 - AREF Lease Revenue by Type
B.4.2
Processing Options for AREF Lease Revenue by Type (R15L001)
B.4.2.1
Defaults
B.4.3
R15L002 - AREF Schedule of Base Rental Revenue Report
B.4.4
Processing Options for AREF Base Rental Revenue Report (R15L002)
B.4.4.1
Defaults
B.4.5
R15L003 - AREF Schedule of Prospective Cash Flow
B.4.6
Processing Options for AREF Schedule of Prospective Cash Flow (R15L003)
B.4.6.1
Defaults
B.4.7
R15L004 - AREF Account Detail by Month Report
B.4.8
Processing Options for AREF Account Detail by Month (R15L004)
B.4.8.1
Defaults
B.4.9
R15L005 - AREF Input Assumptions
B.4.10
Processing Options for AREF Input Assumptions (R15L005)
B.4.10.1
Defaults
B.4.10.2
Print
B.4.11
R15L006 - AREF Unit Plan Roster
B.4.12
Setting Processing Options for the AREF Unit Plan Roster Program (R15L006)
B.4.12.1
Print
B.4.12.2
Display
B.4.13
R15L111 - AREF Valuation Report
B.4.14
Setting Processing Options for the AREF Valuation Report Program (R15L111)
B.4.14.1
Defaults
B.4.15
R15L1098 - AREF Budget Calculation Audit Report
B.4.15.1
Property and Building Information
B.4.15.2
Unit Information
B.4.16
Processing Options for AREF Budget Calculation Audit Report (R15L1098)
B.4.16.1
Defaults
B.4.16.2
Process
Index
Scripting on this page enhances content navigation, but does not change the content in any way.