Ribbon Bar / Launch HTML5 / Launch KPI

Various reports are available to measure a Picker’s efficiency. Refer to the below list.

If you don’t like reading, you can watch the video.

None

Try it!

Picker Statistics Sales Order & SCTs

This report will give you an overview of the pickers lines and QTYs per picker for Sales Orders and SCTs for a specific date range.

Report example

SQL Script

declare @FromDate Date 
declare @ToDate	Date 
set @FromDate= '2018-01-01'
set @ToDate = '2018-09-01'


SELECT [Owner],SUM(QtyPicked)AS [Total Quantity Picked],SUM(MassPicked) AS [Total Mass Picked],COUNT(*) LinesPicked,
                    (CASE 0 WHEN 0 THEN 0 ELSE (SUM(MassPicked)/CONVERT(DECIMAL,0)) END + CASE 0 WHEN 0 THEN 0 ELSE (COUNT(*)/CONVERT(DECIMAL,0)) END)/1*100/(DateDiff(DAY, @FromDate, @ToDate)+1) AS [Weighted Ave],
                    COUNT(DISTINCT(PickingSlipNumber))AS [Completed Picking Slips]
                        
						FROM
						(SELECT PSI.[Owner],LU.OperatorName,PS.PickingSlipNumber,SourceNumber AS SalesOrder,CustomerName,CustomerPO,InvoiceNumber,StartTime,EndTime,
                                             PSI.StockCode,Qty AS PickingSlipQty,SUM(ISNULL(PR.QtyOrdered,PRA.QtyOrdered)) AS QtyOrdered,SUM(ISNULL(PR.QtyPicked,
                                             PRA.QtyPicked)) AS QtyPicked,(SUM(ISNULL(PR.QtyPicked,PRA.QtyPicked))*IM.Mass) AS MassPicked
                                      FROM tblPickingSlip PS WITH (NOLOCK)
                                             INNER JOIN tblPickingSlipSource PSS WITH (NOLOCK)
                                             ON PS.PickingSlipNumber=PSS.PickingSlipNumber
                                                   INNER JOIN tblPickingSlipItem PSI WITH (NOLOCK)
                                                   ON PSS.PickingSlipSourceNumber=PSI.PickingSlipSourceNumber
                                                          LEFT JOIN tblPalletReservedArchive PRA WITH (NOLOCK)
                                                          ON PSI.ItemNumber=PRA.PickingItemNumber
                                                                 LEFT JOIN tblPalletReserved PR WITH (NOLOCK)
                                                                 ON PSI.ItemNumber=PR.PickingItemNumber
                                                                        LEFT JOIN SysproCompanyTest.dbo.InvMaster IM WITH (NOLOCK)
                                                                        ON PSI.StockCode=IM.StockCode 
                                                        LEFT JOIN Warehouse_Control.dbo.tblLicensedUsers LU WITH (NOLOCK)
                                                                                                ON PSI.Owner = LU.UserName
                        WHERE   ISNULL(PRA.Skipped,0)='0' and SourceType='DISP'
              
							   AND [Owner] IS NOT NULL
                               AND EndTime IS NOT NULL
                               AND CONVERT(DATETIME,[EndTime],111)>= @FromDate
                               AND CONVERT(DATETIME,[EndTime],111) < @ToDate
                        GROUP BY PSI.Owner, LU.OperatorName, PS.PickingSlipNumber,SourceNumber,PSS.CustomerName,StartTime,
                            EndTime,PSI.StockCode,PSI.Qty,IM.Mass,PSS.CustomerPO,InvoiceNumber
							) as A

    GROUP BY [Owner],OperatorName
    ORDER BY [Owner]

Picker Statistics Jobs

This report will give you an overview of the pickers lines and QTYs per picker for Jobs for a specific date range.

Report example

SQL Script

declare @FromDate Date 
declare @ToDate	Date 
set @FromDate= '2018-01-01'
set @ToDate = '2018-09-01'


SELECT [Owner],SUM(QtyPicked)AS [Total Quantity Picked],SUM(MassPicked) AS [Total Mass Picked],COUNT(*) LinesPicked,
                    (CASE 0 WHEN 0 THEN 0 ELSE (SUM(MassPicked)/CONVERT(DECIMAL,0)) END + CASE 0 WHEN 0 THEN 0 ELSE (COUNT(*)/CONVERT(DECIMAL,0)) END)/1*100/(DateDiff(DAY, @FromDate, @ToDate)+1) AS [Weighted Ave],
                    COUNT(DISTINCT(PickingSlipNumber))AS [Completed Picking Slips]
                        
						FROM
						(SELECT PSI.[Owner],LU.OperatorName,PS.PickingSlipNumber,SourceNumber AS SalesOrder,CustomerName,CustomerPO,InvoiceNumber,StartTime,EndTime,
                                             PSI.StockCode,Qty AS PickingSlipQty,SUM(ISNULL(PR.QtyOrdered,PRA.QtyOrdered)) AS QtyOrdered,SUM(ISNULL(PR.QtyPicked,
                                             PRA.QtyPicked)) AS QtyPicked,(SUM(ISNULL(PR.QtyPicked,PRA.QtyPicked))*IM.Mass) AS MassPicked
                                      FROM tblPickingSlip PS WITH (NOLOCK)
                                             INNER JOIN tblPickingSlipSource PSS WITH (NOLOCK)
                                             ON PS.PickingSlipNumber=PSS.PickingSlipNumber
                                                   INNER JOIN tblPickingSlipItem PSI WITH (NOLOCK)
                                                   ON PSS.PickingSlipSourceNumber=PSI.PickingSlipSourceNumber
                                                          LEFT JOIN tblPalletReservedArchive PRA WITH (NOLOCK)
                                                          ON PSI.ItemNumber=PRA.PickingItemNumber
                                                                 LEFT JOIN tblPalletReserved PR WITH (NOLOCK)
                                                                 ON PSI.ItemNumber=PR.PickingItemNumber
                                                                        LEFT JOIN SysproCompanyTest.dbo.InvMaster IM WITH (NOLOCK)
                                                                        ON PSI.StockCode=IM.StockCode 
                                                        LEFT JOIN Warehouse_Control.dbo.tblLicensedUsers LU WITH (NOLOCK)
                                                                                                ON PSI.Owner = LU.UserName
                        WHERE   ISNULL(PRA.Skipped,0)='0' and SourceType='JOB'
              
							   AND [Owner] IS NOT NULL
                               AND EndTime IS NOT NULL
                               AND CONVERT(DATETIME,[EndTime],111)>= @FromDate
                               AND CONVERT(DATETIME,[EndTime],111) < @ToDate
                        GROUP BY PSI.Owner, LU.OperatorName, PS.PickingSlipNumber,SourceNumber,PSS.CustomerName,StartTime,
                            EndTime,PSI.StockCode,PSI.Qty,IM.Mass,PSS.CustomerPO,InvoiceNumber
							) as A

    GROUP BY [Owner],OperatorName
    ORDER BY [Owner]

Picker Statistics Replen

This report will give you an overview of the pickers lines and QTYs per picker for Replenishments for a specific date range.

SQL Script

declare @FromDate Date 
declare @ToDate	Date 
set @FromDate= '2018-01-01'
set @ToDate = '2018-09-01'


SELECT [Owner],SUM(QtyPicked)AS [Total Quantity Picked],SUM(MassPicked) AS [Total Mass Picked],COUNT(*) LinesPicked,
                    (CASE 0 WHEN 0 THEN 0 ELSE (SUM(MassPicked)/CONVERT(DECIMAL,0)) END + CASE 0 WHEN 0 THEN 0 ELSE (COUNT(*)/CONVERT(DECIMAL,0)) END)/1*100/(DateDiff(DAY, @FromDate, @ToDate)+1) AS [Weighted Ave],
                    COUNT(DISTINCT(PickingSlipNumber))AS [Completed Picking Slips]
                        
						FROM
						(SELECT PSI.[Owner],LU.OperatorName,PS.PickingSlipNumber,SourceNumber AS SalesOrder,CustomerName,CustomerPO,InvoiceNumber,StartTime,EndTime,
                                             PSI.StockCode,Qty AS PickingSlipQty,SUM(ISNULL(PR.QtyOrdered,PRA.QtyOrdered)) AS QtyOrdered,SUM(ISNULL(PR.QtyPicked,
                                             PRA.QtyPicked)) AS QtyPicked,(SUM(ISNULL(PR.QtyPicked,PRA.QtyPicked))*IM.Mass) AS MassPicked
                                      FROM tblPickingSlip PS WITH (NOLOCK)
                                             INNER JOIN tblPickingSlipSource PSS WITH (NOLOCK)
                                             ON PS.PickingSlipNumber=PSS.PickingSlipNumber
                                                   INNER JOIN tblPickingSlipItem PSI WITH (NOLOCK)
                                                   ON PSS.PickingSlipSourceNumber=PSI.PickingSlipSourceNumber
                                                          LEFT JOIN tblPalletReservedArchive PRA WITH (NOLOCK)
                                                          ON PSI.ItemNumber=PRA.PickingItemNumber
                                                                 LEFT JOIN tblPalletReserved PR WITH (NOLOCK)
                                                                 ON PSI.ItemNumber=PR.PickingItemNumber
                                                                        LEFT JOIN SysproCompanyTest.dbo.InvMaster IM WITH (NOLOCK)
                                                                        ON PSI.StockCode=IM.StockCode 
                                                        LEFT JOIN Warehouse_Control.dbo.tblLicensedUsers LU WITH (NOLOCK)
                                                                                                ON PSI.Owner = LU.UserName
                        WHERE   ISNULL(PRA.Skipped,0)='0' and SourceType='REPLEN'
              
							   AND [Owner] IS NOT NULL
                               AND EndTime IS NOT NULL
                               AND CONVERT(DATETIME,[EndTime],111)>= @FromDate
                               AND CONVERT(DATETIME,[EndTime],111) < @ToDate
                        GROUP BY PSI.Owner, LU.OperatorName, PS.PickingSlipNumber,SourceNumber,PSS.CustomerName,StartTime,
                            EndTime,PSI.StockCode,PSI.Qty,IM.Mass,PSS.CustomerPO,InvoiceNumber
							) as A

    GROUP BY [Owner],OperatorName
    ORDER BY [Owner]

Picker Rate Report

This report displays the average rate a Picker is picking per hour, and productive vs unproductive times can be measured.

SQL Script

Pick Slips in the same status for more than 5 days

This report give you an overview of stagnant pick slips that have not moved in 5 days.

Technical Guides

Picking KPI Reports

Try it!

Picker Statistics Sales Order & SCTs

SQL Script

Picker Statistics Jobs

SQL Script

Picker Statistics Replen

SQL Script

Picker Rate Report

SQL Script

Pick Slips in the same status for more than 5 days

SQL Script