View Closed NonConformance/Inspection

Epicor ERP 10
1

I am using “Inspection Processing Entry” in the QA module. I can view pending inspections, but would like to be able to view closed inspections to track NC’s from prior to my arrival.

Is there a simple way to go about this that I am missing?

Currently, when an inspection is closed, it is no longer searchable with Inspection Processing or Pending. Should I be using a different screen?

Thank you!

2

We do a similar thing thing. I’ll post the baq when back in the office tomorrow - you can build a dashboard/ baq report based on this.

3 
select 
	[RMADtl].[RMANum] as [RMADtl_RMANum],
	[RMADtl].[RMALine] as [RMADtl_RMALine],
	[RMADisp].[RMAReceipt] as [RMADisp_RMAReceipt],
	[SubQuery2].[RMAHead_RMADate] as [RMAHead_RMADate],
	[RMADtl].[PartNum] as [RMADtl_PartNum],
	[RMADtl].[LineDesc] as [RMADtl_LineDesc],
	[DMRHead].[DMRNum] as [DMRHead_DMRNum],
	[DMRHead].[PartNum] as [DMRHead_PartNum],
	[DMRHead].[PartDescription] as [DMRHead_PartDescription],
	[DMRHead].[Customer_reject_ref_c] as [DMRHead_Customer_reject_ref_c],
	[DMRHead].[NMK_admin_value_c] as [DMRHead_NMK_admin_value_c],
	[DMRHead].[Scrap_Value_c] as [DMRHead_Scrap_Value_c],
	[DMRHead].[Rework_Value_c] as [DMRHead_Rework_Value_c],
	[DMRHead].[Transport_value_c] as [DMRHead_Transport_value_c],
	[DMRHead].[Admin_Value_c] as [DMRHead_Admin_Value_c],
	[DMRHead].[Misc_Value_c] as [DMRHead_Misc_Value_c],
	[DMRHead].[Notes_c] as [DMRHead_Notes_c],
	[NonConf].[RMANum] as [NonConf_RMANum],
	[NonConf].[RMALine] as [NonConf_RMALine],
	[Customer].[CustID] as [Customer_CustID],
	[RMADtl].[CustNum] as [RMADtl_CustNum],
	[Customer].[Name] as [Customer_Name],
	[DMRHead].[TotDiscrepantQty] as [DMRHead_TotDiscrepantQty],
	[DMRHead].[TotRejectedQty] as [DMRHead_TotRejectedQty],
	[DMRHead].[TotAcceptedQty] as [DMRHead_TotAcceptedQty],
	[NonConf].[SysDate] as [NonConf_SysDate],
	[SubQuery3].[Calculated_MaxDate] as [Calculated_MaxDate],
	[RMADtl].[Note] as [RMADtl_Note],
	[RMADisp].[DispComment] as [RMADisp_DispComment],
	[DMRHead].[CommentText] as [DMRHead_CommentText]
from Erp.DMRHead as DMRHead
inner join Erp.NonConf as NonConf on 
	DMRHead.Company = NonConf.Company
And
	DMRHead.DMRNum = NonConf.DMRNum

full outer join Erp.RMADtl as RMADtl on 
	NonConf.Company = RMADtl.Company
And
	NonConf.RMANum = RMADtl.RMANum
And
	NonConf.RMALine = RMADtl.RMALine

left outer join Erp.Customer as Customer on 
	RMADtl.CustNum = Customer.CustNum

left outer join  (select 
	[RMAHead].[RMANum] as [RMAHead_RMANum],
	[RMAHead].[RMADate] as [RMAHead_RMADate]
from Erp.RMAHead as RMAHead)  as SubQuery2 on 
	RMADtl.RMANum = SubQuery2.RMAHead_RMANum

left outer join  (select 
	[DMRActn1].[DMRNum] as [DMRActn1_DMRNum],
	(max(DMRActn1.ActionDate)) as [Calculated_MaxDate]
from Erp.DMRActn as DMRActn1
group by [DMRActn1].[DMRNum])  as SubQuery3 on 
	DMRHead.DMRNum = SubQuery3.DMRActn1_DMRNum

left outer join Erp.RMADisp as RMADisp on 
	NonConf.Company = RMADisp.Company
And
	NonConf.RMANum = RMADisp.RMANum
And
	NonConf.RMALine = RMADisp.RMALine
And
	NonConf.RMAReceipt = RMADisp.RMAReceipt
And
	NonConf.RMADisp = RMADisp.RMADisp
4

Build a baq as above - for us we include linkage to the rma for DMR’s based on customer returns.

We added a couple of custom fields to the dmr to capture a subjective value for scrap, rework value, transport, internal admin, external admin (customer penalty).

Scrap and rework are significant as we may get sub -assembly (for example a door) from a major assembly back so the scrap/rework value is that of the sub-assembly not the top level saleable part - not sure it isn’t a bug but the version of E10 we are on will let you process a sub assembly part rma against a sales order which is for a different part - so no having to return the full set of drawers because a handle is missing

5

This is great, James! Thanks much for the help, I think it will be just what I need. I’ll try to get it built this week and let you know either way.