Open Sales Order BAQ

Kinetic ERP
1

Does Anyone have a BAQ they can share with me that has a list of all the open orders, Qty, Part numbers, Open Qty remaining?

I’m coming from Vantage 5 to Kinetic and having issues learning how to create a BAQ…

2

This combines OrderHed > OrderDtl >OrderRel, and shows the open releases, quantities, and values. Good luck!

/*
 * Disclaimer!!!
 * This is not a real query being executed, but a simplified version for general vision.
 * Executing it with any other tool may produce a different result.
 */
 
select 
	[OrderHed].[OrderNum] as [OrderHed_OrderNum],
	[OrderRel].[OrderLine] as [OrderRel_OrderLine],
	[OrderDtl].[PartNum] as [OrderDtl_PartNum],
	[OrderDtl].[UnitPrice] as [OrderDtl_UnitPrice],
	[OrderRel].[OrderRelNum] as [OrderRel_OrderRelNum],
	[OrderRel].[OurReqQty] as [OrderRel_OurReqQty],
	(OrderRel.OurJobShippedQty+ OrderRel.OurStockShippedQty) as [Calculated_Shipped],
	(OrderRel.OurReqQty- Shipped) as [Calculated_Remain],
	(Remain* OrderDtl.UnitPrice) as [Calculated_OpenValueRemain]
from Erp.OrderHed as OrderHed
inner join Erp.OrderDtl as OrderDtl on 
	OrderHed.Company = OrderDtl.Company
	and OrderHed.OrderNum = OrderDtl.OrderNum
	and ( OrderDtl.OpenLine = true  )

inner join Erp.OrderRel as OrderRel on 
	OrderDtl.Company = OrderRel.Company
	and OrderDtl.OrderNum = OrderRel.OrderNum
	and OrderDtl.OrderLine = OrderRel.OrderLine
	and ( OrderRel.OpenRelease = true  )

where (OrderHed.OpenOrder = true)

OpenSOs.baq (25.0 KB)

3 Likes
3

Do a search in the help learn how to create BAQs in Kinetic.

Search for “Using the Business Activity Query (BAQ) Designer”

The other place to look is the Epicor Learning Center.

1 Like