Understanding Sales Analysis Information

You can review and revise the information in the Tenant Sales Analysis Reporting File table (F1543B) by using the Sales Analysis Revisions program (P15043). For example, you can review how the sales calculations are derived and the differences between the rolling sales and YTD sales. You can change or delete lines that have invalid or incomplete information.

The Recalculate Amounts processing option controls whether the system recalculates the related information interactively. If the processing option is set to 1 (Recalculate related amounts), the system recalculates the related information according to the changes that you make. Note the following:

• The automatic update involves only the record with which you are working.

  Changes have no effect across records. For example, if you change a QTD sales amount for the reporting period March 2007, the system does not change the same QTD amounts in the records for January 2007 and February 2007. Similarly, if you change a sales amount in the MTD Last Year field for March 2007, the system does not change the sales amount in the MTD This Year field for March 2008.

• The system recognizes only one change at a time.

  After all of the related fields have been recalculated for a change, you must click OK to trigger the recalculation process.

You can use the Report Year Beginning Month field in the Real Estate Management system constants to organize the fiscal periods for the sales information that appears on the Sales Analysis Revisions form. If you enter 5 in the field, for example, the form displays all of the sales for all tenants on a May through April fiscal year. The first quarter of sales is then reported for May, June, and July.

You can reset any records that have been changed, recalculated, or deleted by rerunning the R15143 program.