Analyze and Repair Mismatches for Item per Warehouse

This document explains how you analyze and repair mismatches in the database for allocations, inventory, and planning data.


By using this function, you can check whether:

If an error is detected, the item/warehouse combination is recorded in a message file.

This routine is used to repair mismatches for allocation, inventory, and planning data in the database.

For more details on how the system is affected, see Managing Mismatches for Item per Warehouse.

Create an analyze round

  1. Start 'Item per Warehouse. Analyze and Repair' (MWS980/B). Set the panel sequence to E, F.

  2. Specify an ID for the analyze round, then select 1='Create'.

  3. Press Enter. The E panel is displayed and an analyze round is created with status 10='New'.

  4. Fill in the Description field and choose which checks you want performed:

    • 'Balance ID allocations': The field checks allocations and matches them to find the balance id's MITALO -> MITLOC.
    • 'Transaction allocations': The field checks allocations and matches them to find orders MITALO-> xxLINE.
    • 'Allocated order lines': The field checks orders and matches them to allocations xxLINE-> MITALO.
    • 'Item/whs accumulators': The field checks the item warehouse quantities and matches them with the item location quantities (MITBAL-> MITLOC).
    • 'Planning data': The field checks the records in the Material Plan (MITPLO) against order lines quantities and dates. All types of order categories are included in the check.
    • 'Planned order lines': The field checks order lines (different files depending on the order category) against material plan (MITPLO).
  5. Press Enter. The F panel is displayed.

  6. The 'Select by event file based on changed transactions' field indicates whether the analysis round should be selected on the records in the event file. Transactions for each item/warehouse are written to the event file.

    • If this check box is selected, the 'Log events' field in (CRS701) must be activated. The analysis round is then based on the records in the event file.
    • If this check box is selected, you must leave the fields From/To Warehouse and From/To Items blank.
  7. Select the warehouses and/or items to include in the analysis round. If you do not fill in these fields, all warehouses and items will be selected.

  8. The 'Latest warehouse' and 'Latest item' fields indicate the last warehouse record and item record when the analysis round was stopped. Use these fields to determine where the analysis round will start.

  9. Press Enter. The (MWS980/B) panel is displayed, showing the created analysis round in status 10 (New).

Run an analyze round

  1. Select option 9='Analyze by selections' on the (MWS980/B) panel. While the analyze round is processing, the status will be 20='Submitted'.

    After running the analyze round, these statuses will follow:

    • Status 30='Error exists'
    • Status 40='No errors'
      Note: This option also submits all results with status 30='Error exists' to the log file MWASLN, displayed in (MWS981).
  2. You can run and attempt to repair errors on the same command as an alternative. Select option 21='Repair by selections'.

  3. You can also pause an ongoing analyze round. Select option 7= 'Pause round'. It will finish the ongoing process for the item/warehouse record. The round will have status 21='Paused'. Then, you can start the analyze round again from where it was stopped. To restart the analyze round, use the same option that you stopped it with.

  4. Use Option 4='Delete' to delete the record in MWASHE (MWS980) and the corresponding records in MWASLN (MWS981) and MWASMG (MWS982).

    This option must not be used when an analyze or repair is ongoing for the round.

  5. Use Option 10='Analyze by result' to perform an analyze based on the result in the MWASLN file.

Display and repair identified errors

If the analyze round status is 30='Errors exist', you can analyze what is causing the errors.

  1. Options on (MWS980/B)

    Start 'Item per Warehouse. Analyze and Repair' (MWS980). From the (MWS980/B) panel, you can try to repair errors. Select option 22='Repair by result'. This option submits a repair attempt for the result in the log file (MWS981).

    Note:  It only considers the errors with status 20='Repairable'. The errors are displayed in (MWS981).

    See a list with all messages in: Managing Mismatches for Item per Warehouse.

  2. To display and repair errors, select option 11='Result'. This will start 'Analyze Round. Repair Errors' (MWS981), the error log file.

  3. Options on (MWS981/B)

    If there are obstacles against an error for some of the items, you can select option 4='Delete'. This deletes records in MWASLN (MWS981) and MWASMG (MWS982). This option must not be used when an analyze or repair is ongoing for the round.

  4. If you want to repair the actual record (per item/warehouse) use option 21= 'Repair'. This will submit a repair attempt.

    These are the statuses for an error:

    • 30='Error exists'
    • 35='Submitted to repair'
    • 36='Ending repair job'
    • 40='Repaired'
  5. To display messages for each errors/analyze round, select option 12='Message'. This will start 'Analyze Round. Display Message' (MWS982).

Display error messages

  1. Messages are displayed on the (MWS982/B) panel. Open The E panel, then select option 5='Display' to show the message information.

Related topics