Prerequisites

Before you run the Repost-Update On Hand Inventory report check the following:

• Review the Work With F42210 Commitments Recovery (P42210) to make sure there are no orphaned records from the Item Location Workfile (F41021WF) that need to be rolled back.
  • SQL transaction failures cause the Quantity On-Hand in the Item Location (F41021) to be temporarily updated.
  • Rollback any such records and rerun the Item Balance\Ledger Integrity report (R41544) to determine any variance between the Item Ledger Quantity and Item Location Quantity in the report.
  • After performing the rollback, there is no reason to run the Repost-Update On Hand Inventory report (R41995) if there is no variance between Item Ledger Quantity and Item Location Quantity columns of the report.
• Review the Manual Inventory to G/L Reconciliation (P41500) to ensure there are no unreconciled transactions where the Item Ledger amount and General Ledger amount involving the item to be reposted are out of balance.
  • If transactions with these items have amounts out of balance between G/L and Item Ledger, make sure to reconcile any differences before proceeding.
  • After reconciling any out of balance amounts between G/L and Item Ledger, rerun the Item Balance/ Ledger integrity report with data selection on the item that was reconciled.
  • If there is no variance between Item Ledger Quantity and Item Location Quantity in the report, there is no reason to run the Repost-Update On Hand Inventory (R41995) on the item.
• Verify that the user-defined code from UDC table (00/DT) for document type I6 displays the hard-coded value as Y.