R15412 - Occupancy Costs/Rents Report

The Occupancy Cost/Rents Report (R15412) enables you to compare the total occupancy costs against the total tenant sales.

The system uses information stored in the Unit Master table (F1507) and displays this information:

• Building

• Unit

• Lease begin

• Lease end

• Square footage

• Tenant

• Base rent

• Percent sales rent

• Recoveries

• Effective rent

The system provides the building and report totals. The system inserts page breaks in the report whenever the building changes.

Use the Report As Of Date processing option on the Process tab to determine the active leases that the system processes. The system also uses this date as the base date from which amounts are included. The report includes accounts receivable records from the Customer Ledger table (F03B11) and records from the Accounts Payable Ledger table (F0411) per bill code selection if the GL date is greater than or equal to the Report As Of date.

The system accumulates tenant sales for the combination of lease, building, and unit, using the report as of date as the start date for the accumulations from the Tenant Sales History table (F1541B) and the Tenant Weekly Sales table (F15410). Use the Report Through Date processing option on the Process tab as the ending date for records that are included in the gross accumulations.