I want Sale Order to show data that has PackNum

Kinetic ERP
1

I want Sale Order to show data that has PackNum and that does not. But when I do BAQ, the system only pulls Sale Order that has only PackNum. Is there a way to pull Sale Order data that has both PackNum and does not?

image
image1340×836 59 KB

image
image1804×815 262 KB

select  
	[OrderRel].[Company] as [OrderRel_Company], 
	[OrderRel].[ReqDate] as [OrderRel_ReqDate], 
	[OrderRel].[OrderNum] as [OrderRel_OrderNum], 
	[OrderRel].[OpenRelease] as [OrderRel_OpenRelease], 
	[OrderRel].[OrderLine] as [OrderRel_OrderLine], 
	[OrderRel].[PartNum] as [OrderRel_PartNum], 
	[OrderRel].[SellingReqQty] as [OrderRel_SellingReqQty], 
	[OrderRel].[SellingStockShippedQty] as [OrderRel_SellingStockShippedQty], 
	[OrderRel].[SalesUM] as [OrderRel_SalesUM], 
	[ShipDtl].[PackNum] as [ShipDtl_PackNum] 

from Erp.OrderRel as [OrderRel]
inner join Erp.ShipDtl as [ShipDtl] on 
	  OrderRel.Company = ShipDtl.Company
	and  OrderRel.OrderNum = ShipDtl.OrderNum
	and  OrderRel.OrderLine = ShipDtl.OrderLine
	and  OrderRel.OrderRelNum = ShipDtl.OrderRelNum
2

Change the relation to all rows from the sales order i.e. Left outer join.

3 Likes
3

Thank You