Quality Control

The Quality Control (QC) module governs the inspection and verification process for received goods and materials. It bridges material receipt with quality assurance through a structured, multi-tier inspection pipeline that supports automated tolerance checks against standardized test plans as well as direct supplier certificate archiving.

â„šī¸
Navigation Note: While Quality Control operates as an integral transaction in operational workflows, it is accessed via the Quality Control workbench (/qualitycontrolindex).

🧭 Quality Control Process Flow

flowchart TD
    GRN["Step 1: Goods Receipt Note (GRN)"] --> QCCreate["Step 2: Create QC Inspection Header"]
    QCCreate --> ModeBranch{"Step 3: Test Plan Mode Selection"}
    
    ModeBranch -->|System Mode| BulkUpdate["Step 4A: Excel Parameter Bulk Update"]
    ModeBranch -->|Manual Mode| CertUpload["Step 4B: Upload Test Certificate (PDF)"]
    ModeBranch -->|Mixed Mode| HybridFlow["Step 4C: Split System & Manual Items"]
    
    BulkUpdate --> AutoEval["Step 5: Automated Tolerance Evaluation (Pass/Fail)"]
    CertUpload --> ManualStatus["Step 5: Manual Status Assignment"]
    HybridFlow --> AutoEval
    HybridFlow --> ManualStatus
    
    AutoEval --> ItemPass{"All Lines Evaluated?"}
    ManualStatus --> ItemPass
    
    ItemPass -->|Lines Pending| Partial["Status: Partial"]
    ItemPass -->|All Done| Closed["Status: Closed"]
    
    Closed --> Approval["Step 6: Final QA Approval Lock"]
    Approval --> Print["Step 7: Generate Official Inspection Report"]

📑 Inspection Architecture

Quality Control is structured in a three-tier hierarchy:

  1. Inspection Header: Contains overarching document metadata, including QC Number, Inspection Date, Stage (e.g., Incoming QC / IQC), Reference Document Number (GRN No), and overall Status (Open, Partial, Closed).
  2. Item Group Lines: Every distinct item category present on the reference document is automatically parsed into a dedicated inspection item line with its own Item QC Status (Pending, Pass, Fail) and QA Remarks.
  3. Parameter & Certificate Verification:
    • System Inspected Items: Linked to pre-configured Test Plans containing specific Quality Parameters, numeric minimum/maximum tolerances, and automated grading.
    • Manual Inspected Items: Unlinked items that require direct document verification and supplier test certificate upload.

đŸ› ī¸ Step-by-Step Inspection Workflow

1. Creating the QC Inspection Header

Navigate to Quality Control and click Create New:

  1. QC Date: Specify the date of physical inspection.
  2. QC Stage: Select the applicable inspection milestone:
    • Incoming (IQC): Verification of raw materials, parts, or purchased items upon arrival.
  3. Ref Doc & Ref No: Select GRN and enter the 6-digit Goods Receipt Note number.
  4. Ref Date: Specify the reference GRN date.
  5. QC Mode: Select the inspection method. The system requires strict alignment with Test Plan availability:
    • System (S): Every item group on the reference document has an active Test Plan.
    • Manual (M): None of the item groups have a Test Plan; manual certificate verification is required.
    • Mix (X): Some item groups have Test Plans while others require manual certification.
âš ī¸
Mode Validation Guard: You cannot manually bypass QC modes. If Test Plans exist for all item groups on the GRN, the system will reject Manual or Mix mode and mandate System. Conversely, if any item group lacks a Test Plan, System mode will be blocked.

2. Inspecting Test-Plan Items (System Mode)

For item groups linked to a Test Plan, the system automatically pulls all configured quality parameters:

Download Parameter Model

Open the Item Details page and click Bulk Update, then click Download Model. This generates a protected Excel spreadsheet (UpdateQcParameter_Model.xlsx) containing all active test parameters.

Enter Measured Values

Open the downloaded spreadsheet and enter observed inspection readings in the unlocked Value/Status column:

  • System Parameters (Numeric): Enter the measured value (e.g., 12.450). The system validates that values are between 0 and 9999.999.
  • User Parameters (Qualitative): Enter P for Pass or F for Fail (e.g., visual finish, color uniformity).

Upload Completed Model

Save the file as UpdateQcParameter.xlsx and upload it. The system processes the values, validates data types, and generates an evaluated diagnostic workbook showing:

  • Measured reading vs. approved minimum/maximum limits.
  • Automated line result (Pass or Fail).

Automated Item Group Status

  • If all parameters pass, the Item QC Status is automatically set to Pass.
  • If even one parameter fails, the Item QC Status is automatically marked Fail.

3. Inspecting Non-Plan Items (Manual Certificate Upload)

For item groups where no formal test plan exists:

  1. Click on the item line from QC Details.
  2. Click Upload Certificate to open the certificate upload screen.
  3. Enter the supplier’s Report Number and Report Date.
  4. Set the Item QC Status to Pass or Fail.
  5. Select and upload the supplier’s Certificate of Analysis (COA) / Mill Test Certificate in PDF format (maximum file size: 1 MB).
  6. Click Upload. The certificate is securely archived, and the action button changes to Download Certificate / Re-Upload Certificate.

4. Updating QA Remarks

At any time prior to final approval, QA inspectors can append or modify qualitative notes:

  1. Open the QC Item Details page.
  2. Click Modify QA Remark.
  3. Enter relevant findings, observations, or concession notes (up to 150 characters).
  4. Click Update.

5. Final Approval & Tamper Lock

Once all item lines under an inspection header have been evaluated (no lines remain Pending), the overall QC Status transitions to Closed:

  1. A green Approve QC button appears on the QC Header toolbar for authorized quality supervisors.
  2. Click Approve QC and confirm the dialog.
  3. The system permanently records the approving user’s credentials and timestamps the inspection.

Approval Immutability Lock: Once a QC record is Approved:

  • The entire inspection is permanently locked against deletion.
  • QA Remarks cannot be modified.
  • Parameter readings, Excel uploads, and PDF certificates cannot be altered or re-uploaded.

6. Printing the Official Inspection Certificate

Click the Print button on the QC Details toolbar to generate an official, publication-ready PDF inspection report. The document compiles:

  • Inspection header details, reference GRN, and inspection stage.
  • Breakdown of all item groups, report numbers, and completion dates.
  • Comprehensive parameter evaluation grid showing specified limits, actual observed readings, and pass/fail verdicts.
  • Inspector and supervisor digital approval sign-offs.

🔒 Critical Business Validations & Rules

Validation RuleConditionSystem Behavior
GRN Service Type GuardGRN represents Service/Labor chargesBlocks QC creation: “QC is not allowed for Services GRN”.
Chronological Date LockRef Date is later than QC DateRejection: “Ref Date cannot be after QC Date”.
Duplicate Inspection PreventionA QC record already exists for the same RefDoc, RefNo, and RefDateRejection: “Duplicate QC Entry”. Prevents double-inspection of the same shipment.
Empty GRN Line GuardReference GRN has no line itemsRejection: “No lines found in GRN”.
Empty Test Plan GuardLinked Test Plan has zero test parametersRejection: “One or more item groups are linked to Test Plans that do not contain any test parameters”.
1-Year Audit LockQC Date is older than 1 yearThe Upload / Re-Upload Certificate button is permanently hidden to protect historical audit records.
Spreadsheet Structure CheckUploaded Excel file headers or hidden keys are modifiedRejection: “Model has been altered. Records are missing / not matching. Please re-download the model.”
Spreadsheet Data DiagnosticsUploaded value has invalid formatGenerates diagnostic sheet with specific error codes: Z1 (Non-numeric value), Z2 (Out of range 0–9999.999), Z3 (Invalid Pass/Fail code).
Audit-Tracked DeletionDeleting an unapproved QC entryMandates a meaningful deletion reason between 10 and 250 characters. Automatically deletes all associated cloud-stored test certificates.
Post-Approval Deletion LockAttempting to delete an Approved QCHard block: “QC is Approved. You may not delete it.”

💡 Best Practices for Quality Teams