This appendix contains the following topics:
Section B.1, "JD Edwards EnterpriseOne Advanced Real Estate Forecasting Reports"
Section B.3, "JD Edwards EnterpriseOne Advanced Real Estate Forecasting Reports: A to Z"
Section B.4, "JD Edwards EnterpriseOne Advanced Real Estate Forecasting Reports: Selected Reports"
After you generate budget and forecast amounts, you can use the information to generate several budget reports. Many of the reports in JD Edwards EnterpriseOne Advanced Real Estate Forecasting use account association codes that enable you to group account balances into the categories that you most often use for reporting purposes. For example, you might want to group all the bill codes that you use for rent into one association code, RENT.
Each report provides processing options and data selection that you can use to generate different reports for comparison purposes.
Before you complete the tasks in this appendix, you must:
Run the AREF Budget Calculation program (R15L1091) to update the F15L109 table.
Complete the information on the NPV and IRR tabs of the building constant records for which you want to generate financial information if you run the AREF Valuation Report.
Set up association codes for reporting, as necessary.
This table lists JD Edwards EnterpriseOne Advanced Real Estate Forecasting reports, sorted alphanumerically by report ID:
| Report ID and Report Name | Description | Navigation |
|---|---|---|
| R15L001 | Use this report to review the forecasted budget amounts for specific accounts based on the account association codes that you enter in the processing options. | AREF Budget Reports (G15L22), AREF Lease Revenue by Type |
| R15L002 | Use this report to review the revenue amounts for the rent accounts for each unit. | AREF Budget Reports (G15L22), AREF Schedule of Base Rental Revenue |
| R15L003 | Use this report to review the results of the budget forecast as it affects the chart of accounts. | AREF Budget Reports (G15L22), AREF Schedule of Prospective Cash Flow |
| R15L004 | Use this report to review a statement of account balances so that you can review the results of the budget forecast for each period for the specified year. | AREF Budget Reports (G15L22), AREF Account Detail by Month |
| R15L005 | Use this report to review assumption and other rules assigned to each unit that the system used to derive the budget amounts for each unit | AREF Budget Reports (G15L22), AREF Input Assumptions |
| R15L006 | Use this report to review amounts by account association code. | AREF Budget Reports (G15L22), AREF Unit Plan Roster |
| R15L111 | Use this report to review the financial information, such as the net present value (NPV) or internal rate of return (IRR) based on the information set up in the building constants. | AREF Budget Reports (G15L22), AREF Valuation Report |
| R15L1098 | Use this report to print the source of each amount, including the source system, the setup information, and the formulas that the system used in the calculations, for all budget types including sales overage, expense participation, and management fees. | AREF Budget Reports (G15L22), AREF Budget Calculation Audit Report |
Some reports include a more detailed description and processing options. These reports are listed alphanumerically by report ID.
You run the AREF Lease Revenue by Type report (R15L1001) to review the forecasted budget amounts for the accounts based on the account association codes that you enter in the processing options:
Minimum Rent.
Percentage in Lieu of Minimum.
Overage Rent.
Expense Participation.
Real Estate Taxes.
Marketing.
Utilities.
Miscellaneous.
The system provides two versions of the report: one that sequences by unit, and therefore provides account totals by unit, and one that sequences on tenant, which summarizes the account totals for multiple units that are leased by the same tenant.
Processing options enable you to specify the year and revision number to use to retrieve the account information from the F15L109 table, but you can also limit the report to specific properties or leases using data selection.
Processing options enable you to specify the information that appears on reports.
Specify the fiscal year to use to retrieve the information from the F15L109 table. If you leave this processing option blank, the system uses the current year (based on today's date).
Minimum Rent
Specify the account association code to use to retrieve the minimum rent amount that appears on the report.
Percent in Lieu of Minimum
Specify the account association code to use to retrieve the percent- in-lieu-of-minimum rent amount that appears on the report.
Overage Rent
Specify the account association code to use to retrieve the sales overage amount that appears on the report.
Expense Participation
Specify the account association code to use to retrieve the expense participation amount that appears on the report.
Real Estate Taxes
Specify the account association code to use to retrieve the real estate tax amount that appears on the report.
Marketing
Specify the account association code to use to retrieve the marketing amount that appears on the report.
Utilities
Specify the account association code to use to retrieve the utilities amount that appears on the report.
Miscellaneous
Specify the account association code to use to retrieve the miscellaneous amount that appears on the report.
Specify the budget revision number to use to retrieve information from the F15L109 table. If you leave this processing option blank, the system uses revision number 0.
Specify whether to print amounts on the report by unit or by tenant. Values are:
Blank: Print amounts by unit.
1: Print amounts by tenant.
As an alternative to reviewing the revenue amounts for the rent accounts for each unit online, you can run the AREF Schedule of Base Rental Revenue report. Processing options enable you to specify the account association code to use for the rent revenue amounts that you want to review. The system prints the rent amounts for each unit for up to 15 years, and provides a total for each building. The report also provides an average amount per square foot for both the usable and sales areas.
Processing options enable you to specify the information that appears on reports.
Specify the beginning fiscal year to use to retrieve information from the F15L109 table.
The system retrieves budget information for 15 years, beginning with the year that you enter in this processing option. If you leave this processing option blank, the system uses the current year (based on today's date).
Specify the account association code to use to retrieve the base rental revenue amount that appears on the report.
Specify the budget revision number to use to retrieve information from the F15L109 table. If you leave this processing option blank, the system uses revision number 0.
To review the results of the budget forecast as it affects the chart of accounts, you can run the AREF Schedule of Prospective Cash Flow report (R15L003). The system prints a statement of the account balances from the F15L109 table so that you can review projected revenue, expenses, and cash flow trends for each building.
Data selection enables you to specify which buildings to include on the report and the range of accounts for which the report should be generated. If you do not set up any data selection, the system prints the forecasted budget for 15 years for all buildings and all accounts.
Processing options enable you to specify the budget revision number, the beginning fiscal year to use, and the account level of detail (1 through 9). To generate a report with less detail, choose a level of detail that is less than 9; the system summarizes the accounts with a higher level of detail into the accounts at the level of detail that you specify.
Processing options enable you to specify the budget revision number, the fiscal year to use, and the account level of detail (1 through 9). To generate a report with less detail, choose a level of detail that is less than 9; the system summarizes the accounts with a higher level of detail into the accounts at the level of detail that you specify.
Specify the beginning fiscal year to use to retrieve information from the F15L109 table.
The system retrieves budget information for 15 years, beginning with the year that you enter in this processing option.
If you leave this processing option blank, the system uses the current year (based on today's date).
Specify the level of detail (1 through 9) for which you want account information to appear. If you leave this processing option blank, the system uses account level of detail 9.
Specify the budget revision number to use to retrieve information from the F15L109 table. If you leave this processing option blank, the system uses revision number 0.
To review the results of the budget forecast as it affects the chart of accounts by period, you can run the AREF Account Detail by Month report (R15L004). The system prints a statement of the account balances from the F15L109 table so that you can review projected revenue, expenses, and cash flow trends for each period in the fiscal year specified.
Data selection enables you to specify which buildings to include on the report and the range of accounts for which the report should be generated. If you do not set up any data selection, the system prints the forecasted budget for all buildings and all accounts.
You can use the processing options to specify the budget revision number, the fiscal year, and the account level of detail (1 through 9). To generate a report with less detail, choose a level of detail that is less than 9; the system summarizes the accounts with a higher level of detail into the accounts at the level of detail that you specify.
Processing options enable you to specify the information that appears on reports.
Specify the fiscal year to use to retrieve period information from the F15L109 table.
If you leave this processing option blank, the system uses the current year (based on today's date).
Specify the level of detail (1 through 9) for which you want account information to appear. If you leave this processing option blank, the system uses account level of detail 9.
Specify the budget revision number to use to retrieve information from the F15L109 table. If you leave this processing option blank, the system uses revision number 0.
As an alternative to reviewing the assumption and other rules assigned to each unit online, you can use the AREF Input Assumptions report (R15L005) to print the information that the system used to derive the budget amounts for each unit. The system prints the information for the building constants, unit assumptions, expense participation, sales overage, recurring bill codes, and the growth pattern assigned to the unit assumption. The system used this information to calculate the budget amounts for each unit.
The system does not print budget amounts for each account; however, it does provide processing options to enable you to specify account association codes to print summarized amounts for specialty leasing and other income accounts, if desired. The system prints the amount and the growth rate for each year for which the budget information exists in the F15L109 table.
Processing options enable you to specify the information that appears on reports.
Specify the beginning fiscal year to use to retrieve the forecasted amounts from the F15L109 table. If you leave this processing option blank, the system uses the current year (based on today's date).
Specify the revision number to use to retrieve the corresponding assumption information and rules. If you leave this processing option blank, the system uses revision number 0.
Specify the account association code to use to retrieve the account balances for specialty leasing. If you leave this processing option blank, the system does not report on specialty leasing.
Specify the account association code to use to retrieve the account balances for other income. If you leave this processing option blank, the system does not report on other income.
Specify the area definition the system uses to retrieve occupancy information from the AREF Gross Lease Occupied Area table (F15L141). The system uses this information to determine the end of year (EOY) occupancy percentage.
If you leave this processing option blank, the system displays an error.
Specify a calculation method from UDC table 15/OM that the system uses to retrieve occupancy information from the AREF Gross Lease Occupied Area table (F15L141). The system uses this information when processing AREF E.P. Rules. Values are:
1: Area as of the first day of the month. (default)
2: Area as of the last day of the month.
3: Area as of the 15th day of the month.
4: Average area for the month.
Specify whether to print unit assumption information on the report. Values are:
Blank: Print
1: Do not print
Specify whether to print the expense participation rule on the report. Values are:
Blank: Print.
1: Do not print.
Specify whether to print the sales overage rule on the report. Values are:
Blank: Print.
1: Do not print.
Specify whether to print the growth pattern on the report. Values are:
Blank: Print.
1: Do not print.
Specify whether to print the recurring bill code rules on the report. Values are:
Blank: Print.
1: Do not print.
You generate the unit plan roster to review amounts by account association code. You can specify up to nine account association codes to print on the report. By using association codes, you can easily review amounts by a common group, such as rent, instead of amounts by individual bill code.
When a unit is leased, the system prints the tenant and lease information and the corresponding lease-effective dates. When the unit is vacant, the system prints New Lease and uses the dates for which the budget was calculated as the effective dates.
Processing options enable you to print amounts by square foot, if desired, for easier comparison.
The system retrieves information from these tables to generate the report:
F15L101
F15L102
F15L120
F15L109
Processing options enable you to specify the default processing for programs and reports.
Association Codes 1–5 and 7–9:
Specify the account association code to use to retrieve the billing amounts to print on the report.
For each account association code processing option that you complete, you must create labels for the columns that appear on the report by completing the corresponding processing option on the Display tab.
Association Code 6:
Specify the account association code that the system uses for bill code 6 when you run the AREF Leasing Plan Roster program (R15L006).
Specify the revision number to use to retrieve the information.
If you leave this processing option blank, the system uses revision number 0.
Specify the area type to use to retrieve the area value that appears on the report. Values are:
Blank: Billable area. The system uses the value in the Useable Area (USEA) field in the F1507 table.
1: Sales area. The system uses the value in the Sales Area field in the F15L101 table.
Specify whether to print the amounts that correspond to the association codes as an amount per square foot. Values are:
Blank: Do not print the amounts as an amount per square foot.
1: Print the amounts as an amount per square foot. The system divides the amount retrieved for the association code by the area specified in the Area Type processing option to derive the amount per square foot that appears on the report.
Specify the description of the account association code that you entered in the corresponding processing option on the Print tab.
The system prints the description that you enter as the upper column heading for the association code. If the description is short enough to use one column heading only, you can leave this processing option blank and complete only the corresponding Association Code Column Heading 2 processing option.
Specify the description of the account association code that you entered in the corresponding processing option on the Print tab.
The system prints the description that you enter as the lower column heading for the association code. If the description requires two stacked column headings, use the corresponding Association Code Column Heading 1 processing option to specify the description that the system prints in the upper column heading.
If you want to generate financial information, such as the net present value (NPV) or internal rate of return (IRR), you must complete the information on the NPV and IRR tabs of the building constants record and run the AREF Valuation Report (R15L111).
You use processing options to specify the revision number to use to retrieve the information from the building constant record, the beginning fiscal year to use, and the number of years to generate cash flow information.
This table lists the type of financial information that the report generates and the formula that the system uses:
| Financial Information | Formula Used |
|---|---|
| Cash flow | (Revenue) – (expenses, including capital expenditures) |
| Stabilized NOI amount | (The year for stabilized NOI cash flow amount) –(any capital expenditure amounts) |
| Selling price | (Stabilized NOI Amount) / (Cap Rate Percent) |
| Selling cost amount | (Selling price) × (selling cost percent) |
| Net proceeds from sale | (Selling price) × [1 – (selling cost percent)] |
| NPV (net present value) | NPV = CFt/l+kt-IPP
CF = cash flow k = discount rate t = time period IPP = initial purchase price |
| IRR (internal rate of return) | CFt/l+rt-IPP=0
CF = cash flow r = internal rate of return t = time period IPP = initial purchase price |
Processing options enable you to specify the default processing for programs and reports.
Specify the revision number to use to select records from the F15L100 table to print on the report. If you leave this processing option blank, the system uses revision number 0.
Specify the fiscal year to use to retrieve budget information from the F15L109 table.
The system uses the fiscal year that you specify and the value from the Number of Years processing option to determine the range of years on which to retrieve cash flow information and calculate the net present value and internal rate of return.
If you leave this processing option blank, the system uses the current year (based on today's date).
Specify the number of years that the system uses to calculate the net present value (NPV) and internal rate of return (IRR).
The system uses the value in the Start Fiscal Year processing option to determine the starting fiscal year to use.
If you leave this processing option blank, the system uses the number of years for which cash flow information exists in the F15L109 table.
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:
For year 2007, the system prints information based on the effective assumption rule, and the report references it as the AREF Estimated Lease.
For years 2008 through 2010, the system prints information based on the REM lease, and references the actual lease number.
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. Section 4.4, "Setting Up Assumption Detail Information"
When you run the R15L1098, the system first generates information in this order:
Property
Building
Unit
The system prints the same type of information for the business units that are set up as a property and building on a separate page:
Property and building header information.
The system prints information to identify the property or building, such as the business unit number, name, and area values (rentable and sales usable). The system also indicates which area value was used for the calculations.
The system determines the value of each building by adding the area values of the units in the building. The system determines the value of each property by adding the area values of the buildings.
Account status information.
The system prints the account status records that were generated for the property and the business unit for each year the budget is forecast. The report includes the budget pattern code used to allocate amounts to specific periods, an asterisk to indicate a locked period, the period amounts for the year forecast, the total amount, and the growth pattern code that was applied.
The report also includes the growth pattern information, including the growth pattern type (FX, PC, or SF) and the corresponding compounded growth amount (or percentage or amount per square foot).
Management fee information.
The system prints the source information for calculating management fees, if specified, or prints the message No Management Fees to Process.
If you set up management fee information, the report indicates which system the information was retrieved from. If the system retrieves the rules from JD Edwards EnterpriseOne Real Estate Management, the report displays REM rules and the relevant information, such as the bill codes, accounts, effective dates, fee rate and basis, and minimum and maximum amounts. If the system retrieves the rules from JD Edwards EnterpriseOne Advanced Real Estate Forecasting, the report displays AREF rules and the information in the building constant record.
|
Note: The management fee type must be business-unit based (as opposed to lease based) or the system does not retrieve any management fee information from JD Edwards EnterpriseOne Real Estate Management. |
If you set the processing option to retrieve the calculations from the F15L109 table, the report includes the period amounts of the fee. Otherwise, the system prints only the setup information.
Gross lease occupied information.
You can use the processing options to specify whether to print AREF gross lease occupied information. You can select to summarize and prints results by either property, building, or unit. The report also displays area values by period for gross lease occupied area (GLOA) and gross leaseable area (GLA), the occupancy percentage for each period, and the corresponding annual average for each year of the forecast.
The system groups information on the report into these sections:
Unit header information
The system prints information to identify the unit, including the unit type, area values, effective dates, E.P. unit type, floor number, lock flag, and time prior to REM lease.
Lease information
If the unit is leased, it prints the lease information it located, including the lease number, tenant, lease effective dates, lease version, lease status, and lessee flag. Otherwise, the system prints AREF Estimated Lease to indicate that it uses the information only from JD Edwards EnterpriseOne Advanced Real Estate Forecasting.
Lease revenue information
The system prints the assumption rule from either the F15L101 table or the F15L100 table. It then prints the assumption information, including the effective dates, the rate (market or CPI), the action (new, renewal, or blend), the annual base rent that it calculates based on the area of the unit and the market rate), and the growth pattern code. The system prints the growth pattern information, based on the code that was assigned in the assumption, and also includes a calculation to represent the growth pattern amount or percent as amount per square foot.
If the unit is leased, the assumption information includes a recurring bill code rule. If the bill codes have corresponding recurring billing information, the system prints the applicable bill codes, the growth pattern (for nonrent bill codes), and their respective effective dates, amounts, and billing frequency. If the system cannot retrieve any recurring billing information, it does not print the associated bill codes from the bill code rule.
If the unit is vacant, the system calculates rent information based on the assumption rule, and the system does not include recurring bill code rules.
Finally, the report prints lease revenue usage codes for each period that it locates rent and nonrent revenue. If the system retrieves rent revenue for the period, it prints one of the following codes:
R: Indicates that the system retrieved rent from recurring billing information in JD Edwards EnterpriseOne Real Estate Management.
A: Indicates that the system calculated the rent revenue from the assumption rule that was set up in JD Edwards EnterpriseOne Advanced Real Estate Forecasting.
S: Indicates that the system stepped rent during this period.
N: Indicates that the system retrieved nonrent revenue for the period.
Blank: Indicates that the system did not retrieve either rent or nonrent revenue.
Detail assumptions
The system prints the information for each detail assumption, including the computation method, formula used in the calculation, rent bill codes, detail rate, growth pattern, posting account, a message that indicates when the post occurs, the rent step year option, and the calculated amount.
Sales overage information
If you set up sales overage information in both JD Edwards EnterpriseOne Real Estate Management and JD Edwards EnterpriseOne Advanced Real Estate Forecasting, the report includes the setup information for both systems for comparison.
The sales overage information for JD Edwards EnterpriseOne Advanced Real Estate Forecasting includes all of the setup information for the sales overage rule and the sales and recapture amounts entered for the unit.
The sales overage information for JD Edwards EnterpriseOne Real Estate Management includes the setup information for sales overage, product scales, and minimum and maximum rent and recoveries. The system also includes the sales amounts from the Tenant Sales History (F1541B) and Projected Sales Generation (F1542) tables.
After the setup information, the system prints the sales overage usage code for each period to indicate whether the amounts that follow were calculated based on the setup information from JD Edwards EnterpriseOne Real Estate Management (R) or the setup information from JD Edwards EnterpriseOne Advanced Real Estate Forecasting (A).
Finally, the system prints the sales overage amounts that it retrieves from the AREF Prior Gross Billings (F15L302) table.
Expense participation information
If you set up expense participation information in both JD Edwards EnterpriseOne Real Estate Management and JD Edwards EnterpriseOne Advanced Real Estate Forecasting, the report includes the setup information from both systems for comparison. The system prints the setup information for each expense class, including class adjustments, class account overrides, and expense cap rules, and then prints the share factor denominator and tenant exclusion rule, if specified.
After the setup information, the system prints the expense participation usage code for each period to indicate whether the amounts that follow were calculated based on the setup information from JD Edwards EnterpriseOne Real Estate Management (R) or the setup information from JD Edwards EnterpriseOne Advanced Real Estate Forecasting (A).
Finally, the system prints the expense participation calculations and the amounts from the EP Billing Register table (F15L38). The system prints amounts only when you set the processing option to use the budget results.
Processing options enable you to specify the information that appears on reports.
Specify the budget revision number to use to retrieve the information to process.
If you leave this processing option blank, the system uses revision number 0.
Specify the number of the first period for which the system retrieves or calculates a budget.
If you leave this processing option blank, the system uses period 01.
Specify the fiscal year that the system uses to retrieve or begin the budget calculations.
If you leave this processing option blank, the system uses the current year of the company that is assigned to the building that is processed.
Specify the number of years (between 1 and 15) to retrieve or forecast the budget.
If you leave this processing option blank, the system does not generate information for the report.
Specify the term that the system uses to calculate commissions. The assumption types included in this processing option are EC (external commissions), IC (internal commissions), and OC (other commissions).
Blank: Calculate through budget term. You define the budget term in the Budget Start Period, Budget Start Fiscal Year, and Years to Forecast processing options.
1: Calculate through assumption term. You define the assumption term on the AREF Assumption Header Revisions form.
Specify the term that the system uses to calculate tenant improvements. The assumption type included in this processing option is TI (tenant improvements).
Blank: Calculate through budget term. You define the budget term in the Budget Start Period, Budget Start Fiscal Year, and Years to Forecast processing options.
1: Calculate through assumption term. You define the assumption term on the AREF Assumption Header Revisions form.
Specify whether to print sales overage information on the report. Values are:
Blank: Do not print the sales overage information.
1: Print the sales overage information. Unless you enter 1 in the Use Budget Results processing options, the system does not include the budget amounts for the sales overage accounts; it prints only the sales overage information that it uses when you run the AREF Budget Calculation program (R15L1091).
Specify whether to bypass printing sales overage information from JD Edwards EnterpriseOne Real Estate Management when the computation method is 0 (weekly) or whether to print the sales overage information from JD Edwards EnterpriseOne Advanced Real Estate Forecasting. Values are:
Blank: Do not print sales overage information.
1: Print the sales overage information that is set up in JD Edwards EnterpriseOne Advanced Real Estate Forecasting.
Specify whether to print expense participation information on the report. Values are:
Blank: Do not print expense participation information.
1: Print expense participation information.
Unless you enter 1 in the Use Budget Results processing options, the system does not include the budget amounts for the expense participation accounts; it prints only the expense participation information that it uses when you run the AREF Budget Calculation program (R15L1091).
Specify whether to print management fee information. Values are:
Blank: Do not print management fee information.
1: Print management fee information.
Unless you enter 1 in the Use Budget Results processing options, the system does not include the budget amounts for the management fee accounts; it prints only the management fee information that it uses when you run the AREF Budget Calculation program (R15L1091).
Specify whether management fees are posted using the subledger field to show what business unit the fee was calculated for. This allows multiple management fees to be written to one account without any one of them being overwritten. Each management fee calculation is posted with its own subledger. If you leave this processing option blank, the management fee for one account might be overwritten because subledger is not used to distinguish between business units pointing to the same account. Values are:
Blank: Do not post using subledger.
1: Post using subledger.
Specify the unit area to use as the basis for calculating budget amounts. Values are:
Blank: Use the rentable area. The system uses the value in the Useable Area field in the F15L101 table.
1: Use the sales usable area. The system uses the value in the Sales Area field in the F15L101 table.
|
Note: If you set the processing option to use the budget results, and you specify an area in this processing option that is different from the area used to generate the budget results, or if the area on the unit was changed, the calculations on the report does not match the budget result that appears on the report. |
Specify whether the system retrieves information that it previously generated in the F15L109 table or generates new calculations. Values are:
Blank: Do not use the budget results.
The system calculates the budget amounts based on the current setup information and the processing options settings. The system does not calculate sales overage, expense participation, or management fee amounts.
1: Use the budget results.
The system retrieves information from the F15L109 table. If you specify to print sales overage, expense participation, or management fees in the corresponding processing options, the system includes the calculations that it generated for these accounts.
Specify whether to use AREF expense participation rules when E.P. is not set up for the current REM lease. Values are:
Blank: Use AREF rules.
1: Use E.P. information.
|
Note: If you set up expense participation, the system does not use this processing option. |
Specify whether to use AREF expense participation rules when E.P. is not set up for the current REM lease. Values are:
Blank: Use AREF rules.
1: Use recurring billing information.
|
Note: If you set up recurring billing, the system does not use this processing option. |
Enter a user-defined code from UDC table H00/DP that defines the date pattern to use to calculate revenue budget results for AREF assumptions. The budget calculation process uses it to the determine the beginning and ending dates of a period instead of using the company date pattern. For example, if you select a calendar type date pattern, period 1 begins on January 1st and ends on January 31st regardless of how period 1 is defined in the company fiscal date pattern.
If you leave this processing option blank, the budget calculation process uses the company fiscal date pattern.
Specify whether to print gross lease occupied information on the report. Values are:
Blank: Do not print gross lease occupied information.
1: Print gross lease occupied information from the Gross Lease Occupied Area table (F15L141).
Specify the level of summarization when printing gross lease occupied information. If you set the Gross Lease Occupied Information processing option to 1 and you leave this processing option blank, the system selects the default summary level of building. Values are:
1: Summarize by property. The gross lease occupied information represents the total of all buildings included in the report property and revision.
2: Summarize by building. The gross lease occupied information represents the total of all units included in the report building and revision. (default)
3: Summarize by unit. The gross lease occupied information represents detail for each unit included in the report building and revision.
Specify the area definition the system uses to retrieve occupancy information from the AREF Gross Lease Occupied Area table (F15L141). The system uses this information when printing the gross lease occupied information. Because this field is required to display occupancy information, the system issues an error if you leave this processing option blank.
Specify a calculation method from UDC table 15/OM the system uses to retrieve occupancy information from the AREF Gross Lease Occupied Area (F15L141) table. The system uses this information when printing the gross lease occupied information. Values are:
1: Area as of the first day of the month. (default)
2: Area as of the last day of the month.
3: Area as of the 15th day of the month.
4: Average area for the month.