Discrepancies
You can create cycle count waves for inventory discrepancies automatically using the end-of-day function, or manually in TWL Execution-Cycle Count-Setup.
Discrepancies that are caused by zero or negative quantities in a location cannot be deleted after a count record is created. When a discrepancy occurs, it is beneficial to count all locations the product is stored in.
This table shows the cycle counts created by TWL for these discrepancies:
| Description | Action | Problem Type | Code | Reason |
|---|---|---|---|---|
| Physical Inventory | Removes all discrepancies for all products | When you begin a physical all discrepancies are removed | ||
| Physical Inventory | Removes all discrepancies for all products | When you finish a physical all discrepancies are removed | ||
| Physical Inventory | Creates discrepancy | Quantity | YC | Quantity counted <> quantity in bin |
| Random Bin Count | Creates discrepancy | Quantity | CB | Adjust on Count field not selected |
| Random Bin Count | Removes all discrepancies for product | Quantity | CB | Adjust on Count field is selected |
| Random Item Count | Creates discrepancy | Quantity | CI | Adjust on Count field not selected |
| Random Item Count | Removes all discrepancies for product | Quantity | CI | Adjust on Count field is selected |
| Cycle Counts | Creates discrepancy | Quantity | CS | Adjust on Count field not selected |
| Cycle Counts | Removes all discrepancies for product | Quantity | CS | Adjust on Count field is selected |
| Picking | Creates discrepancy | Quantity | IG | Quantity picked <> assigned quantity |
| Picking | Creates discrepancy | Location | IG | Bin location <> assigned bin |
| Receiving | Creates informational discrepancy | Unknown | ZI | Item cube or weight data missing |
| Receiving | Creates informational discrepancy | Unknown | ZI | You received a nonstock product not in the database |
| Stock Putaway | Creates discrepancy | Quantity | PA | Quantity put away <> quantity on pallet |
| Stock Putaway | Creates discrepancy | Location | PA | Put-away bin <> suggested bin |
| Stock Consolidation | Creates discrepancy | Quantity | MC | Quantity picked <> assigned quantity |
| Stock Consolidation | Creates discrepancy | Quantity | MC | Quantity moved > quantity on pallet |
| Stock Consolidation | Creates discrepancy | Location | MC | Bin location <> assigned location |
| Stock Movement | Creates discrepancy for from and to bins | Quantity | MS | Quantity picked <> assigned quantity |
| Stock Movement | Creates discrepancy | Location | MS | Bin location <> assigned location |
| Stock Replenishment Load Cart Detail | Creates discrepancy | Quantity | MR | |
| Unplanned Stock Replenishment | Creates discrepancy | Quantity | MU | |
| Create cycle counts from discrepancies | Option to remove | You can remove or save discrepancies | ||
| Stock Adjustment | Removes all discrepancies | Quantity |
You can view an audit trail of discrepancy cycle counts by generating the TWL Cycle Counts Created for Discrepancies Report.