Analyze and Repair Mismatches for Item per Warehouse

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


Using selection orientation 0 and 1 in this function, you can check which setup of synchronization is used:

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.

Using selection orientation 2 in this function, you can check if the reservation, outbound DO, inbound DO, and deliveries connected to a rental agreement line are synchronized with the rental line. Agreements that can be analyzed are limited to status 20, 40 or 50. When checking for errors, the basis is always the rental line status. This means that the rental line status is always assumed to be correct.

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 and the selection orientation, then select 1='Create'.

  3. Press Enter. The E panel is displayed and an analyze round is created with status 10-'New'. Depending on which selection orientation that was set, the E panel displays different fields.

  4. Specify the 'Description' field and choose which checks you want performed. For selection orientation 0 these checks are available:

    • 'Balance ID allocations': The field checks allocations and matches them to find the balance IDs (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 the material plan (MITPLO).

    For selection orientation 2 these checks are available:

    • 'Check rental deliveries': The field checks the reservation, the outbound DO and the outbound delivery for the selected agreement lines.
    • 'Check rental returns': The field checks the inbound DO and the inbound delivery for the selected agreement lines.
  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. This field is not available if selection orientation 2 has been selected.

    • 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 specify these fields, all warehouses and items are selected. If selection orientation 2 has been selected, fields for rental agreement status are also available. Only agreements with status 20, 40 and 50 can be used as a qualifier for searching records in (MWS980).

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

  9. Press Enter. (MWS980/B) is displayed, with the created analysis round in status 10-'New'.

Run an analyze round

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

    After running the analyze round, these statuses 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'. This finishes the ongoing process for the item/warehouse record. The round gets status 21-'Paused'. Later, 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 'Item per Warehouse. Analyze and Repair' (MWS980) and the corresponding records in MWASLN 'Analyze Round. Repair Errors' (MWS981) and MWASMG 'Analyze Round. Display Message' (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 table.

Display and repair identified errors

If the analyze round status is 30-'Errors exist', you can analyze what is causing the errors.
Note: Rental outbound or inbound DO with status greater than or equal to 44 is not repairable using (MWS980).
  1. Options on (MWS980/B)

    Start (MWS980). From (MWS980/B) 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:  Only errors with status 20-'Repairable' are considered. 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 starts (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 submits 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 starts (MWS982).

Display error messages

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

Related topics