Let me start with details: We are using Kinetic SaaS, We have the Quality Assurance module (NOT Enhanced QA). I’m looking into writing a dashboard for Quality to use to see Inspection Results, starting with PO Receipts since we are revamping the Receiving process and Inspection is related.
We are looking for the tables where the data for Inspection Processing is saved.
For PO Receipts I found some of the fields in the RcvDtl table. Those fields are Inspection Required, Inspector ID, Inspected By, Inspection Date, Inspection Time, Passed Qty, Failed Qty, and Reason Code.
But where are the Passed Comments and Failed Comments, Request Move, Received To, Warehouse, PassedBin, etc? Field Level Help shows these as being in a porView. ‘table’, but there have to have tables where this data is saved.
Alternatively, is it possible to access the porView table/view for writing BAQs?
Like John said, you’ll want to take a look at NonConf, DMRHead, DMRACtn and potentially DMRCorAct tables depending on how far you take it. That can be done via BAQ as you suggested.
I don’t know if there’s any good out of the box analytical reports, I think they are more tactical- i.e. what is open, etc.
Utah, love your research on these tables. Tables structure is designed for handling a generic set of non conformance, Inspection record etc. and it would work for lot or people. Reporting can be done with a BAQ to start.
It’s also easy to get lost looking for specific tables and joins when you are looking to get a simple report. In addition, if we want to collect something from an external device/sensor, it’s a whole another battle.
I understand why you would want to build something outside the system given your requirements and data needs. You should show that at insights next year!
I never knew that table was there. I’ve been looking at INSP… tables, but I think those are used by the Enhanced Quality module since they are all empty for us.
Correct, there are no after the fact type of reports for NCR. You can see the NCRs in Inspection Processing and you can pull up individual NCRs in the Nonconformance screen, but that is really it. Any reports have to be made.
You are correct, those tables are for the Inspection process where you can create your own inspection templates and attach them to various places to allow for data capture in the system.
This is one of those areas that really doesn’t seem to make sense at first… but the Quality process is a 3-step process. First step is the determination that something isn’t right. Second is the inspection, and if it fails, then it goes to DMR.
If Receiving Inspection Required is set on a PO Receipt, then these received parts are ASSUMED to be nonconforming… so the appropriate record is added to that table and the rest of the process continues.