To check for orphan records in Warehouse

  1. Check for orphan records. Complete either step 1a or b.
    1. Use the report programs only and the Warehouse application, run WH Orphan Check - Report Only (WH420).

      - or -

    2. Use the update programs and the Warehouse application, run WH Orphan Check - Report and Update (WH430). In the Update field, select No Update (Just Report).

      Details on the CSV files created are found elsewhere in this user guide. CSV files created by update programs

  2. Review the results to determine the correct method of making repairs. You can make repairs manually or (if you have the update programs), rerun WH Orphan Check - Report and Update (WH430) in Update mode.

    If you made repairs manually, run WH Orphan Check - Report and Update (WH430) 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 before going on to the next phase.