In which table are Inspections stored ? (Inspection Processing Entry)

Epicor ERP 10
1

I need to send an email when a line is added to the inspection processing entry so I would like to know how I can detect that

Also, I need to add some columns to the inspection screen and since it’s divided by type (PO Receipts, Operations, RMA, etc.), it would be way easier to add it via Method or Data Directive and then push that into a new UD column. However, I don’t know on which table I would need to add the column, if it’s even possible

So far, I have (Ideally it would be just 1 table but we’ll see)
PO Receipts: Erp.RcvDtl (InspectionPending = 1)
RMA: Erp.RMADtl (OpenRMA = 1)
Inventory: Erp.NonConf (InspectionPending = 1)

2

The field help in Inspection processing should help you here. Inspection is weird in that, unlike just about every other module, there isn’t a single table. Basically each tab/category on the form is its own table. Good news is that you’ve tracked down most of them already. The only omission is that First Articles use the FirstArt table and Operations also use NonConf.

Bad news is that Erp.BO.InspProcessing is also weird and fragmented. You can’t just pull up InspProcessing.Update and slap a post-proc BPM on it. Each record type has its own GetByID and each one has an “Inspect” method that posts the updated inspection.

Not sure what version you’re on, but if you have a Functions available, this a premiere case for them because you’re going to be adding multiple BPM’s regardless of whether or not you’re going the method or directive route. It would save you from some duplicate work.

1 Like
3

MOSTLY, Inspection Processing is a view into the Nonconformance (NonConf) table. But as @jtownsend mentions, there are other players as well.

1 Like
4

Do what you need in the inspection processing form with the trace logging on and see what BOs are called. That should point you to the right tables.

2 Likes
5

I ended up doing as you said. So multiple BPMS (1 on NonConf, 1 on RcvHead and another on RMADtl) and they call the same function

Not ideal but no choice since there is no table related to it!