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
Still need help?
Ask other Business Central users in the Insight Works community, or send the details to the support team. Include the steps you took and any error message you saw.