Understanding Sales Analysis Generation

Use the Sales Analysis Generation program (R15143) to summarize the information for sales analysis. The program uses information from the Sales Analysis Control table (F1544B), the Tenant/Lease Billings Detail Master table (F1511B) and the Tenant Sales History (F1541B) table.

The R15143 program stores the generated information in the Tenant Sales Analysis Reporting table (F1543B). You can set the system to generate sales analysis automatically when you run the Post Sales Reports to History report (R15820).

If sales analysis is not generated automatically, you must run the R15143 program directly from the Sales Analysis Processing menu. When you post sales reports to history, the system still updates sales for periods in the Tenant Sales Analysis Reporting File table (F1543B) for which sales analysis has already been generated.

If you set the Sales Analysis Dynamic Update processing option to 1 (Update through post), you no longer have to manually change the value in the Automatic Update field in Sales Analysis Control Revisions for each summary code being processed.

If you specify multiple months in the Number Of Months To Keep processing option, the system retains only sales analysis records for that number of months, beginning with the most current record and counting back the number that you specify. The system deletes records older than the specified number of months. If you specify multiple months and also complete the Purge Through Period processing option, the system uses the earlier cutoff date.