3PL Warehouse Manager

Updated on October 8th, 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
  • 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

Management Reports

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

Inventory Turns

The Inventory Turns Report shows the number of times the inventory has turned within a given time period. While there are several different options for generating this report, the steps below review the process for generating a Turns Report.

  1. Click Inventory Turns.
  2. Specify whether you want to generate a Turns Report, Inactive Items Report, or Inventory Detail with Aging report. The fields you need to enter vary with each option.
  3. Select the relevant Customer Name and Warehouse from the grid. To select multiple customers, use < Ctrl > on your keyboard to multi-select.
  4. Specify whether you want to generate a Facility Summary, Facility Detailed, Customer Summary, or Customer Detailed.

    Please note that choosing Facility Summary ignores any Customer selection(s). To see selected customers, choose Facility Detailed.

     
  5. Specify if you want to 'Show Inactive' items.
  6. Enter a relevant Start Date and End Date, then click Run Report.

The Turns Report generates with the following columns:

  • Facility: Name of warehouse
  • Customer: Name of customer
  • SKU: Primary identifier of an item
  • Qualifier: Relevant item qualifier
  • Turns: Number of times the inventory turned during the dates selected
  • Volume: Number of packaging units shipped out
  • Ave Inv. Lvl: Average number of packaging units available during the dates selected
  • Begin Inv: Number of packaging units available for allocation on the Start Date
  • Ending Inv: Number of packaging units available for allocation on the End Date

The Inactive Items Report generates with the following unique columns:

  • Inv. Balance: Current inventory level
  • Last Shipment: Details of the last order that deducted inventory from the warehouse
  • Last Receiver: Details of the last receipt that added inventory to the warehouse

The Inventory Detail with Aging generates with the following unique columns:

  • Part/SKU: Primary identifier of an item
  • Item: Description of an item
  • On_Hand: Number of primary units currently in the warehouse
  • Available: Number of primary units available for allocation
  • Allocated: Number of primary units currently allocated to Open and Complete orders
  • Aging: Number of days the SKU has been in the warehouse

Stock Status by Anniversary

The Stock Status by Anniversary Report shows the stock status of receipts according to an interval period or date range.

  1. Click Stock Status by Anniversary.
  2. Select the relevant Customer Name and Warehouse from the grid. To select multiple customers, use < Ctrl > on your keyboard to multi-select.
  3. Select a Start Date and End Date.
  4. Enter the Number of Cycle Days and Free Days.
  5. Specify whether you want to show items that are Confirmed, Unconfirmed, or Show All.
  6. To display each SKU individually, specify to 'Select Individual Items'.
  7. Click Run Report.

The report generates with the following columns:

  • Evt Date: Date report was generated
  • Rcv Date: Date items were received
  • SKU: Primary identifier of an item
  • Description: Description of an item
  • Inv Qty: Number of primary units available for allocation
  • Inv UOM: Primary unit of measure
  • Dim Qty: Number of packaging units available for allocation
  • Dim UOM: Packaging unit of measure
  • Var Qty: Number of secondary units available for allocation
  • Var UOM: Secondary unit of measure
  • Lbs/Kgs: Total default weight of primary units measured in Imperial or Metric
  • Cu Ft: Total default volume of primary units measured in cubic feet
  • Location: Current warehouse location
  • Days Since Receipt: Number of days since the SKU was last received

Customer Pricing

The Customer Pricing Report shows the current pricing being used in the Billing Wizard.

  1. Click Customer Pricing.
  2. Select the relevant Customer Name from the grid. To select multiple customers, use < Ctrl > on your keyboard to multi-select.
  3. Click Run Report.

The report generates with the following columns:

  • Transaction: Type of transaction the billing event was triggered by
  • Billing Field: Category of the charge set up in the per transaction billing setup
  • Unit Description: Billing unit
  • Charge Per Unit: Amount charged per unit description
  • Charge Label: Name of the charge entered for the billing unit
  • Notes: Billing notes recorded on billing event

User List

The User List Report shows a list of both Warehouse and Customer Users, as well as their current security levels.

Click User List, then Run Report. The report lists the User's Name, Login name, and Role for both your company’s users and your customers’ users.

Transaction Review

The Transaction Review Report reviews the history of a specific transaction.

  1. Click Transaction Review.
  2. Enter a transaction identifier: Transaction # or Reference #.
  3. Click Run Report.

The report generates with the following columns:

  • Altered Date: Date transaction was modified
  • Login: Name of user who modified transaction
  • Column Name: Field that was modified
  • Before Value: Original value before the modification was made
  • After Value: New value of modified field

Freight Audit

The Freight Audit Report allows you to review freight history by customer to determine whether charges were correctly applied to prepaid freight.

  1. Click Freight Audit.
  2. Select the relevant Customer Name and Facility from the grid. To select multiple customers, use < Ctrl > on your keyboard to multi-select.
  3. Select a relevant Start Date and End Date.
  4. Click Run Report.

Cycle Count

The Cycle Count Report shows the items to be cycle counted within a specific time period.

  1. Click Cycle Count.
  2. Select the relevant Customer Name from the grid. To select multiple customers, use < Ctrl > on your keyboard to multi-select.
  3. Select a relevant Start Date and End Date.
  4. Click Run Report.

The report generates with the following columns:

  • Customer Name: Name of customer
  • SKU: Primary identifier of an item
  • Description: Description of item
  • Creation Date: Date item was created
  • Cycle Count: Number of days between recommended physical inventory counts for a SKU
  • Date of Next Count: Recommended date of next cycle count

UPS Daily Summaries

The UPS Daily Summaries Report shows a daily summary of UPS transactions.

  1. Click UPS Daily Summaries.
  2. Select a relevant Warehouse and Summary Date.
  3. Click Run Report.

Package Usage

The Package Usage Report shows the packages used for orders within a specified timeframe.

  1. Click Package Usage.
  2. Select the relevant Customer Name and Facility from the grid. To select multiple customers, use < Ctrl > on your keyboard to multi-select.
  3. Select a relevant Start Date and End Date.
  4. Click Run Report.

The report generates with the following columns:

  • Reference #: Reference number recorded on the transaction
  • Trans#: Relevant transaction number
  • ShipDate: Date transaction was shipped and closed
  • Customer: Name of customer
  • ShipTo: Name of ship-to contact recorded on the transaction
  • Code: Relevant ship-to contact code
  • Description: Description of an item
  • Length: Length of package
  • Width: Width of package
  • Height: Height of package
  • Weight: Weight of package

Small Parcel Transactions

The Small Parcel Transactions Report allows you to view monthly small parcel activity.

Click Small Parcel Transactions, then click Run Report. The report will list each customer's total costs in small parcel activity.

Extensiv University

Gain deeper insights and learn more about 3PL Warehouse Manager with our online course at Extensiv University.
reporting organizing

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • March 30, 2020 – Minor Release Notes
  • Ecommerce Pick/Pack Workflow
  • Shipping with UPS
  • April 6, 2020 – Minor Release Notes

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