The Inventory Integrity Report is a comprehensive analytics dashboard that provides real-time visibility into inventory health and detects anomalies across your supply chain network. This tool enables proactive inventory management by identifying inactive SKUs, tracking financial impact, preventing inventory obsolescence, and resolving discrepancies between system records and actual inventory levels.
Before you begin
Ensure to set the Feature active toggle on.
About this task
Follow the steps to access Inventory Integrity dashboards.
Procedure
-
Log in to Order Hub.
-
Click Dashboards and select Inventory integrity.
The report opens the Dashboard by default.
-
Select the Lookback Period filter to adjust the time range for
analysis.
-
The Dashboard provides actionable insights into inventory health.
Monitor the following key metrics with their trend comparisons:
- Total Stagnant SKUs: Review the total count and percentage change versus the previous
period.
- Phantom SKUs: Identify items that exist in the system but not in physical inventory.
- Dormant SKUs: Track items with no recent transactional activity.
- Stranded Capital: Monitor the financial value tied up in inactive inventory.
Prioritize the following critical issues:
- Zombie SKUs: Items resurrected after purge indicate upstream integration errors that need
investigation.
- Negative SKUs: Items with negative inventory counts are fulfillment blockers and require
immediate correction.
Review aging metrics to prevent inventory obsolescence:
- Longest Stagnation: Identify the oldest phantom SKU and track items approaching the 365-day
limit.
- Dead Stock: Review items with 365+ days of zero transactional activity.
- Projected Obsolescence Risk: Monitor items aging to dead stock within 30 days and their
associated value.
Note: Monthly snapshots are captured at end-of-month and data reflects 6 months of historical
trends independent of the lookback period filter selected in
step 3.
-
Click Reports to generate reports for inventory analysis. Complete the
following details to download:Select the report in Report type and
| Field |
Description |
| Report Type |
Select the report type to download. |
| Time period |
Select the time period for the report. Note:
- If lookback days is selected, select the number of days as time period.
- If specific month is selected, select the month for the report.
|
| Filter by SKU |
Select All SKUs or bulk entry. Note: If bulk entry is selected, enter the SKU IDs separated
by commas.
|
| Select Nodes |
Select the nodes.Note:
- If by nodes is selected, select the nodes.
- If by distribution group is selected, select the distribution group.
- If bulk entry is selected, enter the SKU IDs separated by commas.
|
-
Select the Node Compliance and click on a category to view bottom 10
offenders in that tier. You can also check the best performers and network average.