The Stock Mismatch report helps users identify differences between the stock quantity recorded in the system and the actual or expected stock quantity. It supports the review and resolution of inventory discrepancies.
Stock Mismatch Review
1. Select Warehouse
Select the required warehouse to review stock mismatches for a specific location.
2. Review Item Stock
Review the stock details for each item and compare the system quantity with the applicable physical or verified quantity.
3. Identify Mismatches
Identify items where the recorded stock quantity differs from the verified quantity. The difference represents the stock mismatch that requires review.
4. Verify Inventory Transactions
Review related inventory transactions such as Inventory Transfers, Inventory Adjustments, Material Issues, and Material Receives to identify the cause of the mismatch.
5. Resolve the Mismatch
Once the cause of the discrepancy is identified, make the required inventory correction through the appropriate inventory transaction or reconciliation process.
6. Verify Updated Stock
After the correction, review the stock balance again to confirm that the mismatch has been resolved and the inventory quantity is accurate.
Stock Mismatch Details
The report provides information such as:
- Item – Item for which the stock mismatch is identified.
- Warehouse – Warehouse where the mismatch occurs.
- System Qty – Quantity recorded in the system.
- Physical Qty – Verified physical quantity.
- Mismatch Qty – Difference between the system quantity and physical quantity.
- Status – Current status of the stock mismatch.
Review and Resolution
Stock mismatches should be reviewed against the relevant inventory transactions and corrected to maintain accurate warehouse stock records.