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.

To run the Warehouse detail integrity check

  1. Run the Warehouse detail integrity check. Complete either step 1a or b.
    1. Use the report programs only and the Warehouse application, run WH-IC Detail Integrity Check (WH423).

      - or -

    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, run WH-IC Detail Integrity Check - Report and Update (WH433) in Report mode again to be sure that the errors are corrected. Then, run the program in Update mode.

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