EAUpdateAssemblyDocWithAssembledItemSold

This document was generated using Claude.ai

Overview

Automatically updates assembly documents when assembled items are sold by managing co-product quantities and serial numbers. Ensures inventory consistency between assembly production and sales by tracking which assembled items have been sold and updating remaining quantities accordingly.

When This Action Runs

Automatically triggered on post-commit and post-delete events for sales documents. Runs when sales orders, invoices, or delivery notes containing assembled items are committed or deleted, maintaining real-time synchronization between sales and assembly inventory.

How It Works

For Sales Document Commits:

Validates serial requirements - Ensures items with dual serials have all required dimension data
Processes sold items - Creates new co-product lines for sold quantities
Updates serial numbers - Manages serial number allocation and tracking
Adjusts quantities - Reduces available quantities on main assembly co-product lines
Links documents - Creates reference links between sales and assembly documents

For Sales Document Deletions:

Finds linked co-products - Identifies assembly co-products linked to deleted sales
Restores quantities - Returns sold quantities back to main assembly co-product
Removes sold lines - Deletes co-product lines created for the cancelled sale
Updates serials - Restores serial numbers to available pool

Parameters

Parameter 1: Assembly Document Ref (From Header) (Optional) - Field reference to assembly document in sales header

Parameter 2: Assembly Document Ref (From Line) (Optional) - Field reference to assembly document in sales line

Parameter 3: Sales Doc Ref In Assembly Co-products Line (Required) - Field ID for sales document reference in assembly co-product lines

Serial Number Management

Primary Serial: Engine or main component serial number
Secondary Serial: Chassis or secondary component serial number
Serial Zipping: Combines multiple serial numbers into compressed format
Serial Allocation: Moves serials from available pool to sold items

Database Tables Affected

AssemblyDocCoProdLine - Creates new lines for sold items, updates quantities on main lines
Sales Document Lines - Reads sold item information and serial numbers (read-only)
Assembly BOM - References main assembled item configuration (read-only)

Important Warnings

⚠️ Automatic Execution

Runs automatically on sales document commit/delete events
Cannot be disabled or bypassed through normal configuration
May cause unexpected assembly document changes

⚠️ Serial Number Requirements

Items with hasTwoSerials flag require complete serial dimension data
Missing serial numbers, lot IDs, boxes, or second serials cause validation failures
Incomplete serial data prevents sales document processing