Lightspeed Reporting

From LightSpeed Help Guide
Revision as of 15:30, 2 July 2015 by Lightspeed (Talk | contribs) (Product Picked by Date Range)

Jump to: navigation, search

Return To | Guides Home | Lightspeed Admin

Current Status

The Current Status tab shows much of the information that is displayed on the Target Timer.

  • Routes Selected
  • Start Time
  • Estimated Completed Time
  • Estimated Time to Complete
  • Items Remaining

Product Totals by Days

To run the Product Totals by Days report the following selections must be made:

  • Order Date
  • Picking Zone
  • Rounding Threshold (100% = no rounding)


    • Picture


The Product Totals by Days report shows the total amount of each product that is required to fill all orders that have been downloaded into the Lightspeed database.
The report is organized by location mapping throughout the Lightspeed line. All products show the total eaches as well as the breakdown of cases and singles.

Product List

To run the Product List report, select the Picking Zone to be displayed.

    • Picture

This report displays all products in sequence as they appear in the Lightspeed FastTrack or Mobile mapping.

Eight Week Product Report

The Eight Week Product Report can be generated by selecting the ending date of an eight week period.


    • Picture


The report displays all products picked week by week. The products are displayed by product category and ordered alphabetically. Each product shows the total picked and returned through the Lightspeed system.

Changed Product

To run the Changed Product Report select the Order Date to be viewed

    • Picture


The Product Change report shows all products that were overridden to another product for the given day in the Lightspeed system.
Each product is shown with the corresponding route, customer, location, and pos where these changes took place.

Product with Changed Quantity

To run the Changed Quantity report select the following values:

  • Order Date
  • Picking Zone - All Zones or Single Zone
  • Route - All Routes or Single Route


    • Picture


This report organizes each product by route that had any variance between the order quantity and the pick quantity.
Each product has a corresponding customer and location while displaying the cases and singles ordered as well as the cases and singles picked.

Product with Zero Quantity

The Product with Zero Quantity report uses a date range to show all products that were zeroed out during the picking process.
Select the Order Date range to run this report.


    • Picture


This report show each product along with the number of orders that were zeroed during picking as well as the Row/Coil count for each product and the total quantity zeroed for each product.

FastTrack Route Cost Summary

The FastTrack Route Cost Summary report displays the price break down for a selected date range by zone using the following inputs

  • Starting Order Date
  • Ending Order Date
  • Number of employees in the Picking Zone
  • Average Hourly Rate

The Cost Summary breaks down all costs down to the cost per unit being picked from the selected Lightspeed Pick Zone

Route Summary by Zone

The Lightspeed Automation 'Route Summary by Zone' allows the operator to view all products and progress in a given zone for any needed order date or date period.
By selecting the date range on the selection calendars and the needed zone the following information will be displayed:

  • Route Description
  • Start Time
  • End Time - If completed
  • Time Picking - Total time spent actively picking the individual route
  • Number of Distinct
  • Customers
  • Locations
  • Machines
  • Totes
  • Ordered Quantity
  • Singles
  • Cases
  • Picked Quantity
  • Singles
  • Cases
  • No Light Quantity
  • Singles
  • Cases
  • Each Picked Per
  • Machine
  • Hour
  • Tote

Route Detail by Zone

The 'Route Detail by Zone' report displays all Lightspeed orders as a pick list with all ordered products and quantities as well as picked quantities if completed. If 'Show All Zones' are selected each order will display the entire order separated by individual zone orders.
Order specific information includes:

  • Customer Description
  • Machine Description
  • Machine Code

The Lightspeed system adds the following information to allow for accountability and tracking:

  • Start Time
  • Completed Time
  • Tickets Printed
  • Pick Date
  • Employee Assigned to picked product - If tracking activated
  • Confirmed Pick Quantities - Singles and Cases

Tote Summary by Route

The 'Tote Summary by Route' report allows the operator to print a single report to show all totes that were packed for a given route.

  • To display the Tote Summary by Route report select the needed 'Order Date' from the Lightspeed Calendar

Lightspeed displays the following information for accountability and tracking:

  • Customer Description
  • Machine Description
  • Machine Number
  • Number of Totes

Tote per route will be shown per route as well as per zone inside of the displayed route

Eight Week Product Report

The Eight Week Product Report displays all product totals that have been picked through the Lightspeed system over the eight weeks prior to the selected date.
All items will be organized by product category received from the connected order provider. The information displayed will include:

  • Product Category
  • Product Description
  • Weekly Totals
  • Picked
  • Bring Backs
  • Net Total

Product Totals by Route

An operator may run the Product Totals by Route report to display a breakdown of product usage for a given day per route. To run select the needed order date. All routes will be displayed per page.
Information included in the report includes:

  • Route Description
  • Product Description
  • Product Code
  • Ordered Singles
  • Picked Singles
  • Ordered Cases
  • Picked Cases

Product Ranking by Zone

The Product Ranking by Zone report gives the operator the ability to view the highest and lowest moving items in a given zone. All totals are calculated by Lightspeed pick totals over a selected amount of time.
To view the Product Ranking Report complete the following

  1. Select the needed Lightspeed pick zone
  2. Select the number of days history to pull
  3. Show Top
    • This selection will adjust the amount of products with the highest warehouse movement
  4. Show Bottom
    • This selection will adjust the amount of products with the lowest warehouse movement
  5. Select 'Run Report'

The report will be broken down into Top Products and Bottom products using the amount specified.
Lightspeed will display the following information for inspection

  • Product Description
  • Lightspeed Mapping Location
  • Total Quantity pick over the entered timeframe

Product Picked by Date Range

The Product Picked by Date Range report allow the operator to select various options to see the total amount of product ordered and picked through the Lightspeed pick system over a selected period of time.
To view the report complete the following:

  1. Select a Starting Order Date
  2. Select an Ending Order Date
  3. Select the desired Lightspeed pick zone
    • Select 'All Zones' to view all items in the warehouse
  4. Select the needed Route(s)
    • Using Ctrl+Left Click the operator can select multiple routes
    • Select 'All Routes' to view all
  5. Select the product category to be viewed
    • Select 'All Categories' to view all

The Lightspeed report will break down the resulting data using the following:

  • Product Picking Zone
  • Product Category
  • Product Description
  • Product Code
  • Total Ordered
  • Total Picked
  • Singles Picked
  • Cases Picked

Product Returns by Route

Employee Picks by Zone

Employee Time - Hourly Summary

Employee Time by Zone/Route

Employee Time by Date

Full Page Pick Sheets

Full page pick sheets can be automatically printed at the completion of each Lightspeed order. To print pick sheets through the administrator page select the following:

  1. Order Date for all needed orders
  2. Needed Route
  3. Select 'Run Report' to generate all pick sheets

All pick sheets will be displayed as an individual page

  • All sheets can be exported or printed via the Lightspeed Administrator page

Products Without Lights

The products without lights report uses a selected range of order dates to show all items that were included in a Lightspeed order that were not assigned to a light in the Lightspeed FastTrack zone
To run the Products Without Lights report complete the following:

  1. Using the calendars select a 'Starting Date' and 'Ending Date' for Lightspeed to display
    • All dates use the Order Date for selection
  2. Select 'Run Report' to process request

All products shown will use the following for description

  • Product Category
  • Product Code
  • Product Description

Unmapped Products

The unmapped product report shows all items that are in a product category that is assigned to a given zone which are not mapped to a product location or light number. To run the unmapped product report complete the following:

  1. Select the Lightspeed Pick zone
  2. Confirm 'Continue'

The unmapped report displays all products using the following

  • Product Code
  • Product Description
  • Product Category