Run and Display Summarized Item Statistics

This instruction explains how to run and display summarized item statistics. Summarized item statistics is used to get accumulated information of an item over a period.

Outcome

At the end of an MPM period, summarized item statistics can be run and displayed.

The summarized item statistic can be used to display statistic information about item type, item group, product group, responsible planner, etc.

Each time a transaction is entered, the regular statistical table (MITSTA) is updated in accordance with the transaction settings. Summarized statistics is saved in the stock transaction statistics summary table (MITSTS).

Before you start

The conditions in Settings for Inventory Statistics must be fulfilled.

Follow These Steps

  1. When the decision to close the MPM period has been made, open 'Item Statistics. Create Summary' (MMS810). Fill in the 'Report version' field on the (MMS810/B) panel.

  2. Select whether the A or E panel should be the opening panel.

  3. On the (MMS810/E) panel, enter which period should be included in the calculation. This program will create summarized statistics according to the settings in 'Settings. Summary Inventory Statistics' (CRS716).

  4. Periodic summary statistics have now been run or recreated.

  5. The next step is to display the summarized statistic. Open 'Item Statistics. Display Totals' (MMS290).

  6. To create a View, click in the 'View' field. Click again and 'View. Open' (MMS091) is started.

  7. Fill in the 'View' field on the (MMS091/B) panel.

  8. On the (MMS091/E) panel, up to six column headings can be selected and named. Selections are made from the fields displayed on the lower part of the screen. Enter the selected field numbers in the 'Field number' field. Up to five different field numbers can be connected to each column.

  9. Add, subtract, divide or multiply the different fields with each other by using an operand.

  10. The 'Column display' field (Dsp) indicates how the total in 'Item Statistics. Display' (MMS090) should be displayed. The 'Deviating number of decimal places' field (Dec) indicates the number of decimal places that should be used for a statistic column.

  11. Select the created view (option 1 = Select). The (MMS290/B) panel is redisplayed.

  12. The 'Summation key' field on the (MMS290/B) panel specifies how statistics are displayed.

    The summation key displays statistics about:

    • 01 Item type
    • 02 Item group
    • 03 Product group
    • 04 Cost reference
    • 05 Responsible planner
    • 06 ABC volume
    • 07 ABC frequency
    • 08 ABC contribution
    • 09 Manual ABC class
    • 10 Stock zone.

    Example: If you select Summation key 01=Item type, then the lead text Item type appears, and you can specify up to five different item types or leave it blank to include all existing item types in the statistics.

  13. Select a period or year (depends on the selected sorting order) and select option 5=Display. On the (MMS290/E) panel, summarized statistics for that period or year are displayed.

Related topics