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 FASB 13
    • 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 Generating Budget Revisions
  • 10.4.1 Understanding Budget Revisions
  • 10.4.2 Running the AREF Copy Revisions Program
  • 10.4.3 Setting Processing Options for AREF Copy Revisions (R15L1094)
    • 10.4.3.1 Defaults
    • 10.4.3.2 Process
• 10.5 Copying Budget Results to the General Ledger
  • 10.5.1 Understanding the Process to Update Budget Results to the General Ledger
  • 10.5.2 Prerequisite
  • 10.5.3 Running the AREF Copy Results to Ledger Program
  • 10.5.4 Setting Processing Options for AREF Copy Results to Ledger (R15L1093)
    • 10.5.4.1 Defaults
    • 10.5.4.2 Process
• 10.6 Purging Budget Results
  • 10.6.1 Understanding the Process to Purge Budget Results
  • 10.6.2 Prerequisite
  • 10.6.3 Running the AREF Purge Budget Results Program
  • 10.6.4 Setting Processing Options for AREF Purge Budget Results (R15L109P)
    • 10.6.4.1 Defaults
    • 10.6.4.2 Process
    • 10.6.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