Understanding the Sales Report Purge Program (R1541)

To purge records from the Sales Report Control table (F1540B), run the Sales Report Purge program (R1541). In addition to removing records from the F1540B table, the system also updates the batch control records in the F0011 table. The system purges only the sales information that is posted (status code X or P). The most recent sales record, which has a blank status, cannot be purged.

Use the processing options to specify the maximum age in months for the records that you want to keep. The system uses the most recent sales record in a specific product scale group as the base from which to count back. To be eligible for purging, a record must be older than the specified number of months. You can specify one or more buildings or other related criteria during data selection.

Note: You can still review the sales history for a lease even though the sales information has been purged because the Tenant Sales History table (F1541B) is not affected by this program.