Using the Inventory Discrepancies Report
The Inventory Discrepancies Report in WMS+ helps administrators identify and resolve mismatches between recorded inventory in SAP Business One and actual WMS+ stock. These discrepancies often arise due to improper manual adjustments in SAP, incorrect pallet handling or untracked item movements. Left unchecked, they can lead to inaccurate order fulfillment, inventory loss and failed audits.
The below explains how to configure, run and act upon the Inventory Discrepancies Report using the Admin Panel. It also clarifies the business implications and provides admin-level guidance on correcting common issues.
Accessing the Report
The report is located in:
Admin Panel → Tools & Reports → Inventory Discrepancies
Opening the menu loads the Inventory Discrepancies interface, where mismatches between WMS+ pallet cases and SAP inventory data are shown in a grid.
Filtering the Report
Administrators can apply filters to narrow the report to specific issues or zones. Filter options include:
Warehouse Code: Filters results to a particular warehouse or zone.
Item Code: Isolates discrepancies for a specific SKU.
Search Field: Enables free-text search across any column, including bin location or batch number.
Interpreting the Report Grid
Each row in the report represents a single discrepancy between a WMS+ pallet case and its corresponding stock entry in SAP Business One. The following fields are shown:
Item Code
Batch/Serial Number
Warehouse Code
Bin Location
Cases Quantity: The quantity recorded in WMS+ for each case, based on the unit of measure captured at receiving.
Cases Inventory Quantity: The total quantity for those cases in inventory UoM.
Cases Count: How many case records match the criteria.
On Hand Quantity: The quantity recorded in SAP Business One for the same item, batch and bin.
Login Alerts for Active Discrepancies
When unresolved records exist in the Inventory Discrepancies Report, WMS+ displays a red alert on login to the Admin Panel to ensure inventory integrity issues are reviewed before further system activity.
Resolving Discrepancies
WMS+ provides two options for resolving mismatches: Quick Fix and manual correction via the CW/Pallet Cases Report.
Quick Fix
When Quick Fix is enabled, the Apply Quick Fix button appears in the top-right corner of the report. The Quick Fix function automatically updates WMS+ case values based on SAP Business One on hand quantity in the following scenarios:
If SAP Business One shows a lower non-zero quantity, WMS+ reduces the case quantity to match.
If SAP Business One shows zero, WMS+ closes the case.
Rows highlighted in green indicate that Quick Fix can be applied. These records involve a single pallet for the item and batch in the specified bin. Rows highlighted in orange cannot be resolved with Quick Fix. These records usually involve multiple pallets for the same item and batch in the same location and require manual resolution.
Manual Correction via CW/Pallet Cases Report
Clicking a row in the report opens the CW/Pallet Cases Report in filtered view for targeted inspection of the affected case.
From here, administrators can open the Update Case Details screen using the pencil icon, where they can adjust:
Quantity: The value stored in WMS+ using the item's purchasing UoM.
Inventory Quantity: The case’s inventory-level value.
Status: Such as Open, Closed, Allocated or Shipped.
Void Warehouse and Bin: A toggle to clear the storage location.
Additional fields:
Quantity Ratio: The UoM conversion factor (view-only).
Auto-Recalculate Quantity: A toggle that updates related fields when values change.
Click OK to save or Cancel to discard changes.
Administrative Guidance
Discrepancies should be investigated using the Document Reference field in the CW/Pallet Cases Report, which links back to the originating transaction. If the issue was caused by a skipped document, an adjustment made only in SAP Business One or a batch mismatch, this reference helps pinpoint the source.
To reduce future discrepancies:
Review the Inventory Discrepancies Report on a weekly basis and prior to the period-end.
Prioritize resolution of mismatches involving high-value or temperature-sensitive inventory.
Never adjust inventory in SAP Business One without applying the corresponding update in WMS+.
Ensure warehouse staff are trained in correct mobile workflows for scanning, receiving and pallet handling.
Escalate recurring discrepancy patterns to configuration or process review.
Maintaining consistency between WMS+ and SAP supports fulfillment accuracy, audit compliance and overall warehouse efficiency.