3PL Warehouse Manager

Updated on August 9th, 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

Locations Reports

This article reviews each report specific to locations and how to generate these reports.

To learn which permissions are required to access any of the reports reviewed below, please see Understanding Reports.

 

 

Navigate to Reports > Locations, then proceed to the relevant guidelines below.

 

Location Identifier

The Location Identifier Report allows you to pick a single location or range of locations to view the items that are currently placed there.

  1. Click Location Identifier.
  2. Select the relevant Customer Name and Warehouse from the grid. To select multiple customers, use < Ctrl > on your keyboard to multi-select.
  3. To narrow the results of the locations that populate in the Location grid, complete the relevant search filters. For example, if "A" is entered in Field 1, only locations that contain "A" display.
  4. Specify whether you want to 'Show Locations with Inventory > 0'.
  5. To narrow the results based on Allocation Priority, enter a Priority Value and select a Comparison Operator from the drop-down menu.
  6. Click Refresh Grid to populate the locations of the customer(s) selected.
  7. Select one or more locations from the grid (using < Ctrl > to multi-select), then click Run Report.

The report generates with the following columns:

  • SKU: Primary identifier of an item
  • Qualifier: Relevant item qualifier
  • Description: Description of item
  • Customer: Name of customer
  • 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
  • Cartons: Number of packaging units available for allocation
  • 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
  • Link To: Links to the Stock Status Report (currently not supported)

Find Item

The Find Item Report helps you locate an item or range of items by customer.

  1. Click Find Item.
  2. Select a relevant Customer, Warehouse, and SKU from the respective drop-down menus.
  3. Click Run Report.

The report generates with the following columns:

  • Location: Current warehouse location
  • 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
  • Cartons: Number of packaging units available for allocation
  • 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

Location List

The Location List Report provides a comprehensive list of all locations in the warehouse. You can run this report without item content to review the location setup.

 

  1. Click Location List.
  2. Select a relevant Warehouse from the grid. To select multiple warehouses, use < Ctrl > on your keyboard to multi-select.
  3. Specify whether you want to view the locations that are Empty, Not Empty, or Either.
  4. Click Run Report.

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

  • Location Name: Name of warehouse location
  • Location Type: Type of warehouse location
  • Description: Description of warehouse location

Quarantine Location

The Quarantine Location Report is the same as the Location Identifier Report above except it applies to quarantined locations only.

  1. Click Quarantine Location.
  2. Select the relevant Customer Name and Warehouse from the grid. To select multiple customers, use < Ctrl > on your keyboard to multi-select.
  3. To narrow the results of the locations that populate in the Location grid, complete the relevant search filters. For example, if "A" is entered in Field 1, only quarantine locations that contain "A" display.
  4. To narrow the results based on Allocation Priority, enter a Priority Value and select a Comparison Operator from the drop-down menu.
  5. Click Refresh Grid to populate the quarantine locations of the customer(s) selected.
  6. Select one or more locations from the grid (using < Ctrl > to multi-select), then click Run Report.

The report generates with the following columns:

  • SKU: Primary identifier of an item
  • Qualifier: Relevant item qualifier
  • Description: Description of item
  • Customer: Name of customer
  • OnHand: Number of primary units currently stored in a quarantined location
  • Allocated: Number of primary units currently allocated to Open and Complete orders
  • Available: Number of primary units available for allocation (always 0)
  • Cartons: Number of packaging units stored in a quarantined location
  • 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
  • Link To: Links to the Stock Status Report (currently not supported)

Replenishment

The Replenishment Report shows the on-hand quantities in all locations and any specified minimum quantities so that you understand which inventory items need to be replenished.

  1. Click Replenishment.
  2. Select the relevant Warehouse from the drop-down menu, then click Generate.

Extensiv University

Gain deeper insights and learn more about 3PL Warehouse Manager with our online course at Extensiv University.
location data place tracking

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • Understanding Common EDI Errors
  • Using Custom Labels
  • Entering Purchase Orders Manually

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