The Total Inventory Report provides a comprehensive, high-level overview of your product inventory quantities across your entire network or specific warehouses. Unlike reports focusing on specific locations or availability for future orders (like ATP), this report gives a consolidated snapshot of total physical stock, including breakdowns of undamaged and damaged quantities, alongside current sales order commitments.

It's an essential tool for strategic inventory analysis, understanding overall stock value, and identifying system-wide inventory levels for specific products.

Location

To access the report, navigate to the Inventory section or use the main search bar. Enter "Total Inventory" and select the report from the results.

Utilizing the Total Inventory Report

This report is valuable for gaining a broad perspective on your inventory:

Consolidated View: By default, it aggregates inventory data across all warehouses defined in your system, offering a complete picture of a product's stock footprint. You can also filter by specific warehouses to drill down.
Stock Status Analysis: Clearly differentiates between Total Quantity (including damaged items) and Undamaged Quantity, allowing for quick assessment of sellable vs. non-sellable stock levels network-wide. The Damaged Qty column pinpoints the exact amount of non-sellable stock.
Availability Insights: Incorporates Open SO Qty to show how much total stock and undamaged stock is currently committed. The Available UOM Quantity and Undamaged Available UOM Qty columns calculate the remaining quantities after these commitments are considered.
Product Details: Includes key product identifiers and categorizations like SKU, Product Name, Product Type, Product Group, and Kit Type for easy reference and filtering. Displays the primary Image associated with the product.
Efficient Navigation: Hyperlinks within the report grid facilitate quick access to related information:
- Clicking a SKU navigates to the Product List screen, filtered for the specific client and SKU.
- Clicking the Open SO Qty directs you to the Shipment Order Backlog screen, filtered by client and SKU (and warehouse if specified).
- Clicking the Damaged Qty takes you to the Inventory by Location screen, filtered to show only the damaged inventory locations for that client and SKU (across all warehouses unless filtered).
- Clicking the Kit Type navigates to the Kit Inventory Report, filtered by client and SKU (and warehouse if specified).

How the Total Inventory Report Works

Consolidation: The report aggregates inventory quantities for each product across all warehouses unless a specific warehouse is selected in the filters.
Product-Centric: Each row represents a unique product (SKU) managed within the system for a specific client.
UOM Based: All quantity fields reflect the product's standard Unit of Measure (UOM).
Real-Time: Reflects current inventory levels and open order commitments based on the latest system data. Significant inventory changes (receipts, shipments, adjustments) will update the report's figures.

Column Explanations

The table below details the columns typically found in the Total Inventory report, their descriptions, calculation logic where applicable, and corresponding Open API fields.

The Open API method to obtain this report as followed:

GET /v{version}/Report/TotalInventory/i/{index}/s/{size}

Note: Please use version as 3.1 to retrieve the most updated version of the endpoint.

Field	Description	Formula	Open API Field
Image	Displays the default image associated with the product.	N/A	productDefaultImageLink
Warehouse	Indicates the warehouse(s) the data pertains to. Shows "All Warehouses" by default, or a specific warehouse code if filtered.	N/A	warehouseCode
Client	The client account associated with the inventory record.	N/A	clientDisplayName
SKU	The Stock Keeping Unit (unique identifier) for the product.	N/A	productSku
Product Name	The descriptive name of the product.	N/A	productName
Product Type	The classification or category assigned to the product	N/A	productTypeName
Product Group	A broader grouping assigned to the product	N/A	productGroupName
Kit Type	Identifies if the product is 'Kit to Stock', 'Kit to Order', or not a kit.	N/A	kitTypeName (kitTypeId)
Total Quantity	The total physical quantity (UOM) of the item across the specified warehouse scope (all or filtered), including any damaged inventory.	(Undamaged Qty) + (Damaged Qty)	totalQuantity
Undamaged Quantity	The total physical quantity (UOM) of the item within the specified scope, excluding any damaged inventory.	(Total Qty) - (Damaged Qty)	undamagedQuantity
Damaged Qty	The total quantity (UOM) of this item within the specified scope that is currently marked as damaged	Sum of damaged inventory records.	damagedQuantity
Open SO Qty	The total quantity (UOM) of this item committed to Shipment Orders that are not yet shipped or canceled, within the specified warehouse scope.	Sum of UOM for non-shipped/non-canceled SO lines.	openShipmentOrderQuantity
Available UOM Quantity	The total physical quantity (UOM), including damaged items, remaining after subtracting commitments to open shipment orders.	(Total Quantity) - (Open SO Qty)	availableUOMQuantity
Undamaged Available UOM Qty	The quantity (UOM) of undamaged inventory remaining after subtracting commitments to open sales orders.	(Undamaged Quantity) - (Open SO Qty)	availableUndamagedUOMQuantity