Shipping KPI Reports

Owned by DATASCOPE WMS
Last updated: Apr 16, 2024
2 min read

Ribbon Bar / Launch HTML5 / Launch KPI

If you are running the DATASCOPE WMS shipping module, these Reports can be used to monitor your shipping department.

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

None

Try it!

Shipping Overview

This report will give you a Shipping summary.

image-20240416-110129.png
Report example

SQL Script

SELECT tblWaybillOrder.[Waybill] AS [Waybill] ,tblWaybillMaster.[Status] AS [WaybillStatus] ,COUNT(tblPickingSlipSource.[SourceNumber]) AS [TotalSaleOrders] ,COUNT(tblPickingSlip.[PickingSlipNumber]) AS [TotalPickingSlips] ,tblWaybillShipperMaster.[Name] AS [Carrier] ,tblWaybillMaster.[CreatedDate] AS [CreatedDate] ,tblWaybillMaster.[CreatedBy] AS [CreatedBy] ,tblWaybillMaster.[Vehicle] AS [Vehicle] FROM WarehouseCompanyTest.dbo.tblPickingSlip INNER JOIN WarehouseCompanyTest.dbo.tblPickingSlipSource ON tblPickingSlip.[PickingSlipNumber] = tblPickingSlipSource.[PickingSlipNumber] LEFT OUTER JOIN WarehouseCompanyTest.dbo.tblWaybillOrder ON tblWaybillOrder.[PickingSlipNumber] = tblPickingSlip.[PickingSlipNumber] LEFT OUTER JOIN WarehouseCompanyTest.dbo.tblWaybillMaster ON tblWaybillMaster.[Waybill] = tblWaybillOrder.[Waybill] LEFT OUTER JOIN WarehouseCompanyTest.dbo.tblWaybillShipperMaster ON tblWaybillMaster.[ShipperId] = tblWaybillShipperMaster.[Id] WHERE tblPickingSlip.[Status] NOT IN ('CANCELED', 'COMPLETE') AND tblWaybillMaster.[Status] = 'CREATED' AND tblWaybillOrder.[Selected] = '1' GROUP BY tblWaybillOrder.[Waybill] ,tblWaybillMaster.[Status] ,tblWaybillMaster.[ShipperId] ,tblWaybillShipperMaster.[Name] ,tblWaybillMaster.[CreatedDate] ,tblWaybillMaster.[CreatedBy] ,tblWaybillMaster.[Vehicle];

Waybill with Shipping TrackID details

This report will display Shipping Waybill details with Shipping pallet details.

image-20240416-110241.png

SQL Script

select WBO.Waybill, WBO.SalesOrder, iSNULL(WBO.DispatchNote,'Await'+ WBO.SalesOrder) as DispatchNote, isnull(STO.ShippingTrackId,0) as ShippingTrackId , isnull(P.PalletNumber,0) as PalletNumber, isnull(P.ActualMass,0) as ActualMass, isNull(P.TheoreticalMass,0) as TheoreticalMass, ISNULL(P.[Length],0) as [Length] ,isnull( P.Width,0) as [Width], isnull(P.Height,0) as [Height], (cast(ISNULL(P.[Length],0) as decimal(18,6))*cast(isnull( P.Width,0) as decimal(18,6))*cast(isnull(P.Height,0) as decimal(18,6))/5000) as [Volumetric Weight], isnull(P.ShippingTrackIdType,0) as ShippingTrackIDType from tblWaybillOrder WBO with (nolock) left join tblShippingTrackIdOrder STO with(nolock) on STO.WaybillId=WBO.Waybill and STO.SalesOrder=WBO.SalesOrder left join tblPallet P with (nolock) on P.PalletNumber=STO.ShippingTrackId where WBO.Selected='1' and iSNULL(STO.Selected,1)='1' --and WBO.Waybill=@Waybill group by WBO.Waybill, WBO.SalesOrder, WBO.DispatchNote, iSNULL(WBO.DispatchNote,'Pending'+ WBO.SalesOrder), isnull(STO.ShippingTrackId,0) , isnull(P.PalletNumber,0), isnull(P.ActualMass,0), isNull(P.TheoreticalMass,0) , ISNULL(P.[Length],0),isnull( P.Width,0), isnull(P.Height,0) , (cast(ISNULL(P.[Length],0) as decimal(18,6))*cast(isnull( P.Width,0) as decimal(18,6))*cast(isnull(P.Height,0) as decimal(18,6))/5000), isnull(P.ShippingTrackIdType,0)