EAAutoSerialNumberCalculator

This document was generated using Claude.ai

Overview

Automatically generates sequential serial numbers for items in supply chain documents based on configurable prefix and number range. Supports both primary and secondary serial numbers with intelligent continuation from last used serial number for each item.

When This Action Runs

Manual execution when items require serial number assignment during document processing. Typically used for production, receiving, or assembly documents where serialized inventory tracking is required.

How It Works

  1. Processes document lines - Identifies items requiring serial numbers with non-zero quantities
  2. Calculates prefix - Uses Tempo template to generate dynamic prefix based on item properties
  3. Finds last serial - Searches for highest existing serial number with matching prefix
  4. Generates new serials - Creates sequential serial numbers starting from next available number
  5. Handles ranges - For quantities > 1, generates range format like "PREFIX00001:PREFIX00005"
  6. Respects limits - Stops generation if calculated number exceeds configured last number

Parameters

Parameter 1: Prefix Template (Required) - Tempo syntax supporting item properties Example: {item.code}-{item.category.code}-

Parameter 2: Suffix Length (Required) - Number of digits for numeric portion (default: 5)

Parameter 3: First Number (Optional) - Starting number for new series (default: 1)

Parameter 4: Last Number (Optional) - Maximum allowed number (default: based on suffix length)

Parameter 5: Use For First Serial (Optional) - true/false to generate primary serials (default: true)

Parameter 6: Use For Second Serial (Optional) - true/false to generate secondary serials (default: false)

Database Tables Affected

  • ItemSerial - Creates new serial number records for tracking
  • Document Line Tables - Updates ItemSpecificDimensions with generated serials
  • Assembly Document Tables - Updates assembly item serial numbers

Module: supplychain

Full Class Name: com.namasoft.modules.supplychain.domain.utils.plugnplay.EAAutoSerialNumberCalculator