Module LabQC Pro


LabQC Pro

LabQC Pro is a laboratory quality control module for Dolibarr designed to manage product-specific QC specifications, analytical testing, automatic PASS / FAIL evaluation, result approval and locking, audit trail, Certificate of Analysis (CoA), and Out of Specification (OOS) reports.

The module can work independently or optionally integrate with BatchSafe Pro for automatic batch/lot quality-status synchronization.

Information

  • Module name: LabQC Pro
  • Current version: 1.0.40
  • Author: Vasile Panciuc
  • Publisher: PanciucSoft
  • License: GNU GPL v3 or later
  • Support: support@panciucsoft.com
  • Dolibarr compatibility declared on DoliStore: V18 - V23
  • Validated clean installation: Dolibarr 23.0.3
  • Languages: English, Romanian
  • BatchSafe Pro: Optional

Introduction

LabQC Pro provides a structured quality control workflow directly inside Dolibarr.

The typical workflow is:

QC Specification → QC Test → Analytical Results → Automatic PASS / FAIL → Finalization & Locking → CoA or OOS Report

The module is suitable for organizations that manage products by batch or lot and need traceable laboratory quality-control records.

 


Main features

  • Product-specific QC specifications
  • Specification version management
  • Analytical parameters and acceptance criteria
  • Numeric and text-based laboratory results
  • Mandatory analytical parameters
  • QC tests linked to existing Dolibarr product batches / lots
  • Automatic PASS / FAIL evaluation
  • Finalization and permanent result locking
  • Laboratory Analyst and QC Manager permission workflow
  • Immutable Audit Trail
  • Previous and new value tracking
  • User and timestamp history
  • Certificate of Analysis generation for PASS tests
  • OOS / QC Test Report generation for FAIL tests
  • Tested by / Approved by information
  • Approval date and signature fields
  • Responsive desktop and mobile interface
  • English and Romanian interface
  • Optional BatchSafe Pro integration

User roles

Lab Analyst

The Laboratory Analyst can:

  • Create QC tests
  • Select the product, specification and real Dolibarr lot
  • Enter analytical results
  • Save and recalculate results
  • Trigger automatic PASS / FAIL evaluation

The Laboratory Analyst should not finalize or approve QC tests unless the corresponding permission is granted.

QC Manager

The QC Manager can:

  • Review analytical results
  • Review PASS / FAIL verdicts
  • Finalize and lock QC tests
  • Approve the final QC decision
  • Review the Audit Trail
  • Generate CoA or OOS reports

QC Specifications

A QC Specification defines the analytical requirements for a product.

Each specification may contain:

  • Product
  • Reference
  • Label
  • Version
  • Status
  • Description
  • Analytical parameters

Each analytical parameter may define:

  • Parameter name
  • Analytical method
  • Acceptance criterion
  • Mandatory status

Example:

Parameter Method Acceptance criterion Mandatory
Assay HPLC 98 - 102 % Yes
Appearance Visual White tablets Yes

QC Tests

A QC Test is linked to:

  • A Dolibarr product
  • A QC specification
  • An existing Dolibarr batch / lot
  • A test date
  • Analytical results

The module retrieves existing Dolibarr product lots, which helps maintain traceability between laboratory testing and physical stock.

Automatic PASS / FAIL evaluation

LabQC Pro evaluates entered analytical results against the approved specification.

Example:

Parameter Specification Result Verdict
Assay 98 - 102 % 100 % PASS
Appearance White tablets White tablets PASS

If one or more mandatory analytical parameters fail, the final QC test status becomes FAIL.

Finalization and result locking

After results are reviewed, an authorized QC Manager can finalize the QC test.

Finalization:

  • Records the approving user
  • Records the approval date and time
  • Stores the final PASS or FAIL decision
  • Locks laboratory results against further modification
  • Creates an Audit Trail event

Once finalized, analytical results become read-only.

Certificate of Analysis

A finalized PASS test can generate a Certificate of Analysis (CoA).

The generated PDF contains:

  • Product
  • Batch / Lot
  • QC specification
  • Test date
  • Final QC status
  • Overall result
  • Analytical parameters
  • Methods
  • Specifications
  • Results
  • Verdicts
  • Tested by
  • Approved by
  • Approval date
  • Signature field

The final decision is displayed as Approved.

OOS / QC Test Report

A finalized FAIL test can generate an OOS / QC Test Report.

The report identifies failed analytical parameters and displays:

  • Final QC status: FAIL
  • Overall result: Out of Specification (OOS)
  • Failed analytical results
  • Final decision: Rejected
  • Tested by
  • Approved by
  • Approval date
  • Signature field

Audit Trail

LabQC Pro includes an immutable Audit Trail for important QC events.

Recorded events include:

  • QC test creation
  • Result updates
  • Status changes
  • Test finalization

Each event can record:

  • Date and time
  • QC test reference
  • Action
  • Object
  • User
  • Previous value
  • New value
  • Note

The Audit Trail is available on both desktop and mobile layouts.

BatchSafe Pro integration

BatchSafe Pro integration is optional.

When BatchSafe Pro is installed and enabled, LabQC Pro can automatically synchronize lot quality status.

Typical workflow:

LabQC event BatchSafe Pro status
QC test opened Under inspection
QC test in progress Under inspection
Finalized PASS Released
Finalized FAIL / OOS Rejected

LabQC Pro also works normally when BatchSafe Pro is not installed or is disabled.

Installation

  1. Download the LabQC Pro ZIP package.
  2. In Dolibarr, go to Home → Setup → Modules/Applications.
  3. Use the external module deployment function.
  4. Upload the LabQC Pro ZIP package.
  5. Activate LabQC Pro.
  6. Configure user permissions.
  7. Ensure Products, Stock and Lot / Serial management are enabled if lot-based QC is required.

The module has also been validated on a clean Dolibarr 23.0.3 installation.

Basic configuration

Before creating QC tests:

  1. Create or select a Dolibarr product.
  2. Enable lot / serial management for the product.
  3. Create a warehouse.
  4. Add stock using a real lot number.
  5. Create a QC Specification for the product.
  6. Add analytical parameters.
  7. Create a QC Test and select the existing lot.

Mobile support

LabQC Pro includes responsive layouts for:

  • Dashboard
  • QC Specifications
  • QC Tests
  • Analytical result entry
  • Finalized test review
  • Certificates / OOS
  • Audit Trail

This allows laboratory and QC users to review or enter information from mobile devices.

Support

For support, installation questions or bug reports:

Email: support@panciucsoft.com

Publisher: PanciucSoft

License

LabQC Pro is distributed under the GNU General Public License version 3 or later (GPL-3.0-or-later).

Regulatory notice

LabQC Pro provides software workflow features for laboratory quality control.

Validation, qualification, electronic-signature requirements, data-retention rules and suitability for GMP, GLP, GxP, ISO, pharmaceutical, medical or other regulated use remain the responsibility of the organization deploying the module.

See also