Forecasting for Sales Overage

This chapter discusses how to:

Click to jump to parent topicReviewing and Revising Sales Amounts

This section provides an overview of the process to review sales amounts and describes how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Process to Review Sales Amounts

When you run the AREF Load Forecasted Sales program (R15L3011), the system copies sales amounts from the Projected Sales table (F1542) to the AREF Project Sales table (F15L301). You can specify the revision number to assign to the uploaded sales records in the processing options. To process sales overage, the revision number that you specify must be the same as the revision number assigned to the sales overage rule. If you do not want to upload all sales amounts for all years, buildings, and leases, you must use data selection to specify the records to retrieve. After you load forecasted sales into the F15L301 table, you can revise the information as necessary using the AREF Forecasted Sales program (P15L301).

Click to jump to top of pageClick to jump to parent topicForms Used to Review and Revise Uploaded Sales Information

Form Name

FormID

Navigation

Usage

AREF Work With Forecasted Sales

W15L301A

AREF Retail Setup (G15L413), AREF Forecasted Sales

Review forecasted sales that were uploaded from the JD Edwards EnterpriseOne Real Estate Management system.

AREF Forecasted Sales Revisions

W15L301B

On the AREF Work With Forecasted Sales form, select a sales record.

Revise uploaded sales amounts.

Click to jump to top of pageClick to jump to parent topicRunning the AREF Load Forecasted Sales Program

Select AREF Retail Setup (G15L413), AREF Load Forecasted Sales.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for AREF Load Forecasted Sales (R15L3011)

Processing options enable you to specify the default processing for programs and reports.

Defaults

1. Revision Number

Specify the revision number to assign to the projected sales records that the system copies from the F1542 table to the F15L301 table. If you leave this processing option blank, the system assigns revision number 0.

Click to jump to top of pageClick to jump to parent topicRevising Uploaded Sales Amounts

Access the AREF Forecasted Sales Revisions form.

Unit No (unit number)

Enter the number that identifies the actual space within a building that is or can be leased. Examples include an apartment, office, retail space, or parking space.

Lease Number

Enter a number that identifies an original document. Examples include a voucher, a sales order, an invoice, unapplied cash, or a journal entry.

Estimated Sales Period 1 through Estimated Sales Period 12

Enter the forecasted sales amount for each period in the year.

Click to jump to parent topicEntering Sales Amounts for Sales Overage

This section provides an overview of sales amounts entry for sales overage and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Sales Amounts Entry for Sales Overage

If you do not have sales amounts in JD Edwards EnterpriseOne Real Estate Management, you can enter sales amounts for the unit in JD Edwards EnterpriseOne Advanced Real Estate Forecasting (AREF).

The AREF Budget Calculation program (R15L1091) uses sales amounts that are contingent upon whether sales overage information exists on the lease that is attached to the unit. If you have sales overage information attached to the lease and you do not have sales amounts in either the Sales History Work File table (F1541BW) or the Projected Sales Generation table (F1542), the system does not forecast the budget for the time of the lease even if you added sales amounts to the unit in the AREF Unit Maintenance program (P15L101).

When the lease expires, the system uses the sales overage rule and sales amounts. If you do not attach sales overage information to the lease, the R15L1091 program searches for an AREF sales overage rule and unit sales amounts.

You can use the P15L101 program to enter sales amounts by building and revision number. Additionally, you can specify a recapture amount, which guarantees the tenant a specific amount, that is subtracted from the sales amount when the system calculates the budget.

Click to jump to top of pageClick to jump to parent topicForm Used to Enter Sales Amounts for Sales Overage

Form Name

FormID

Navigation

Usage

Unit Revisions

W15L101A

AREF Setup (G15L412), AREF Unit Maintenance

On the Work With Units form, select a unit.

  • Enter sales amounts for the unit.

  • Enter recapture amounts for the unit.

Click to jump to top of pageClick to jump to parent topicEntering Sales Amounts for the Unit

Access the Unit Revisions form. Select the Sales Amounts tab.

Amount - Period 1 through Amount - Period 12

Enter the estimated sales amount for the period.

The AREF Budget Calculation program (R15L1091) uses this amount to forecast sales when no estimated sales exist in the F15L301 table.

Click to jump to top of pageClick to jump to parent topicEntering Recapture Amounts for the Unit

Access the Unit Revisions form. Select the Recapture tab.

Amount - Year 1 through Amount - Year 15

Enter the annual sales amount that is guaranteed to the lessee (tenant) of the unit.

When the system calculates the budget, the system divides the amount entered by 12 and then subtracts the result from the sales overage amount for the period. The system ignores this field if sales overage rules are not assigned to the unit.