Generate Exec. Summary Stats (SA30)

The Generate Executive Summary Statistics (SA30) generates and updates statistics in the Executive Summary file (SAES). These statistics are reported by the Executive Summary Report (SA35) and Display Executive Summary (SA49) to provide management with key information on a daily basis.

The following statistics are generated:

• Order Booking statistics by Warehouse.
• Outstanding B/O, P/O, and Inventory balances by Warehouse.
• Company totals for outstanding A/R and A/P, Cash Received and Disbursed for the month being reported and Floor Charge statistics.

For a detailed explanation of all statistics reported from the Executive Summary file, click here.

Each time SA30 is run, the system run date is written into a control record. The system run date is also written into each detail record in the Order Booking Detail file (known as the Revision Date) as well as a flag that indicates if the Order Booking Detail record has ever passed through SA30 before (known as the Update Next flag). When SA30 runs, it reads the Order Booking Detail file (OBBD) for Order activity since the last running of SA30 (based on the Control Date, the Revision Date and the Update Next flag in the Order Booking Detail record), collects the statistics for new Orders, Order changes and Order cancellations and updates the Booking section of the Executive Summary file (SAES).

TIP: This program is intended to run at the end of each day after all Invoice cycles have been completed and after all Cash Receipts and Accounts Payable batches and have been posted but before printing SA35. However, if you wish to monitor Order booking activity during the day, you may run SA30 on demand and then check the 'Today' booking statistic using Display Executive Summary (SA49).

If reporting the Executive Summary Statistics is not part of your normal reporting requirements, you must still run SA30 at the end of each month before running Close Fiscal Sales Period (SA89) to close an Invoicing period. If not, then the following message displays when you run SA89: "Please execute the Generate Executive Summary Statistics program. There are items that need to be updated to the booking files for the current open periods. OK".

To Generate the Executive Summary Statistics:

1. Run SA30 to generate the statistics. The following message displays before the process begins: "Do you want to start this update? Yes/No". Select Yes to begin the process. (Selecting No cancels the request.)

2. SA30 runs automatically, i.e. it runs behind the scenes. When it is finished running, the program closes.

3. When SA30 is complete, print SA35.