S/A Executive Summary Stats Generation (SA30)

The S/A Executive Summary Statistics Generation (SA30) generates and updates statistics in the Executive Summary file (SAES). These statistics are reported by the S/A Sales Rep Sales Summary Report (SA34) and the Executive Sales Summary views (Sales Executive Summary Current Period (ibis_saesi.sa49_exec_summ_current) or Sales Executive Summary Next Period (ibis_saesi.sa49_exec_summ_next)) 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 Sales Summary views, please see the Explanation of Executive Summary Statistics help topic.

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. 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 the Executive Sales Summary views.

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 S/A Sales Fiscal Period Close (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 following message displays: "Clear daily totals? Yes/No". Select Yes to clear the daily totals and select No to keep the totals in place.

3. When SA30 is complete, print SA34.