Lot Transactions
Complete guide to handling lot numbers across all inventory transactions.
Receipt Transactions
Item Receipt (Purchase Order)
LOT ASSIGNMENT ON RECEIPT
═══════════════════════════════════════════════════════════════════════════════
Purchase Order: PO-1234
Item: Chemical-A (Lot Tracked)
Ordered Quantity: 500 units
Item Receipt Creation:
┌─────────────────────────────────────────────────────────────────────────────┐
│ Items Tab: │
│ ┌───────────────────────────────────────────────────────────────────────┐ │
│ │ Item │ Quantity │ Location │ [Inventory Detail] │ │
│ ├────────────┼──────────┼────────────────┼─────────────────────────────┤ │
│ │ Chemical-A │ 500 │ Main Warehouse │ Click to assign lots │ │
│ └────────────┴──────────┴────────────────┴─────────────────────────────┘ │
│ │
│ Inventory Detail Popup: │
│ ┌───────────────────────────────────────────────────────────────────────┐ │
│ │ Lot Number │ Quantity │ Expiration │ Bin │ Status │ │
│ ├────────────────┼──────────┼─────────────┼──────────┼──────────────────┤ │
│ │ CHEM-2024-0501 │ 250 │ 12/31/2025 │ A-01 │ Good │ │
│ │ CHEM-2024-0502 │ 250 │ 12/31/2025 │ A-02 │ Good │ │
│ └────────────────┴──────────┴─────────────┴──────────┴──────────────────┘ │
│ │
│ Total assigned must equal quantity received │
│ │
└─────────────────────────────────────────────────────────────────────────────┘
Work Order Completion
LOT ASSIGNMENT ON PRODUCTION
═══════════════════════════════════════════════════════════════════════════════
Work Order: WO-1234
Assembly Item: Finished-Product-A (Lot Tracked)
Build Quantity: 100 units
Work Order Completion:
┌─────────────────────────────────────────────────────────────────────────────┐
│ │
│ OUTPUT (New Lot Created): │
│ ┌───────────────────────────────────────────────────────────────────────┐ │
│ │ Item: Finished-Product-A │ │
│ │ Lot: FP-2024-1225-001 (Auto-generated) │ │
│ │ Quantity: 100 │ │
│ │ Mfg Date: 12/25/2024 │ │
│ │ Exp Date: 12/25/2025 │ │
│ └───────────────────────────────────────────────────────────────────────┘ │
│ │
│ COMPONENTS CONSUMED (Lot Selection): │
│ ┌───────────────────────────────────────────────────────────────────────┐ │
│ │ Component │ Required │ Lot Used │ Qty Consumed │ │
│ ├─────────────────┼──────────┼───────────────────┼──────────────────────┤ │
│ │ Raw-Material-A │ 200 │ RM-2024-0445 │ 200 │ │
│ │ Raw-Material-B │ 50 │ RM-2024-0512 │ 50 │ │
│ └─────────────────┴──────────┴───────────────────┴──────────────────────┘ │
│ │
│ Traceability: Output lot FP-2024-1225-001 contains: │
│ • RM-2024-0445 (Raw Material A) │
│ • RM-2024-0512 (Raw Material B) │
│ │
└─────────────────────────────────────────────────────────────────────────────┘
Issue Transactions
Item Fulfillment (Sales Order)
LOT SELECTION ON FULFILLMENT
═══════════════════════════════════════════════════════════════════════════════
Sales Order: SO-5678
Item: Chemical-A
Ordered Quantity: 75 units
Available Lots (FEFO Order):
┌─────────────────────────────────────────────────────────────────────────────┐
│ Lot Number │ Available │ Expiration │ Location │ Pick Priority │
├────────────────┼───────────┼─────────────┼────────────────┼────────────────┤
│ CHEM-2024-0489 │ 30 │ 11/30/2025 │ Main Warehouse │ 1 (Earliest) │
│ CHEM-2024-0501 │ 250 │ 12/31/2025 │ Main Warehouse │ 2 │
│ CHEM-2024-0502 │ 250 │ 12/31/2025 │ Main Warehouse │ 3 │
└────────────────┴───────────┴─────────────┴────────────────┴────────────────┘
Fulfillment Lot Assignment (FEFO):
┌─────────────────────────────────────────────────────────────────────────────┐
│ Lot Number │ Quantity │ Notes │
├────────────────┼──────────┼────────────────────────────────────────────────┤
│ CHEM-2024-0489 │ 30 │ Use all of earliest expiring lot │
│ CHEM-2024-0501 │ 45 │ Partial from next lot to complete order │
├────────────────┼──────────┼────────────────────────────────────────────────┤
│ TOTAL │ 75 │ │
└────────────────┴──────────┴────────────────────────────────────────────────┘
Post-Fulfillment Lot Balances:
CHEM-2024-0489: 0 (depleted)
CHEM-2024-0501: 205 (250 - 45)
CHEM-2024-0502: 250 (unchanged)
Adjustment Transactions
Inventory Adjustment (Lot Specific)
LOT-SPECIFIC ADJUSTMENT
═══════════════════════════════════════════════════════════════════════════════
Scenario: Quality issue found in specific lot
Adjustment Record:
┌─────────────────────────────────────────────────────────────────────────────┐
│ Account: Inventory Adjustment │
│ Adjustment Account: Quality Write-off │
│ Location: Main Warehouse │
│ Memo: QC rejection - failed testing │
│ │
│ Items: │
│ ┌───────────────────────────────────────────────────────────────────────┐ │
│ │ Item │ Adjust Qty │ Lot │ Unit Cost │ Total │ │
│ ├────────────┼────────────┼──────────────────┼───────────┼──────────────┤ │
│ │ Chemical-A │ -30 │ CHEM-2024-0489 │ $25.00 │ -$750.00 │ │
│ └────────────┴────────────┴──────────────────┴───────────┴──────────────┘ │
│ │
│ GL Impact: │
│ DR: Quality Write-off Expense $750.00 │
│ CR: Inventory Asset $750.00 │
│ │
└─────────────────────────────────────────────────────────────────────────────┘
Transfer Transactions
Transfer Order (Between Locations)
LOT TRANSFER BETWEEN LOCATIONS
═══════════════════════════════════════════════════════════════════════════════
Transfer Order: TO-1234
From: Main Warehouse
To: Distribution Center
Item Fulfillment (Shipping):
┌─────────────────────────────────────────────────────────────────────────────┐
│ Item │ Quantity │ Lot │ From Location │ Status │
├────────────┼──────────┼─────────────────┼─────────────────┼────────────────┤
│ Chemical-A │ 100 │ CHEM-2024-0501 │ Main Warehouse │ In Transit │
└────────────┴──────────┴─────────────────┴─────────────────┴────────────────┘
Item Receipt (Receiving):
┌─────────────────────────────────────────────────────────────────────────────┐
│ Item │ Quantity │ Lot │ To Location │ Status │
├────────────┼──────────┼─────────────────┼────────────────────┼─────────────┤
│ Chemical-A │ 100 │ CHEM-2024-0501 │ Distribution Center│ Received │
└────────────┴──────────┴─────────────────┴────────────────────┴─────────────┘
⚠️ IMPORTANT: Same lot number is maintained across locations
Lot CHEM-2024-0501 now exists at Distribution Center
Bin Transfer (Within Location)
LOT BIN TRANSFER
═══════════════════════════════════════════════════════════════════════════════
Moving lot from receiving bin to storage bin:
Bin Transfer Record:
┌─────────────────────────────────────────────────────────────────────────────┐
│ Location: Main Warehouse │
│ Item: Chemical-A │
│ Lot: CHEM-2024-0501 │
│ Quantity: 100 │
│ From Bin: RCV-01 (Receiving Dock) │
│ To Bin: CHEM-A-01 (Chemical Storage) │
│ │
│ No GL Impact (same location) │
│ Lot quantity unchanged, only bin location changes │
└─────────────────────────────────────────────────────────────────────────────┘
Lot Costing
When Lot Costing is enabled:
LOT COSTING EXAMPLE
═══════════════════════════════════════════════════════════════════════════════
Same item, different lot costs:
┌─────────────────────────────────────────────────────────────────────────────┐
│ Item: Chemical-A │
│ │
│ Lot │ Quantity │ Unit Cost │ Total Value │ Receipt Date │
│ ──────────────────────────────────────────────────────────────────────── │
│ CHEM-2024-0489 │ 100 │ $24.50 │ $2,450 │ 10/15/2024 │
│ CHEM-2024-0501 │ 250 │ $25.00 │ $6,250 │ 11/15/2024 │
│ CHEM-2024-0502 │ 250 │ $26.00 │ $6,500 │ 12/01/2024 │
│ ──────────────────────────────────────────────────────────────────────── │
│ Total │ 600 │ $25.33 avg│ $15,200 │ │
│ │
└─────────────────────────────────────────────────────────────────────────────┘
When fulfilling orders:
- COGS is based on specific lot cost
- If fulfilling from CHEM-2024-0489: COGS = $24.50/unit
- If fulfilling from CHEM-2024-0502: COGS = $26.00/unit
SuiteQL for Lot Transactions
Lot Transaction History
-- Complete lot transaction history
SELECT
t.trandate,
t.type AS transaction_type,
t.tranid AS document_number,
i.itemid AS item,
inv.inventorynumber AS lot_number,
ia.quantity AS lot_quantity,
CASE
WHEN t.type IN ('ItemRcpt', 'InvAdjst') AND ia.quantity > 0 THEN 'Receipt'
WHEN t.type = 'ItemShip' THEN 'Issue'
WHEN t.type = 'InvAdjst' AND ia.quantity < 0 THEN 'Adjustment Out'
WHEN t.type = 'InvTrnfr' THEN 'Transfer'
ELSE t.type
END AS movement_type
FROM
inventoryassignment ia
JOIN
transactionline tl ON ia.transactionline = tl.id
JOIN
transaction t ON tl.transaction = t.id
JOIN
item i ON tl.item = i.id
JOIN
inventorynumber inv ON ia.inventorynumber = inv.id
WHERE
inv.inventorynumber = 'CHEM-2024-0501'
ORDER BY
t.trandate, t.id
Current Lot Inventory
-- Current lot quantities by location
SELECT
l.name AS location,
i.itemid AS item,
inv.inventorynumber AS lot_number,
inv.expirationdate,
inl.quantityonhand AS quantity,
inl.quantityonhand * COALESCE(il.averagecost, i.cost) AS value
FROM
inventorynumberlocations inl
JOIN
inventorynumber inv ON inl.inventorynumber = inv.id
JOIN
item i ON inv.item = i.id
JOIN
location l ON inl.location = l.id
LEFT JOIN
inventoryitemlocations il ON i.id = il.item AND l.id = il.location
WHERE
inl.quantityonhand > 0
ORDER BY
l.name, i.itemid, inv.expirationdate
Next Steps
| Goal | Go To |
|---|---|
| Serial number tracking | Serial Tracking → |
| Bin management | Bin Management → |
| Return to Lot overview | Lot Tracking → |