Quality Control - [QC Entry]

Doubt

• In QC1 delete not given. From QC main how can I delete uploaded file since there will be different item grps.
• Grn lines without TrnId we will not take right even for manual?

Objective

• The QC module manages quality inspections for business documents like:

1. Goods Receipt (Incoming QC)
2. Production (In-Process QC)
3. Invoice (Outgoing QC)

• It supports:

1. Manual QC (certificate-based)
2. System QC (parameter-based validation)
3. Mix QC (Combination of System + Manual based on item groups)

Data Model Overview

QC_Main (Header)
   ↓
QC_Line (Item Group Level)
   ↓
QC_Parameter (Parameter Level – only for system/mix mode)

Tables

CREATE TABLE QualityControl
(
    Id INT IDENTITY(1,1) PRIMARY KEY,
    qcno NVARCHAR(6),
    qcDate DATETIME,
    yearqcno NVARCHAR(12),
    qcStage NVARCHAR(3), -- IQC (Incoming), PQC (In process), FQC (Final)
    refDoc NVARCHAR(20), -- GRN (Currently restricted)
    refNo NVARCHAR(6),
    refDate DATETIME,
    mode NVARCHAR(1), -- S (System), M (Manual), X (Mix)
    qcStatus NVARCHAR(1), -- O (Open), C (Closed), P (Partial)
    checkedBy NVARCHAR(25),
    approvedBy NVARCHAR(25)
);

CREATE TABLE QualityControl1
(
    Id INT IDENTITY(1,1) PRIMARY KEY,
    qcno NVARCHAR(6),
    yearqcno NVARCHAR(12),
    itemgrpid NVARCHAR(3),
    testplancode NVARCHAR(6), -- (0 for Manual)
    reportNo NVARCHAR(20),
    reportDate DATETIME,
    itemQcStatus NVARCHAR(1),  -- Pending (N), P (Pass), F (Fail)
    remarks NVARCHAR(150)
);

CREATE TABLE QualityControl2
(
    Id INT IDENTITY(1,1) PRIMARY KEY,
    qcno NVARCHAR(6),
    yearqcno NVARCHAR(12),
    itemgrpid NVARCHAR(3),
    parameterCode NVARCHAR(6),
    actualValue DECIMAL(7,3),
    result NVARCHAR(1) -- Pending (N), P (Pass), F (Fail)
);

QC Main Level

QC Index

Fields

Buttons

• Create

QC Details

Fields

Buttons

• Create
• Print
• Delete
• Back

QC Create

Fields

Hard Coded combo values

QC Stage

1. IQC (Incoming)
2. PQC (In-Process)
3. FQC (Final)

Ref Doc (Currently restricted)

1. GRN

Mode

1. S (System)
2. M (Manual)
3. X (Mix)

Validations

Points

• QC No & YearQCNo → System generated
• QC Date → DateTime.Now
• Default Status → O (OPEN)

Mode Determination Logic

Processing Logic

Manual Mode

• QC1 populated with item groups
• testplancode = 0
• User must:
  1. Upload certificate (per item group)
  2. Enter Report No & Date
• QC2 → NOT used

System Mode

• QC1 populated with item groups
• testplancode assigned
• QC2 populated with parameters
• Report No → Auto generated
• Report Date → DateTime.Now

Mix Mode

• Item groups with test plan → System
• Item groups without → Manual

Print Report PDF

Header

• QC No, Date
• QC Stage
• Ref Doc / Ref No
• Mode
• Status

Item Group Section

• Item Group
• Test Plan Code
• Report No / Date
• Status

Parameter Section (System / Mix mode)

• Item Group
• Parameter
• Actual
• Result

QC Line Level 1

• Records will be autofetched and inserted from Reference Document.
• For System model Report Number and date will be generated by System.
• For Manaual mode Report Number and date will be given by user.
• User can also write remarks.
• Initially Item QC Status will be inserted as Pending

QC 1 Index

Fields

QC 1 Details

Fields

Buttons

• Parameter Details
• Modify Remarks Dialog Box
• Upload Show only if manual or Mix mode and test plan not available

QC 1 Upload

Fields

QC Line Level 2

• Will be available only for System or Mix mode and test plan exists
• Initially result will be Pending

QC 2 Index

Header

Fields

QC 2 Import

Download Model

• Values will be prefilled and only actual Value column will be open

• Fields

  Column	Property
  Id Hidden	Id
  Parameter Code	ParameterCode
  Parameter Name	ParameterCode
  Parameter Type Code Hidden	ParameterTypeCode
  Parameter Type Name	ParameterTypeName
  Actual Value	ActualValue

• Instruction Sheet

  Column	Validation
  Actual Value	For parameter type System fill numeric value and for Manual fill P(Pass)/F(Fail)

Reading XL Error code

Repository Error code

Parameter Execution Logic

System Parameter

• Inititally status will be → Pending
• User fills actual values
• IF actualValue BETWEEN minValue AND maxValue → PASS ELSE → FAIL

Manual Parameter

• User selects: Pass / Fail

Status Logic

QC2 (Parameter)

• N → Pending
• P → Pass
• F → Fail

QC1 (Item Group)

IF Manual → user input
IF System:
    IF any FAIL → F
    ELSE IF all PASS → P
    ELSE → N

QC_Main

IF all QC1 = PASS → C
IF all QC1 = Pending → O
ELSE → P

QC Locking

• If QC exists → Modify/Delete not allowed for linked refdoc

Edge Case Handling

Multiple Items in Item Group (Critical)

Problem:

• 3 items → 2 good, 1 bad

Solution

👉 Use Worst Case Logic

IF ANY sample fails → Item Group FAIL

Input Approach

• User must enter: Minimum observed value