Process

1. Number of Months To Retain

Specify the monthly sales report records to retain in the Sales Report Control (F1540B) and the Tenant Sales History (F1541B) tables. The system purges only those monthly sales report records that exist in both tables (F1540B and F1541B), have a posting status code of either P or X, and are older than the number of months specified.

The system locates the record with the most current date and uses it as the starting date to count back. For example, if the most recent F1540B and F1541B records have the month of 06 and year of 07, and you enter 12 in this processing option. The system retains records that are dated from June 2006 through June 2007. The system purges records that are dated prior to month 06 and year 06.

If you leave this processing option blank, the system deletes all monthly F1540B and F1541B records with posted status codes of P and X.

2. Number of Weeks To Retain

Specify the weekly sales report records to retain in the Sales Report Control (F1540B) and the Tenant Weekly Sales (F15410) tables. The system purges only the weekly sales report records that exist in both tables, have a posting status code of either P or X, and that are older than the number of weeks specified.

The system locates the record with the most current date and uses it as the starting date to count back.

If you leave this processing option blank, the system deletes all weekly F1544B records with posted status codes of P and X.

3. Proof or Final Mode

Specify whether to run the program in proof or final mode. Values are:

Blank: Proof mode. The system prints a report of the records to purge.

1: Final mode. The system prints a report and purges the records from the Sales Report Control (F1540B), Tenant Sales History (F1541B), and the Tenant Weekly Sales (F15410) tables.