Skip to main content
Version: 2.0

Example Usage: Clustering

This example illustrates a clustering process based on the SEC Unique Numbered Product (UNP) standard.


SEC Standard

SEC stands for Single European Coding, a unique identifier system mandated for marking human tissues and cells distributed across the European Union. The SEC has been compulsory for all tissue establishments (TEs) in the EU since 29 April 2017.

The SEC is composed of two parts:

  • Donation Identification Number (SEC-DI) – 21 characters

  • Product Identification Sequence (SEC-PI) – 19 characters

    Single European Coding

Key Components of SEC:

  • ISO Country Identifier: Indicates the country of the tissue establishment issuing the SEC, following the ISO 3166-1 alpha-2 code format.

  • TE Code: Tissue Establishment code of the manufacturer creating products out of the received human tissue. TEs are listed in the EU Tissue Establishment Compendium.

  • Unique Donation Number: Identifies a specific donor.

  • Coding System Identifier: Points to the coding system from which the Product Code is derived. Recognized systems within the EU are:

    Coding SystemIdentifier
    ISBT 128A
    EurocodeB
    EUTCE
  • Product Code: Identifies the product created from the donor tissue.

  • Split Number: Used to uniquely identify each produced product, unique within each Donation Identification/Product Code combination

  • Expiry Date: Specifies the product’s expiry in the format YYYYMMDD.

Clustering

On Goods Receipt PO, Supplier Batch and Supplier Serial Numbers are recorded and Internal Batch numbers generated. The Receiver requires different scenario groups for Internal Batch number generation. The received items are clustered into Internal Batch numbers based on scenario group identifiers such as: same Item, same PO, same supplier DN/PL, same Supplier Batch, same Expiry Date.

Each organization, item group, or item may define its own clustering rules. For example:

  • Receiver 1: Clustering is based on a unique combination of Item/PO/PackList/Supplier Batch.
  • Receiver 2: Clustering is based on Item/PO/PackList/Expiry Date.

When all relevant criteria match, the same Internal Batch number is assigned to the received items.

Since Supplier Serial Numbers are only unique within a UDI Lot Number - and multiple lots may exist on a single PO line - the serial number registration must be linked both to the Internal Batch and the Supplier Batch.

The example below shows how a supplier’s internal batches are received by the receiver and how clustering into a single internal batch is identified:

Batch Clustering

Clustering rule:

GRPO typeDN/PL # supplierPOItemSupplier Batch #Expiry Date
Receiver SEC/Serial# GRPOYYYY

Item Declaration for Serialization

For items managed by batches that require serialization, you must enable the Serialization option. In the Item Master Data, set the User-Defined Field (UDF) Serialization Enabled = Yes. Once enabled, all revisions of the item will follow the rules governing the selection of the Serialization Parameter Template (SPT) for that particular Item/Revision.

Clustering

WEB Application – log in

Please check this section of the documentation for instructions on how to access the web application.

Attributes Templates – Definition

The first step in setting up serialization and clustering is to define Attribute Templates. These templates are used to create various versions of the Serialization Parameter Template (SPT). Each UNP (Unique Numbered Product) component must be assigned a distinct attribute. Additional attributes also need to be defined to enable the clustering process.

Clustering - Attribute Templates

Clustering - Attribute Templates

Below is the list of attributes aligned with the SEC standard and other required attributes necessary for the clustering process. To ensure clustering functions according to the defined rules, attributes must be created as per this list:

Clustering - Attributes Definition

SEC Standard – Donation Identification:

The attributes related to the Donation Identification section of the SEC standard are shown below:

SEC Standard – Donation Identification

SEC Standard – Product Identification:

SEC Standard – Product Identification

SEC Standard – Product Identification

Clustering components:

Clustering Components Clustering Components

SEC Serial Number component is obligatory and is a key to Track & Trace Table:

Clustering - SEC Serial Number Component

Clustering is sensitive to Item changes by default. The rest of the parameters to which clustering is sensitive is determined at the Attribute level. These are the ones for which Clustering ID = Yes: SEC - Purchase Order, SEC - Delivery Note, SEC - Expiry Date.

Clustering - Attribute Templates


For field description please check here.

Serialization Parameters Templates – definition

Attributes associated to SPT are a parameter of the rules that determine the use of a given SPT for clustering a given Item. SPT is created by combining previously defined attribute templates. The user can modify Attribute's parameters. When defining SPT, it is required to assign a given attribute to predefined Field (from Track & Trace Table) of a type compatible with the type of the given Attribute. This action allows you to create a dedicated Track & Trace Table for each Item in accordance to the defined SPT.

Clustering - Serialization Parameters Templates Clustering - Serialization Parameters Templates

Please create a new SPT and add the predefined Attributes Templates to it, assigning them to predefined Field from Track & Trace Table.

Clustering - Serialization Parameters Templates


Rules – definition

In order to be able to carry out the clustering process for a given Item/Revision, it is necessary to define at least one Rule that will cover this Item.

Clustering

If in the Rule you specify only the Item Group, the SPT selected in the Result SPT column will be used for all of the Items in this Group.
If you specify Item Code, then the Result SPT will be applied to all Revisions of the Item.
If for a given Item you provide its revision, then Result SPT will be used only for this Item's Revision.
The above applies to Items that have UDF set: Serialization enabled = Yes in Item Master Data.
In our example, we will define a rule that specifies that previously defined SPT is applied to all of the revisions of a given Item.

Clustering

Start the clustering process

The clustering process is saved in a serialization document. This document is a subject to approval and verification. Serialization documents are visible in the WMS's Packing Hierarchy tile: here

For testing purposes, you can use the scanner simulator available here: WMSScannerSimulator.exe.

For sample test data you can use the attached file: SEC Clustering Test Case 09.01.2020 - 01.xlsx..

Attributes that have a GS1-ID defined must be preceded by it in the simulator, e.g. SEC - Purchase Order must be preceded (99).

Clustering

Enable Serialization in CompuTec WMS (check here. Log in to CompuTec WMS (check here).

Start Serialisation Document: ClusteringClustering ClusteringClustering

Start scanning data for the first serial number:

  1. Purchase Order.
  2. Delivery Note.
  3. Serial Number.
  4. Supplier Batch.

After scanning the data of the first serial number you will be redirected to scan the next one.

(You can also choose the New Goods Receipt option to receipt goods serialized Items without a Purchase Order)

If you want to cancel scanning, select Clustering, and then Clustering . You will be able to return to this document.

Clustering Clustering

Return to editing the serialization document.

Clustering Clustering

Continue scanning serial numbers.vTo finish the serialization document, select Clustering , and then Clustering.

Deleting SN in CompuTec WMS

When receiving a serialised item the SN is generated directly at GRPO scanning. When an employee notices it was received on a wrong PO, or wrong Pack List, it is possible to delete it.

Clustering

  1. Clear Common Fields.
  2. Clear SU List.
  3. Delete Serial Numbers.

Check serialisation document

The unfinished document is in Open status. The finished document is in the status of Ready To Accept. The document has to be accepted for further processing. Document in status Ready To Accept can be edited to make corrections. To do this, go to the WEB application and select:

Clustering Clustering

Add or remove batch – RMBM option on batch line:

Clustering

Change of SN assignment to batch:

Clustering

Finally, accept the serialization document:

Clustering

Once accepted, the status of the document changes to Verification.

Clustering

Verification Document

The accepted serialization document is subject to verification in WMS:

ClusteringClustering Clustering

To confirm verification, select Clustering.

The document status changes to Closed which is visible in the WEB application in the document list.

Clustering

Receipt Document

Go to Receipt Document and enter Vendor, Warehouse and Bin Location (if applicable) and optionally Remarks, and then select Clustering - Receipt Document. The GRPO document is saved and is now visible in SAP B1.

ClusteringClustering Clustering

Goods Receipt PO in SAP B1:

Clustering

Batch Number Transactions Report:

Clustering

Track & Trace Report

Clustering

By selecting Track & Trace Report in the WEB application it is possible to trace the Serial Number history:

Clustering Clustering

Example transactions in WMS using SN

Stock Transfer

Source Warehouse selection

ClusteringClusteringClustering

Item selection

ClusteringClustering

Batch and quantity to transfer selection

ClusteringClusteringClusteringClustering

Serial numbers to transfer selection

ClusteringClusteringClustering

Destination warehouse selection

ClusteringClustering

Items confirmation and transfer document confirmation

ClusteringClustering

Goods Issue

Warehouse Selection

Clustering - Warehouse SelectionClustering - Warehouse Selection

Item Selection

Clustering - Item SelectionClustering - Item Selection

Batch and Quantity Selection

Clustering - Batch and Quantity SelectionClustering - Batch and Quantity Selection Clustering - Batch and Quantity Selection

Serial Numbers Selection

Clustering - Serial Numbers SelectionClustering - Serial Numbers Selection Clustering - Serial Numbers Selection

Issue Document Confirmation

Clustering - Issue Document ConfirmationClustering - Issue Document Confirmation

Delivery

Warehouse Selection

Clustering - Warehouse SelectionClustering Clustering - Warehouse Selection

Customer Selection

Clustering - Customer Selection

Item Selection

Clustering - Item SelectionClustering - Item Selection

Batch and Quantity Selection

Clustering - Batch and Quantity SelectionClustering - Batch and Quantity Selection Clustering - Batch and Quantity SelectionClustering - Batch and Quantity Selection

Serial Number Selection

Clustering - Serial Number SelectionClustering - Serial Number Selection Clustering - Serial Number Selection Clustering - Serial Number Selection

Delivery Document Confirmation

Clustering - Delivery Document ConfirmationClustering - Delivery Document Confirmation