1. Advanced Real Estate Forecasting Implementation Guide
  2. R15L1098 - AREF Budget Calculation Audit Report

R15L1098 - AREF Budget Calculation Audit Report

During budget calculation, the system derives specific amounts from both the JD Edwards EnterpriseOne Real Estate Management system and the JD Edwards EnterpriseOne Advanced Real Estate Forecasting system. The AREF Budget Calculation Audit report (R15L1098) prints the source of each amount, including the source system, the setup information, and some of the formulas used in the calculations, for all budget types including sales overage, expense participation, and management fees from the AREF EP Billing Register table (F15L38).

Note: The R15L1098 program cannot calculate management fees, expense participation, or sales overage amounts; you must run the AREF Budget Calculation program (R15L1091) for these budget types.

You can generate the audit report before you run the AREF Budget Calculation (R15L1091) program to test how the system uses the information. Processing options enable you to mimic the processing that occurs when you run the R15L1091 program so that you can use the audit report as a proof copy.

The R15L1098 program is a standalone process, although AREF and REM data must be set up in order for the report to run. However, if you select the processing option to use budget results, you must run the AREF Budget Calculation Report (R15L1091) to post results to the F15L109. If you do not select this processing option, the program calculates the budget amounts that appear on the report. The system performs the same calculations regardless of whether you run the R15L1098 program or the R15L1091 program.

Depending on the number of years that you forecast the budget, the system can alternate between using the lease information from JD Edwards EnterpriseOne Real Estate Management and the assumption rules from JD Edwards EnterpriseOne Advanced Real Estate Forecasting more than once. Regardless, each time the system uses different information, it is reported as a different lease.

For example, if the budget is forecast for 10 years (2007 through 2017) and the unit is leased between 2008 and 2010, the system prints information for three leases:

  1. For year 2007, the system prints information based on the effective assumption rule, and the report references it as the AREF Estimated Lease.

  2. For years 2008 through 2010, the system prints information based on the REM lease, and references the actual lease number.

  3. For years 2009 through 2015, the system prints information based on the effective assumption rule, and the report references it as the AREF Estimated Lease.

When you run the AREF Budget Calculation Audit report, you can specify if the system calculates detail assumptions, such as external commissions, based on the assumption term or the budget term. If the assumption term on a lease ends after the budget term, you may want to specify that the system uses the assumption term date so the system calculates all of rates that are specified in the assumption.

If you specify the value 1 in Commissions Term Option or Tenant Improvements Term Option processing options, the system prints effective dates in the Detail Assumptions section of the report. These effective dates fields are useful to review if, for example, the assumption term is 36 months (3 years), but the Years to Forecast processing option is set to 2. On the report, the system displays the dates for the AREF Estimated Lease as 1/1/2011 – 12/31/2012., which is based on the years to forecast value. The system displays the effective dates for the detail assumptions as 1/1/2011 – 12/31/2013, which is based on the assumption term value.

Also, note that the system calculates the total rent that is used to calculate commissions based on the values in the Commission Term Option or Tenant Improvements Term Option processing options. For example, assume that the assumption term is 36 months (3 years) and the Years to Forecast processing option is set to 2. If you set the processing options to use the assumption term, the system uses the term of 3 years for calculation methods that use the base rent value. If you set the processing option to use the budget term, the system calculates the total rent for 2 years. The other calculation methods that use square footage do not calculate differently based on the setting in the Commissions Term Option or Tenant Improvements Term Option processing options.

Review the calculation methods for detail assumptions. Setting Up Assumption Detail Information

When you run the R15L1098, the system first generates information in this order:

  • Property

  • Building

  • Unit