Inventory Reports

Inventory reports help inventory supervisors to manage inventory, track the movement of inventory within the warehouse, and get visibility on the different categories of inventory, such as, inventory that are on hold. These reports can also be used to categorize inventory based on cost.

For more information about inventory reports, see "Inventory Reports".

The inventory reports provided with Sterling Warehouse Management System are:

• Containers Not Having Standard Quantity Report

  This report lists all cartons stored in the warehouse that have less than the standard case or pallet quantity. This report can be used to identify opportunities for consolidation.

• Cycle Count Variance Daily Report

  This report provides the cycle count variance information, on a daily basis, for a given date range.

• Cycle Count Variance Monthly Report

  This report provides the cycle count variance information, on a monthly basis, for a given date range.

• Cycle Count Variance Weekly Report

  This report provides the cycle count variance information, on a weekly basis, for a given date range.

• Physical Inventory Count Detail Report

  This report provides physical count information based on the demand.

• Dedicated Locations Usage Report

  This report provides visibility into locations that are dedicated to certain Stock Keeping Units (SKUs). This usage report shows locations that have remained unused in various time buckets.

• Dedicated Locations Activity Report

  This report provides visibility into locations that are dedicated to certain Stock Keeping Units (SKUs). The activity report categorizes the locations based on the number of times the location is replenished.

• Empty Location Report

  This report provides a list of empty locations in the warehouse. This report can also be accessed as a sub-report of the Space Consolidation Report.

• Inventory Aging Report

  This report provides the inventory age identified by its receipt date. In case the receipt date information is lost, the inventory age cannot be ascertained and is therefore classified as "Inventory with Unknown Age".

• Inventory Audit Report

  This report is used to track inventory changes resulting from the execution of tasks in the warehouse. This report can help in tracking changes to item or location inventory, inventory changes done by a user, or a combination of these.

• Inventory Balance Report

  This report is used to balance the opening and closing quantity of inventory for an item within a date range.

• Inventory Hold Report

  This report lists the item and location details for all items that are on hold due to Quality Control activities, Count variances, and locations that are frozen for Picking or Putaway.

• Item Inventory Across Nodes Report

  This report is used to track the inventory of items across nodes for either all or selected enterprises. The report can be generated only for those enterprises to which the user has access.

• Item Inventory Report

  This report lists the details of the item inventory at the node. You can drill down to location level and container level reports from this report.

• Item Tag No. Report

  This report lists all item transactions for the given tag number. The report displays the transactions in three categories: Inbound, Inventory, and Outbound.

• Item Velocity Report

  Due to changes in demand, seasonal variations, and product life cycle characteristics, item velocity changes over time. This report captures the item velocity, as measured by the number of shipments that the item features in during the selected date range.

• Location/SKU Velocity Mismatch Report

  This report matches the Location Velocity to the Item Velocity to identify locations that have a mismatch. The warehouse can use this report to reorganize item locations to optimize the utilization of locations.

• Node Inventory Valuation Report

  This report lists the item, quantity, and valuation details for a node. This report is useful in determining the inventory valuation in a node.

• Participant List Report

  This report lists the number of participants defined in the Selling and Fulfillment Foundation Participant Model with role details.

• Space Consolidation Report

  This report provides item-wise information about the location capacity utilization. This helps in identifying space consolidation opportunities.

• Space Utilization Report

  This report provides information on location capacity utilization in terms of percentage.

• Location Inventory Detail Report

  This report is used to track the inventory of items and locations in the warehouse at the item, case, pallet, status, and other item attributes levels.

• Location Inventory Summary Report

  This report is used to track the inventory of items and locations in the warehouse at the item or location level.