Order Release KPI Reports

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

Ribbon Bar / Launch HTML5 / Launch KPI

The report in this section would be used by the Order Releasing team to ensure that all orders that are due for delivery do get released into the warehouse and are successfully picked, packed and shipped.

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

None

Try it!

Pick Slip and Sales Orders not assigned to Waybills

This report will indicate where the site has not added an Sales Order to a Waybill or has deselected a pick slip.

image-20240416-105457.png
Report example

SQL Script

select WBO.Waybill, SM.SalesOrder, SM.Customer, SM.CustomerName, SM.OrderStatus, SM.EntrySystemDate, PSS.PickingSlipNumber, WBO.Selected from SysproCompanyTest.dbo.SorMaster SM with (nolock) left JOIN WarehouseCompanyTest.dbo.tblPickingSlipSource PSS with (nolock) on PSS.SourceNumber=SM.SalesOrder left join WarehouseCompanyTest.dbo.tblWaybillOrder WBO with (nolock) on WBO.SalesOrder=SM.SalesOrder where WBO.Waybill IS NULL and SM.OrderStatus not in ('9','S','\','*') OR WBO.Selected='0' and SM.OrderStatus not in ('9','S','\','*')