Warehouse Management

Updated on February 16th, 2024

  • 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
  • Warehouse Management
  • Reporting
  • Warehouse Management
    • Getting Started
        • Step 1: Setting Up a User
        • Step 2: Setting Up Your Business
        • Step 3: Setting Up Part Records
        • Step 4: Setting Up Your Inventory
    • Admin Console
      • Admin Console Basics
          • Warehouse Unlimited Admin Overview
          • Alpha / Beta
      • Managing Views
          • Navigating Menus
          • What Are Views?
          • Creating / Editing Views
          • Cloning Views
      • Other Topics
          • Print Jobs
          • Label Printing Admin
      • Tags
          • Tags Overview
          • Creating Tags
          • Applying Tags
    • Shipping
      • Shipping process
          • Shipping in Mobile
          • Creating a Sales Order in the Classic Admin Console
          • Creating a Sales Order in the Unlimited Console
    • Order Picking & Packing
      • Order Pick/Pack Information
          • Order Pick Overview
          • Guided Order Pick
          • Order Packing
          • Packing in Mobile
      • Picking with Device / Mobile
          • Step by Step - Guided Order pick on Device
      • Other Topics
          • Pick to Carton
          • Pick Item with Part Scan Settings
          • BackOrder Setting
          • Cross Docking
    • Receiving
      • Overview
          • Receiving Overview
          • Receiving Modes
      • Receiving on Device/Mobile
          • Creating a Purchase Order
          • Single Bin Receiving - Device
          • Single Bin Receiving - Mobile
          • Direct Put Away Receiving
          • Guided Put Away
      • Editing Receiving
          • Adjusting Quantities
          • Deleting Line Items Received
    • Customer Portal
      • Customer Portal Info
          • Customer Portal Overview
          • Customer Portal Options
      • Setting Up Customer Portal
          • Setting up Customer Portal User
          • Locking User into Location
          • Using Client Parts
          • Customer Portal Permissions
      • Using Customer Portal
          • Logging into Customer Portal
          • Customer Portal Customization
    • Cycle Counting
      • Cycle Counting with New Admin
          • Creating Cycle Count By Bin
          • Blind Count By Bin
          • Technical Count By Bin
          • Creating Cycle Count By Part
          • Blind Count By Part
          • Technical Count By Part
          • Committing Cycle Counts
      • Cycle Counting Classic
          • Cycle Counting Overview Classic
          • Cycle Count Reports Classic
          • Commit Cycle Count Values Classic
          • Blind Count Vs Technical Count Classic
          • Cycle Count on Device Classic
          • Cycle Count on Mobile Classic
    • Kit Building
        • Kit Building Overview
        • Creating Process Bins
        • Creating Kitted Parts
        • Kit Requests
        • Building Kits on Mobile
        • Breaking Kits On Mobile
        • Building Kits with Device
        • Breaking Kits With Device
        • Lot Numbers and Kit Building/Breaking
    • Managing Users
        • Editing Group Permissions
    • Barcode Scanner
      • System Requirements
          • Intro to Barcode Scanners
          • Compatible Devices
          • Network Requirements
      • Setup
          • Setting up WiFi / Network Connection
          • Downloading & Installing Extensiv Warehouse Manager
          • Configuring Extensiv Warehouse Manager
          • Recommended Settings for Datalogic Skorpio X3 and Falcon X3
          • Updating a Device
          • ScanSKU Setup
          • Installing Extensiv Warehouse Manager on a Data Logic DL-Axist
      • Troubleshooting
          • Performing a Cold Boot
          • Error Codes
          • Network Connection Troubleshooting
          • Barcode Will Not Read
          • Label Not Printing From Scan Gun
          • Application Closes
          • Device Update - Single Web Service
    • Import/Export
      • Introduction
          • Types of Import/Export
          • Data Types In Extensiv Warehouse Manager
          • .CSV Files
      • SNAP
          • Downloading and Installing SNAP
          • Creating Jobs
          • SNAP Export
          • SNAP Import
          • SNAP Delete
          • Label Printing in SNAP
          • SNAP FTP
          • Creating Job Groups
          • Scheduler
          • Generating SOAP API Credentials
      • Trouble Shooting SNAP
          • Errors in SNAP
          • Data Will Not Import
          • Matching .CSV Columns with Snap Import
          • SNAP Video
    • Integrations
      • Brightpearl
          • Brightpearl Integration Details
          • Brightpearl Integration Setup
          • Brightpearl Integration Settings
          • Brightpearl Standard Integration Run and Mappings
      • Shipstation
          • Shipstation Integrations
          • ShipStation Classic Integration
          • ShipStation Pick Pack Integration
      • Order Manager
          • Installing Warehouse Manager Order Manager Integration
          • Integrating Warehouse Manager and Order Manager
          • Understanding Order Sync in Warehouse Manager and Order Manager integration
          • Understanding the Inventory Sync between Warehouse Manager and Order Manager
      • ShippingEasy
          • Integration Details
          • Integration Installation ShippingEasy
        • Integration Manager
        • Warehouse Manager Premium Integration Package FAQs
    • Barcoding
      • Barcoding 101
          • What is a Barcode?
          • Barcode Types
      • Label Printing
          • Label Printer Hardware
          • Selecting Barcode Label Media
          • How to Configure Zebra WiFi Printer
          • Setting up your label printer
      • Printing Labels in Warehouse Manager
          • Label Templates
          • Printing In The Mobile App
          • Google Chrome Printing Addon
    • Wave Picking
      • Wave Pick Information
          • What is Wave Picking
          • Wave Pick Modes
          • Navigating Wave Picking
      • Creating Waves
          • Create Waves Section
          • Creating a Single Wave
          • Creating an Advanced wave
      • Other Wave Pick Functions
          • Pick Carts and Pick Totes
          • Wave Picking on Mobile
          • Wave Automation
          • WavePickScanTote Setting
    • Bin Move
        • Asset Move
        • Inventory Move
        • Child Bin Move
        • Mass Bin Move
    • Mobile Receiving and Picking
        • Receiving in Mobile
        • Picking in Mobile
        • Packing in Mobile
        • Shipping in Mobile
    • Settings
        • Overview
        • API Settings
        • Bin Types
        • Document Files
        • Document Templates
        • Event Actions
        • Label Config
        • Label Printers
        • Message Recipients
        • My Account
        • Order Settings
        • Pick Path
        • PO Payment Settings
        • Reason Codes
        • Shipping Accounts
        • Shipping Types
        • Tags
        • Transaction Codes
        • Users
        • Work Order Statuses
        • Work Order Types
    • Popular Articles
        • Step 1: Setting Up a User
        • How to Configure Zebra WiFi Printer
        • Inventory Move
        • Asset Move
        • Step 4: Setting Up Your Inventory
        • Label Templates
        • Network Connection Troubleshooting
        • Step 3: Setting Up Part Records
        • Label Printers
        • Barcode Types
    • Reporting
        • Reporting in Warehouse Manager
      • Submitting a Support Case
      • Document Printing
      • Un-Picking Sales Orders
      • Understanding Replenishments
      • Returns Management
      • Creating Vendors
      • Work Orders

Reporting in Warehouse Manager

Overview

This article explores the Warehouse Manager (WM) Reporting feature and to know more about the creation and editing of different kinds of reports.

WM gathers and displays data. They can be used in many ways, and if the data resides in WM, a report can usually be made from it. The only limiting factor is getting the information you want to display the way you want it. Customers can create and edit their own reports, and custom reports can be made by Professional Services for a fee. WM uses a third-party program called Izenda for its reporting. For further information on Izenda reports, please look here: https://wiki.izenda.us/Guides/ReportDesign.

 
 

Reporting Processes

The following explains the different processes involved in using the Report function in Warehouse Manager.

How to access reports

From the Warehouse Manager Unlimited Console, click on Reports located at the top navigation bar. 


 

It will bring you to the Reports page, and from here you can create or edit a report. 

A screenshot of a computer

Description automatically generated
 

 
 

Pulling up a Report

You can click on the report tile.

A screenshot of a computer screen

Description automatically generated with low confidence

Or you can use the search bar

A picture containing text, screenshot, font, number

Description automatically generated
 

In the example above, the ‘Item All By Part’ is pulled from the selection and you will proceed to the Report edit page.

A screenshot of a computer

Description automatically generated with medium confidence

 
 

Creating a Report

To create a report, click the Add New dropdown and select New Report. 

A screenshot of a computer

Description automatically generated with low confidence
 

When you think of the report you want, check the existing reports to see if it’s a default one, or can easily be edited from a default one.

 

The first page you are taken to is the “Data Sources” page. This will be one of the most troublesome areas to work with as it may not be clear what data sources you need, and how to connect them.

A screenshot of a computer

Description automatically generated with medium confidence

This is the simple Data Sources view, which allows you to know what sources link together. For our example, we want parts and orders, which in this case correspond to parts and documents. Think of data sources as where your data will reside in WM.

If you click on Documents, you will see sources grayed out, these cannot be linked to the Documents data source:

A screenshot of a computer

Description automatically generated with medium confidence

Click the Continue to Fields button 

A screenshot of a computer

Description automatically generated with medium confidence

This will be the main tab you use to build your report. In our example report, we want the part number and the order number, click the dropdown under the ‘Field’ column: 

A screenshot of a computer

Description automatically generated with medium confidence

You will notice that while the ‘DocNumber’ (which is the order number) is available, there seems to be no option for the part number. That is because the part number does not reside under the Documents data source, and we will need to find and add the needed data source.

If you go back to the data source tab, the option for ‘Part’ is grayed out, which means it does not connect to the Documents source. In this case, we will want to add the “Document Lines” data source.

A screenshot of a computer

Description automatically generated with medium confidence

You will notice you can now select the ‘Parts’ source, however, we will not do that unless needed, as data sources should not be added unless you need them.

Back to the fields, and again selecting the drop-down under the ‘Field’ column now provides us with more information: 

A screenshot of a computer

Description automatically generated

We can now build our report. 

A screenshot of a computer

Description automatically generated

We can now click on the Preview to preview what the report looks like currently: 

A screenshot of a computer

Description automatically generated

One thing to consider is what if you have a part that is not on any orders? It will not show in this report.

If you go back to the Data Sources tab, you can check the ‘Allow nulls’ checkbox: 

A screenshot of a computer

Description automatically generated with medium confidence

The last tab we will look at during this report creation is the ‘Filters’ tab, this tab allows you to set filters on the information you want to see: 

A screenshot of a computer

Description automatically generated

In this example, let’s say we only want to see orders that have not been shipped, to see what orders we currently have for our parts, click on the ‘Filter Field’ dropdown, and you will be able to select the same fields as from the ‘Fields’ tab to place filters on them: 

A screenshot of a computer

Description automatically generated with medium confidence

A screenshot of a computer

Description automatically generated with medium confidence

We’ve added a filter for the document status and chosen ‘Doesn’t Equal Multiple’ so we can select multiple statuses we don’t want to show.  

Click Preview, and this is how our report looks now: 

A screenshot of a computer

Description automatically generated

Save your report by clicking the Save or Save As button 

A screenshot of a computer

Description automatically generated with medium confidence

 
 

Editing a Report

Now that you have a report created, you can edit it to change or add information. We will continue to use the Parts/Orders report that was created in the previous step.  

In the report you want to edit, click the Pencil icon near the top to edit the report: 

A screenshot of a computer

Description automatically generated with medium confidence

Navigating the tabs will be the same as during creation. In this example, we will want to update the report to sort by part number and add the status to the report: 

A screenshot of a computer

Description automatically generated

We can still preview our changes: 

A screenshot of a computer

Description automatically generated
 

Click Save or Save As when done.

 
 
 
 

Advanced Features

We will go over a few features that can improve your report.

Visually Grouping

A screenshot of a computer

Description automatically generated with medium confidence

This results in this report, which visually groups the parts: 

A screenshot of a computer

Description automatically generated

You can choose to visually group more than one column: 

A screenshot of a computer

Description automatically generated with medium confidence

Which results in this report: 

A screenshot of a computer

Description automatically generated

 
 

Summary

The report summary will be at the top of the report and can be used to summarize information on the report itself.

Note, We have now added the QTY on the order to the report: 

A screenshot of a computer

Description automatically generated with medium confidence

To add a summary, click the Summary tab: 

A screenshot of a computer

Description automatically generated with medium confidence

In this summary example, I want a summary of my parts and the number of orders they are currently on:

A screenshot of a computer

Description automatically generated with medium confidence

 
 

Functions

Note the function dropdown, where we have selected ‘Count Distinct to count the distinct number of orders the part is on. Functions will not be covered in this guide but can be used to count, sum, group, average, and further manipulate data.

This results in this report: 

A screenshot of a computer

Description automatically generated with medium confidence

 
 

Charts

From the example above, click on Continue to Chart, and clicking Preview will result in this: 

A screenshot of a computer

Description automatically generated with medium confidence

A screenshot of a computer

Description automatically generated with medium confidence

 
 

Highlighting

In the ‘Fields’ tab, you can click on the gear icon next to a field to access advanced features: 

A screenshot of a computer

Description automatically generated
 

In this example, I will highlight orders that are in an ‘OPEN’ status with green, and orders that are in ‘PICKED INCOMPLETE’ with red: 

A screenshot of a computer

Description automatically generated with medium confidence

Then the result would be: 

A screenshot of a computer

Description automatically generated with medium confidence

 
 

Filter Logic

In this example, we will only want to show orders that have more than five of a part on them: 

A screenshot of a computer

Description automatically generated with medium confidence

Which results in: 

A screenshot of a computer

Description automatically generated with medium confidence

 
 
 
 

 

 

management reporting inventory tracking

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • Document Printing
  • Understanding Replenishments
  • Submitting a Support Case
  • Un-Picking Sales Orders

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