Lightspeed Reporting

From LightSpeed Help Guide
Revision as of 16:17, 1 July 2015 by Lightspeed (Talk | contribs) (FastTrack Route Cost Summary)

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

Route Detail by Zone

Tote Summary by Route

Eight Week Product Report

Product Totals by Route

Product Ranking by Zone

Product Picked by Date Range

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