3PL Warehouse Manager

Updated on July 11th, 2023

  • Extensiv Hub
    Popular Articles Getting Started Using Hub Technical Issues & FAQs
  • 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 Manager
    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
  • Order Manager
    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 Manager
    Getting Started with Integration Manager General Support Troubleshooting API Documentation Extras & Addons Popular Articles Order Sources Order Destinations
  • FAQs
  • Support
  • Network Manager
    Getting Started Order Routing Management Technical Issues
  • Extensiv Release Notes
    Extensiv Hub 3PL Warehouse Manager Integrations Manager Warehouse Manager Order Manager
  • Billing Manager
    Getting Started Using Billing Manager
+ 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
        • Product Idea Policy
        • Suggesting Product Ideas
        • Product Idea 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 Templates
        • Import Template FAQs
        • Troubleshooting Import Template Errors
    • Classic Reporting
        • Understanding Reports
        • Customizing Reports
        • Stock Status Report
        • Transactions Reports
        • Items Reports
        • Locations Reports
        • Management Reports
        • Inventory Reporting Beta End-of-Life FAQ
    • Best Practice Workflows
        • Pallet In/Pallet Out Workflow
        • Pallet In/Carton Out Workflow
        • Ecommerce Pick/Pack Workflow

Items Reports

This article reviews each report specific to items 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 > Items, then proceed to the relevant guidelines below.

Item Activity

The Item Activity Report allows you to view the ins and outs of your items, such as the quantities going in and out of your warehouse and the lot numbers associated with your items. While both the Summary and Detailed reports are pictured in the images below, the written steps guide you through generating a summary report.

Please note that the Item Activity Report was created to show only activity in a given date range. This report is based on date range and does not report anything outside the entered parameters.

 
  1. Click Item Activity.
  2. Specify whether you want to generate a Summary or Detailed report.

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

     
  3. Select a relevant Customer and Warehouse from the respective drop-down menus.
  4. To narrow the SKU results, fill out the relevant SKU search filters, then click Refresh Grid.
  5. Select an item from the grid, then enter a relevant Start Date and End Date.
  6. Click Run Report.

The summary report generates with the following columns:

  • SKU: Primary identifier of an item
  • Qualifier: Relevant item qualifier
  • Item Description: Description of an item
  • Packed: Number of primary units that are packed for shipment
  • Activity Date: Dates activities took place
  • Trans #: Relevant transaction number
  • Ref #: Reference number recorded on the transaction
  • Qty in / Ctn: Number of primary units received into the warehouse / Packaging units received into the warehouse
  • Qty out / Ctn: Number of primary units shipped out of the warehouse / Packaging units shipped out of the warehouse
  • Balance: Number of primary units on the transaction
  • Ctn Balance: Number of packaging units on the transaction

The detailed report generates with the following unique columns:

  • Lot #: Lot number recorded on an item
  • Serial #: Serial number recorded on an item
  • Movable Unit: Unique MU license plate assigned to an item
  • Expiration Date: Expiration date recorded on an item
  • Location: Current warehouse location

View Item

The View Item Report shows you the details of the items in your inventory, such as the dimensions and tracking information.

  1. Click View Item.
  2. Select the relevant Customer Name from the grid, then click Run Report.

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

  • SKU: Primary identifier of an item
  • Description: Description of item
  • Inv UOM: Primary unit of measure
  • Min: Minimum threshold
  • Max: Maximum threshold
  • Reorder Qty: Number of primary units the customer is expected to replenish once Min is reached
  • Cycle Count: Number of days between recommended inventory counts
  • Inv Method: Allocation method
  • Cost: Product cost
  • UPC: UPC value
  • Temp: Storage temperature

Item Movement

The Item Movement Report allows you to see movements in the warehouse and the process used to move a specific item. It can show you the location of where an item was moved from and where it was moved to, as well as the SKU, the day it was moved, the user who moved it, the quantity that was moved, and the process in which it was moved (whether it was moved during the received process, moved by the mobile scan gun, moved manually in the system, or moved during any type of pick and pack or staging).

  1. Click Item Movement.
  2. Fill out the fields relevant to your search, then click Run Report.

The report generates with the following columns:

  • SKU: Primary identifier of an item
  • From Location: Item's previous warehouse location
  • To Location: Item's current warehouse location
  • Lot #: Lot number recorded on an item
  • Serial #: Serial number recorded on an item
  • MU Label: Unique MU license plate assigned to an item
  • Cost: Product cost
  • ExpDate: Expiration date recorded on an item
  • Move Process: Identifies the process used to move the item
  • UserName: Name of user who moved the item
  • Qty Moved: Number of primary units moved
  • When Moved: Date and time when the item was moved
product summary item list

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • Voiding Shipping Labels
  • Editing Track-By Values
  • Scheduling with an Existing Receipt
  • Pallet In/Pallet Out Workflow

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