Inventory and Warehouse Item Balance Comparison

When you perform a cycle or tag count of items in selected locations in the inventory, the system records the variance between the expected on-hand quantity and the quantity determined from a physical count of the inventory. The system uses this information to update the F41021 and F4602 records. If you record a negative variance (missing inventory), the system subtracts this variance from existing records and can make both sets of records negative. In the cycle or tag process, the system can also create discrepancies between these records.

The Warehouse Location Integrity program (R46990) generates a report that compares the warehouse and inventory records for all locations and items, and displays imbalances between the records. You can set processing options to specify the type of imbalance that the system displays.