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 in fact get released into the warehouse and are successfully picked, packed and shipped.
| Info |
|---|
If you don’t like reading, you can watch the video. |
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
None |
Try it!
Pick Slip and Sales Orders not assigned to Waybills
<description>
<example report>
SQL Script
codeThis report will indicate where the site has not added an Sales Order to a Waybill or has deselected a pick slip.
SQL Script
| Code Block |
|---|
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','\','*') |