Maintenance Customer Order Statistics

Before you start

This process can be started when the following prerequisites are met:

• Datasets are created.
• The MCO order types to update sales statistics are entered correctly.
• The sales statistics are stored in a dataset with transaction type 32 and UCORIG = 7.
• The transaction type is valid for the dataset in which the sales statistics are accumulated.

Follow these steps

The diagram below illustrates the activities included in the process.

1. Create Dataset

   Datasets are storage sites for statistical information. They are created in program 'Dataset. Open' (OSS401).

   When defined, a dataset is assigned key fields and accumulator fields that are used for reporting. These fields are set in a hierarchical order. The number and sequencing of these fields determine the reporting information found in the dataset.

   Datasets allow statistical information to be stored at different levels so that it can be quickly accessed. Datasets can be redefined and their information rearranged to meet changing requirements or reporting needs.

   A dataset can be defined according to the following selections:

   • Key field such as customer or item
   • Accumulator field such as invoiced amount
   • Period type such as weekly or monthly

   The dataset is structured as a separate OS/400 file with real field names. This allows efficient ODBC connections to other tools.

2. Update Detailed Sales Statistics

   Detailed sales statistics are updated from invoiced order lines. as specified in the customer order type. This can be automatic during invoicing or done manually in program 'Maint Invoice. Post-process' (COS196).

   These statistics are accumulated in datasets for further processing as totals.

3. Re-create Detailed Sales Statistics

   When needed, detailed sales statistics can be re-created. This can be necessary if historical data has been destroyed or if the parameters for updating MCO order types have been changed.

   The detailed sales statistics are re-created in program 'Sales Statistics. Re-create' (COS995) by selecting the accounting date as of when the statistics should be re-created.

   In order to re-create the statistics, the invoiced delivery lines must still be in the database. Also, when the statistics are re-created, all affected datasets are automatically re-created.

4. Update Dataset

   The accumulated totals are updated to the dataset(s) for total sales statistics. Each invoice transaction that updates the detailed statistics is checked for the information which is updated to the dataset. The information checked is:

   • The division is correct.
   • The start and end dates for updating the dataset include the accounting date for the transaction.
   • The sales statistics transaction type is included in the dataset.
   • The transaction meets the selection criteria defined for the dataset.

   The dataset that matches this information check is updated automatically for every new record created in the detailed statistics.

5. Re-create Dataset

   When needed, the data in datasets can also be re-created. This can be for newly defined or redefined datasets. This is done in program (OSS995) by selecting the accounting date as of when the statistics should be re-created. See procedure Re-create MCO Statistics in Datasets and supporting function Datasets. In order to re-create the data, the base information must still be in the detailed sales statistics.

6. View / Generate Reports

   Reports can be obtained from any defined dataset using program 'Sales Stats/Budget Report. Open' (OSS412). These can be reviewed the following ways:

   • On-screen
   • Printout
   • As an Office document for distribution by distribution lists (see Report Processing)
   • From a PC file for further processing – see procedure Export Data from Dataset to PC File

   Example

   Below are examples of the information that can be obtained using dataset and report processing.

   • Sales statistics
   • Profitability analyses
   • Lead time analyses
   • Error analyses
   • Trend analyses

7. File Detailed Sales Statistics

   The detailed sales statistics contain one record for each invoiced customer order line. These records should be filed to avoid their taking up too much space in the system. Filing can be done after a reasonable time in program 'Sales Statistics. File' (OSS080).