Migration of Item Statistics

This document explains how to use M3 API to migrate item statistics from external systems into M3.

Outcome

Historical item statistics are imported from external systems through an API.

Before you start

The conditions in Settings for Inventory Statistics must be fulfilled.

Follow these steps

MMS090MI is used to import historical item statistics data into M3 BE.

The API MMS090MI transfers data sent from the external system to M3 BE and creates records in Item Statistics table MITSTA.

The following MI transactions exist:

  • Add - Creates new item statistics for entered warehouse, item, and period in Item Statistics table MITSTA. Records created via API have Copied Information (CPYI) set to 2 - Copied from external system.
  • Upd - Updates item statistics for entered warehouse, item, and period. Only records with Copied Information (CPYI) set to 2 can be updated.
  • Del - Deletes item statistics for entered warehouse, item, and period. Only records with Copied Information (CPYI) set to 2 can be deleted.
  • Get - Retrieves item statistics for entered warehouse, item, and period.
  • Lst - Lists item statistics starting from entered warehouse, item, and/or period.

Item statistics for periods entered through the API cannot be recreated via 'Item Statistics. Recreate History' (MWS805) since transactions do not exist in M3.

Future periods cannot be entered since this will limit flexibility of item statistics functionality.