3PL Warehouse Manager

Updated on July 27th, 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

Transactions Reports

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

Transaction Register

The Transaction Register Report is the most comprehensive warehouse report. It is a summary of all activity by customer for a specific date range. The report includes transaction highlights and warehouse charges and can be used for period billing or invoice back-up. You can drill down to view the transaction details and click on UPS tracking numbers to confirm package receipts.

  1. Click Transaction Register from the list of Transactions reports.
  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 the relevant Start Date and End Date.
  4. Specify whether you want to generate a Detailed, Summary, or Daily Ship List report.
  5. Click Run Report.

The detailed report generates with the following columns:

  • Name: Name of customer
  • Date: Date transaction was created
  • ShipDate: Date transaction was shipped and closed
  • Trans #: Relevant transaction number
  • CustomerRef: Reference number recorded on the transaction
  • Tracking #: Tracking number recorded on the transaction
  • QtyIn: Number of primary units received in
  • QtyOut: Number of primary units shipped out
  • Handling: Handling rate charged—based on fees configured under Billing Wizard > System-Calculated Storage and Handling Charge Setup
  • Auto Handling: Handling rate charged—based on fees configured under Billing Wizard > Per Transaction Billing Setup
  • Materials: Rate charged for materials—based on manual fees configured under Billing Wizard > Per Transaction Billing Setup
  • Storage: Storage rate charged—based on fees configured under Billing Wizard > System-Calculated Storage and Handling Charge Setup
  • Auto Storage: Storage rate charged—based on fees configured under Billing Wizard > Per Transaction Billing Setup
  • Special: Rate charged for special charges—based on manual fees configured under Billing Wizard > Per Transaction Billing Setup
  • Freight PP: Rate charged for freight prepaid
  • Freight3: Freight charge that is owed
  • Total: Total charges on the transaction
  • Notes: Warehouse Instructions recorded on a transaction
  • Paperclip icon: Indicates if files were attached to the transaction

The summary report generates with the following unique columns:

  • Customer / Warehouse: Relevant customer and warehouse name

Transaction by Activity

The Transaction by Activity Report is similar to the Transaction Register Report but allows you to include specific transactions, such as orders, receipts, returns, etc.

  1. Click Transaction by Activity from the list of Transactions reports.
  2. Select the relevant Customer Name and Warehouse from the grid. To select multiple customers, use < Ctrl > on your keyboard to multi-select.
  3. Specify the relevant transaction type to include in the report: Orders, Receivers, Returns, Assemblies, or Adjustments.
  4. Select the relevant Start Date and End Date.
  5. Specify whether you want to sort the data by Transaction #, BOL #, PO #, or Carrier.
  6. By default, 'Sort In Ascending Order' is checked. To sort the report by descending order, de-select the selection box.
  7. Click Run Report.

The report generates with the following columns:

  • Trans#: Relevant transaction number
  • Ref #: Reference number recorded on the transaction
  • BOL#: Associated Bill of Lading number
  • PO NUM: Purchase order number recorded on the transaction
  • Carrier: Shipping carrier recorded on the transaction
  • SKU: Primary identifier of an item
  • Qualifier: Relevant item qualifier
  • Description: Description of item
  • Qty Rcv/Ord: Number of primary units received/ordered
  • 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
  • Packed per Dim UoM: Number of primary units per packaging unit
  • Total Qty Dim UoM: Total number of packaging units
  • Dim Unit of Measure: Packaging unit of measure

View Transaction

The View Transaction Report is a comprehensive report of a single transaction.

  1. Click View Transaction.
  2. Enter a transaction identifier: Transaction #, Reference #, or PO #.
  3. Specify whether you wish to 'Show Packages' or 'Show Billing Details' on the report.
  4. Click Run Report.

The report contains basic transactional data, including billing charges, carrier information, ship-to information, package details, and the following fields:

  • Warehouse Instructions: Warehouse Instructions entered on a transaction to display on a pick ticket
  • Carrier Instructions: Carrier Instructions entered on a transaction to display on a packing slip and/or Bill of Lading

Transaction by Line Item

The Transaction by Line Item Report lists all line items for closed transactions that occurred within a specified time period.

  1. Click Transaction by Line Item.
  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 the relevant Start Date and End Date.
  4. Click the 'Show Retailer' selection box to add an additional Retailer column to the report.
  5. Specify whether you want to generate a Transaction by Line Item Report, Transaction Weekly Shipping Report, or Outbound Orders by Load Report.
  6. Click Run Report.

The Trans by Line Item Report generates with the following columns:

  • Name: Name of customer
  • ShipDate: Date transaction was shipped and closed
  • CustomerRef: Reference number recorded on the transaction
  • Carrier: Shipping carrier recorded on the transaction
  • PO #: Purchase order number recorded on the transaction
  • Trans #: Relevant transaction number
  • SKU: Primary identifier of an item
  • Lot #: Lot number recorded on an item
  • Qty: Number of primary units
  • Tracking #: Tracking number recorded on the transaction
  • Freight3: Freight charge that is owed
  • Service: Shipping service recorded on the transaction
  • ExpDate: Expiration date recorded on an item
  • Serial #: Serial number recorded on an item

The Shipping Report generates with the following unique columns:

  • ShipTo: Name of ship-to contact recorded on the transaction
  • UOM: Primary unit of measure
  • DIM Qty: Number of secondary units on the transaction
  • Cost per Unit: Cost per primary unit
  • Total Cost: Total cost calculated for all primary units on the transaction

Shipment Value

The Shipment Value Report is an invoice that calculates the value of a shipment by multiplying item price by quantity.

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

The report generates with the following columns:

  • Item Number: Identification number assigned to an item
  • Description: Description of an item
  • Quantity: Number of primary units
  • UOM: Primary unit of measure
  • Price Each: Product cost per primary unit
  • Amount: Total shipment rate, calculated by multiplying Price Each and Quantity

Open Orders

The Open Orders Report lists all orders currently in the warehouse and being processed (in an Open or Complete status). This report can be used for ensuring orders are properly confirmed and billed.

 

  1. Click Open Orders.
  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 the relevant Start Date and End Date.
  4. Specify whether you want to filter by a specific date: Creation Date, ASN Sent Date, Pickup Date.
  5. Click Run Report.

The report generates with the following columns:

  • Customer Name: Name of customer
  • Entered Date: Date order was created
  • Trans #: Relevant transaction number
  • Ref #: Reference number recorded on the order
  • PO #: Purchase order number recorded on the order
  • Carrier: Shipping carrier recorded on the order
  • Ship To: Ship-to destination recorded on the order
  • Earliest Ship Date: Earliest Ship Date recorded on the order
  • Cancel Date: Ship Cancel Date recorded on the order
  • Pickup Date: Expected Pickup Date / Time recorded on the order
  • Notes: Warehouse Instructions recorded on the order
  • Is Under Allocated: Indicates whether the order has overallocated (unavailable) inventory
  • Retailer: Retailer ID recorded on the order
  • Stage: Indicates whether an order is marked as Complete

Open Receipts

The Open Receipts Report is similar to the Open Orders Report above but is used for receipts that have come in the warehouse and have yet to be confirmed and billed (in an Open or Complete status).

  1. Click Open Receipts.
  2. Select the relevant Customer Name and Warehouse 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:

  • Customer Name: Name of customer
  • Entered Date: Date receipt was created
  • Trans #: Relevant transaction number
  • Ref #: Reference number recorded on the receipt
  • PO #: Purchase order number recorded on the receipt
  • Carrier: Shipping carrier recorded on the receipt
  • Notes: Notes recorded on the receipt

Open Assemblies

The Open Assemblies Report is similar to the Open Orders Report above but is used specifically for assembly transactions.

  1. Click Open Assemblies.
  2. Select the relevant Customer Name and Warehouse 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:

  • Customer Name: Name of customer
  • Entered Date: Date transaction was created
  • Trans #: Relevant transaction number
  • Ref #: Reference number recorded on the assembly
  • PO #: Purchase order number recorded on the assembly
  • Carrier: Shipping carrier recorded on the assembly
  • Notes: Notes recorded on the assembly

Overage/Shortage & Damaged

The Overage/Shortage & Damaged (also known as OS&D) Report allows you to view any discrepancies between the expected and actual quantities of received items.

  1. Click Overage/Shortage & Damaged.
  2. Enter a transaction identifier: Transaction # or Reference #.
  3. Click Run Report.

The report generates with the following columns:

  • SKU: Primary identifier of an item
  • Qualifier: Relevant item qualifier
  • Lot#: Lot number recorded on an item
  • Serial#: Serial number recorded on an item
  • ExpDate: Expiration date recorded on an item
  • Supplier: Supplier contact recorded on an item
  • Cost: Landed cost recorded on an item
  • MovUnit: Unique MU license plate assigned to an item
  • Location: Warehouse location assigned to an item
  • Inv Qty: Actual quantity of received items
  • Exp Qty: Expected quantity of received items
  • Variance: Difference between Inv Qty and Exp Qty
  • Inv UOM: Primary unit of measure

Transfer Activity

The Transfer Activity Report allows you to view any transfer activity that has taken place in your warehouse within a certain timeframe.

  1. Select a Customer from the drop-down menu.
  2. Select a relevant Start Date and End Date.
  3. Click Run Report. A PDF file opens in a new tab of your browser.

The report generates with the following columns:

  • Transfer Date: Date transfer occurred
  • Source Owner / Destination Owner: Names of the original customer and the customer to which the item was transferred
  • Source Item# / Destination Item#: Names of the original SKU and the name of the SKU under the new customer
  • Source Item Description / Destination Item Description: Original item description and the item description under the new customer
  • Source Lot Number / Destination Lot Number: Original lot number and the lot number under the new customer
  • Source Qty / Destination Qty: Original item quantity and the item quantity under the new customer
  • Source Location / Destination Location: Original location of the item and the location of the item under the new customer
  • Source License Plate / Destination License Plate: Original MU label and the MU label under the new customer

Extensiv University

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

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • Managing Pricing
  • Sending an ASN
  • January 7, 2020 – Minor Release Notes
  • Setting Up Barcodes

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