Running the Warehouse detail integrity check

In Phase Four, you make sure that the lot, bin, serial numbers, and multiple units of measure agree with the records within the Warehouse application (and also with the external document that created them).

It is important that you not change the values for bin tracking, serial numbered tracking, or lot tracking on Item Master (IC11.1) or Item Location (IC12.1). The accuracy of the Phase Four programs depends on the value you defined for bin tracking, serial numbered tracking, and lot tracking. The value determines how the data displays, and may affect how the program reads (and possibly repairs) the data.

For UNIX and Windows, running the Phase Four programs ensures consistencies within the ITEMLOC, ITSERIAL, and SOHDETAIL files based on data within the WODETAIL, WHSHLDTL, and WHDEMNDDTL files.

For IBMi, running the Phase Four programs ensures consistencies within the DBICITL, DBICSER, and DBICSDT files based on data within the DBWOWOD, DBWHWHD, and DBWHWDD files.

Follow these steps to run the Warehouse detail integrity check:

  1. Run the Warehouse detail integrity check by completing step 1a or 1b:
    1. Use the report programs only and the Warehouse application, run WH-IC Detail Integrity Check (WH423).
    2. Use the update programs and the Warehouse application, run WH-IC Detail Integrity Check - Report and Update (WH433). In the Update field, select No Update (Just Report).
  2. Review the report to determine the correct way to make repairs. You can make repairs manually or rerun the program in Update mode (if you have the update programs).

    If you made repairs manually, then run WH-IC Detail Integrity Check - Report and Update (WH433) in Report mode again to ensure that the errors are corrected. Then, run the program in Update mode.

  3. After repairs are made, repeat step 1 to ensure that no errors exist.