Fulfillment workbench - allocate to firmed, unreleased jobs

Epicor ERP 10
1

Is there a way to search for jobs that are firmed but unreleased jobs?

2

COM-CustUnreleasedFirmJobs.baq (30.7 KB)

You can import this BAQ and use BAQ Search

3

Thanks for sharing the baq, unfortunately, the version doesn’t match so I am getting an error. Would you please share the SQL

this is the error
Import From File “C:\Users\Jkrishna\Desktop\COM-CustUnreleasedFirmJobs.baq”
System.Exception: Import file doesn’t exist
at Ice.Lib.BAQExportImport.BaqExportImport.Import(ImportArgs args)
Query import finished with error(s)

4

I actually copied the CustomerJobs BAQ and added the conditions to it.

select 
	[JobHead].[JobNum] as [JobHead_JobNum],
	[OrderRel].[PartNum] as [OrderRel_PartNum],
	[OrderRel].[RevisionNum] as [OrderRel_RevisionNum],
	[SalesRep].[Name] as [SalesRep_Name],
	[JobProd].[ProdQty] as [JobProd_ProdQty],
	[JobProd].[ShippedQty] as [JobProd_ShippedQty],
	[JobProd].[OrderNum] as [JobProd_OrderNum],
	[JobProd].[OrderLine] as [JobProd_OrderLine],
	[JobProd].[OrderRelNum] as [JobProd_OrderRelNum],
	[OrderRel].[OpenRelease] as [OrderRel_OpenRelease],
	[OrderDtl].[LineDesc] as [OrderDtl_LineDesc],
	[OrderRel].[OurReqQty] as [OrderRel_OurReqQty],
	[OrderDtl].[IUM] as [OrderDtl_IUM],
	[OrderRel].[NeedByDate] as [OrderRel_NeedByDate],
	[OrderRel].[ReqDate] as [OrderRel_ReqDate],
	[JobHead].[ReqDueDate] as [JobHead_ReqDueDate],
	[JobHead].[StartDate] as [JobHead_StartDate],
	[JobHead].[DueDate] as [JobHead_DueDate],
	[JobHead].[JobFirm] as [JobHead_JobFirm],
	[JobHead].[JobEngineered] as [JobHead_JobEngineered],
	[JobHead].[JobReleased] as [JobHead_JobReleased],
	[JobHead].[JobComplete] as [JobHead_JobComplete],
	[JobHead].[JobClosed] as [JobHead_JobClosed],
	[JobHead].[JobHeld] as [JobHead_JobHeld],
	[JobHead].[Plant] as [JobHead_Plant],
	[OrderHed].[CustNum] as [OrderHed_CustNum],
	[JobHead].[Company] as [JobHead_Company],
	[JobProd].[Company] as [JobProd_Company],
	[OrderDtl].[Company] as [OrderDtl_Company],
	[OrderHed].[Company] as [OrderHed_Company],
	[OrderRel].[Company] as [OrderRel_Company],
	[JobHead].[LastChangedBy] as [JobHead_LastChangedBy],
	[JobHead].[JobWorkflowState] as [JobHead_JobWorkflowState],
	[JobHead].[LastChangedOn] as [JobHead_LastChangedOn]
from Erp.JobProd as JobProd
inner join Erp.JobHead as JobHead on 
	JobProd.Company = JobHead.Company
	and JobProd.JobNum = JobHead.JobNum
	and ( JobHead.JobFirm = true  and JobHead.JobReleased = false  )

left outer join Erp.SalesRep as SalesRep on 
	JobHead.Company = SalesRep.Company
	and JobHead.JobCSR = SalesRep.SalesRepCode
inner join Erp.OrderHed as OrderHed on 
	JobProd.Company = OrderHed.Company
	and JobProd.OrderNum = OrderHed.OrderNum
inner join Erp.OrderRel as OrderRel on 
	JobProd.Company = OrderRel.Company
	and JobProd.OrderNum = OrderRel.OrderNum
	and JobProd.OrderLine = OrderRel.OrderLine
	and JobProd.OrderRelNum = OrderRel.OrderRelNum
inner join Erp.OrderDtl as OrderDtl on 
	OrderRel.Company = OrderDtl.Company
	and OrderRel.OrderNum = OrderDtl.OrderNum
	and OrderRel.OrderLine = OrderDtl.OrderLine
order by JobHead.Company, JobHead.JobNum Desc
3 Likes