Quality Inspection Test Values

The Quality Inspection Test Values page lists recorded Quality Inspection Test Line values. It is intended to make it easier to analyze changes in measured values over time and to review the grade, numeric value, notes, and audit details for individual test lines.

Business Central ‘Analysis Views’ can be used to help pivot the data, or the data can be quickly exported to Excel or Power BI for further analysis.

What can be configured

The page is primarily an analysis list. When permitted by Quality Inspector permissions, users can edit the measurement note associated with a line.

Default fields include:

Field	Purpose
Template Code	Template the test was created from.
Test No.	Quality Inspection Test number.
Retest No.	Retest iteration.
Line No.	Test line identifier.
Field Code	Field/question/metric recorded on the line.
Description	Field description as used on the test.
Balloon No.	FAIR Form 3 balloon/characteristic reference.
Characteristic Designator	FAIR Form 3 characteristic designator reference.
Field Type	Data type of the recorded value.
Allowable Values	Range or expression of technically allowed values.
Test Value	Recorded test value.
Unit of Measure	Unit of measure for the measurement.
NCR Test No.	Free-text NCR reference.
Grade Code / Grade Description / Grade Priority	Grade information determined from value and grade configuration.
Numeric Value	Evaluated numeric version of the test value for calculations and charting.
Note	Measurement note/comment, subject to permissions.
Created DateTime / Modified DateTime	Creation and modification timestamps for the line.

Visible information by default

The list is sorted by test number, retest number, and line number in descending test order so newer test values are easier to find first. Specification instructions and notes may be visible in fact boxes depending on edition and permissions.

Actions

• Assist-edit on Note opens the read-only or editable measurement note page depending on the user’s permissions.
• Standard list filtering can be used to analyze by template, item-related fields, field code, grade, date/time, or value.

Suggested Analysis Views

The below analysis views are suggestions of analysis views that could be created to help interpret trends and patterns in quality inspection test results from Insight Works Quality Inspector.

Failure Trends by Characteristic

Purpose: Identify which measurements fail most often.

Dimensions

• Field Code
• Template Code

Measures

• Count of records
• Count where Grade = FAIL

Questions answered

• Which characteristics are failing most?
• Which inspection templates are causing problems?

---

Item Quality History

Purpose: Understand long-term performance of specific products.

Dimensions

• Item No.
• Variant Code
• Field Code

Measures

• Count
• Average Numeric Value
• Minimum Numeric Value
• Maximum Numeric Value

Questions answered

• Is a dimension drifting over time?
• Which items have the most variation?

---

Customer Complaint / NCR Analysis

Purpose: Correlate defects with NCRs.

Dimensions

• NCR Test No.
• Field Code
• Grade Code

Measures

• Count

Questions answered

• Which measurements most frequently lead to NCRs?
• What defects are driving corrective actions?

---

First Article Inspection (FAIR) Analysis

Purpose: Analyze ballooned characteristics.

Dimensions

• Balloon No.
• Characteristic Designator

Measures

• Count
• Failure count

Questions answered

• Which drawing characteristics are causing the most issues?
• Which critical dimensions require attention?

---

Retest Analysis

Purpose: Understand rework and repeated inspections.

Dimensions

• Retest No.
• Template Code
• Item No.

Measures

• Count

Questions answered

• Which products require the most retesting?
• Are retests increasing?

---

Time-Based Quality Trends

Purpose: Detect process drift.

Dimensions

• Year
• Month
• Week
• Field Code

Measures

• Average Numeric Value
• Count
• Failure count

Questions answered

• Is a measurement gradually drifting?
• Did process changes improve quality?

This is one of the highest-value views because many quality problems appear as gradual changes rather than sudden failures.

---

Grade Distribution

Purpose: Monitor overall quality.

Dimensions

• Grade Code
• Template Code
• Item No.

Measures

• Count

Questions answered

• Percentage PASS vs FAIL.
• Which templates generate the most failed measurements?

---

Cp/Cpk Preparation View

Purpose: Export to Excel or Power BI for SPC.

Dimensions

• Field Code
• Item No.
• Work Center

Measures

• Average Numeric Value
• Standard deviation
• Min
• Max
• Count

Questions answered

• Is the process centered?
• Is variation increasing?

---

Heat-Treat / Batch / Lot Analysis

Purpose: Trace quality issues back to lots.

Dimensions

• Lot No.
• Serial No.
• Field Code

Measures

• Average Numeric Value
• Failure count

Questions answered

• Are defects isolated to specific lots?
• Should a lot be quarantined?

Related documentation

• Use Quality Inspection Tests
• Quality Inspection Fields
• Use Measurement Notes and Comments in Quality Inspector