3PL Warehouse Manager

Updated on July 11th, 2023

  • Extensiv Hub
    Popular Articles Getting Started Using Hub Technical Issues & FAQs Extensiv's Ideas Portal
  • 3PL Warehouse Manager
    Receiving Operations Inventory Management Shipping Operations System Configuration Scanning Operations Integrations Content Best Practice Resources Release Notes Popular Articles Troubleshooting Guides
  • Warehouse Management
    Getting Started Admin Console Shipping Order Picking & Packing Receiving Customer Portal Cycle Counting Kit Building Managing Users Barcode Scanner Import/Export Integrations Barcoding Wave Picking Bin Move Mobile Receiving and Picking Settings Popular Articles Reporting
  • Order Management
    Dashboard Orders Inventory Purchase Orders Shipments Customers Products Analytics Settings API API Integrations Accessing and Navigating Order Manager Error Messages Order Manager Popular Articles Accounting Integrations
  • Integration Management
    Getting Started with Integration Manager General Support Troubleshooting Extras & Addons API Documentation Popular Articles Order Sources Order Destinations
  • FAQs
  • Network Manager
    Getting Started Order Routing Management Technical Issues Shopping Carts Settings Settings, Products, and Orders
  • Billing Manager
    Getting Started Using Billing Manager
  • Release Notes
    Extensiv Sandbox Extensiv Extensiv Hub 3PL Warehouse Manager Integration Management Warehouse Management Order Management Billing Manager
  • Fulfillment Marketplace
    Getting Started
  • Sandbox
    Getting Started
+ More
  • Help Center
  • 3PL Warehouse Manager
  • Best Practice Resources
  • Classic Reporting
  • Best Practice Resources
    • Technical Support
        • System Requirements
        • Managing PII
        • Understanding Sandbox
    • Professional Services
        • Getting Started with 3PL Warehouse Manager
        • Custom Consulting
        • Consulting Services
        • Ask the Expert
        • Best Practice Consultation
        • Custom Report
        • Add a Customer
        • On-Site Visit
        • Developer Enablement
        • Premium Account Services
    • Customer Central
        • Subscription Invoice and Billing FAQs
        • Navigating the Help Center
        • Navigating the Support Portal
        • Support Portal FAQs
    • Dashboards and Analytics
        • Warehouse Productivity Dashboard FAQs
        • Understanding Dashboard Sync Time
        • Recent Enhancements for Labor Analytics Dashboard
        • Understanding the Warehouse Productivity Dashboard
        • Understanding the Labor Analytics Dashboard
    • Data Imports
        • Import Template FAQs
        • Troubleshooting Import Template Errors
        • Import Templates
    • Classic Reporting
        • Understanding Reports
        • Customizing Reports
        • Stock Status Report
        • Transactions Reports
        • Items Reports
        • Locations Reports
        • Management Reports
    • Best Practice Workflows
        • Pallet In/Pallet Out Workflow
        • Pallet In/Carton Out Workflow
        • Ecommerce Pick/Pack Workflow

Stock Status Report

The Stock Status Report allows you to view inventory levels for one or all of your customers.

To access the Stock Status Report, you must have the following permission applied to your user role: Administration Module > Reports > Reports 1.

 
  1. Navigate to Reports > Stock Status.
  2. Optional: If you want a detailed item selection, you can choose which items you want to display on the report by checking the 'Filter by Items' selection box.
    • Select the relevant customer and warehouse from the drop-down menus.
    • To narrow the SKU results, fill out the relevant SKU search filters, then click Refresh Grid.

  • Continue to Step 4.
  1. Select the relevant customer and warehouse from the grid, using < Ctrl > on your keyboard to multi-select.
  2. Select the relevant End Date.
  3. Specify if you want to 'Show Reorder Categories' to color-code the items that are near minimum or maximum capacity.
  4. Specify whether you want to run a 'Summary' or 'Detailed' report.

    The detailed report breaks down the Stock Status Report identifying each SKU and individual qualifiers, whereas the summary report only displays values for the SKU as a whole.

     
  5. Specify whether you'd like to 'Show All (include zero OnHand)' or 'Show Inactive (include Inactivated Items)' to expand your search results—the system default is active SKUs with on-hand inventory only.
  6. Click Run Report.

The report generates with the following columns—note that most of these values are based on item setup.

  • SKU: Primary identifier of an item
  • Qualifier: Relevant item qualifier
  • Description: Description of item
  • OnHand: Number of primary units currently in the warehouse
  • Allocated: Number of primary units currently allocated to Open and Complete orders
  • Quarantined: Number of primary units placed in a quarantined location
  • Available: Number of primary units available for allocation
  • UOM: Primary unit of measure
  • Variable Available: Number of secondary units available for allocation
  • V. UOM: Secondary unit of measure
  • Dim Qty: Number of packaging units available for allocation
  • Dim UOM: Packaging unit of measure
  • Packed: Number of primary units that are packed for shipment
  • Cu Ft: Total default volume of primary units measured in cubic feet
  • Lbs/Kgs: Total default weight of primary units measured in Imperial or Metric
  • Over: Number of primary units that have been ordered but are unavailable
  • Reorder Category: Indicates whether minimum or maximum quantities have been reached
equity update share report

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • Packing Orders
  • Shipping with UPS
  • Creating Receipts with SmartScan
  • Purchase Order Reporting Options

Not finding the help you need?

Contact Support
Solutions
  • Solutions for Brands
  • Solutions for 3PLs
  • Solutions for 4PLs
  • Solutions for B2B
Products
  • Extensiv 3PL Warehouse Manager
  • Extensiv Warehouse Manager
  • Extensiv Order Manager
  • Extensiv Integration Manager
  • Extensiv Network Manager
Products
  • Customer Success
  • Implementation
  • Consulting
Ecosystem
  • Fulfillment Marketplace
  • Integrations
  • Partners
  • Become a Partner
Resources
  • Resource Library
  • Blog
  • Market Insights
  • What is a 3PL?
  • What is a 4PL?
  • What is a WMS?
  • Why a Cloud-based WMS?
  • Glossary
Help
  • Help Center
  • API Documentation
  • Extensiv Univerisity
  • Community
  • System Status
  • Extensiv Logo
  • 100 N Pacific Coast Hwy, Suite 1100, El Segundo, CA 90245
  • |
  • Contact Us:
  • 83-EXTENSIV 888.375.2368 (main)
  • |
  • 310.844.7570 (local)
  • Copyright © 2023 Extensiv
  • |
  • All rights reserved.
  • Privacy Policy
  • |
  • Terms of Service
  • Follow Us:
Expand