Stock Movement History
Screen: Movement History
Purpose: Provides a complete, immutable, chronological audit trail of all stock movements for a product across machined, inspection, logistics, and commercial processes.
📌 Overview
The Movement History screen presents every stock movement event associated with a product, ordered strictly by transaction time and system sequence.
Each row represents one atomic stock movement, capturing:
- Date and time of the transaction
- Inventory stage and sub-stage
- Quantity impact (inward or outward)
- Business movement type
- Business reference
- Serial or batch details (if applicable)
This screen acts as the single source of truth for stock traceability across the DMeX ecosystem.
🧭 Key Characteristics
- Non-editable, audit-safe ledger
- Supports serialized and non-serialized items
- Consolidates data from multiple business modules
- Designed for high-volume operational usage
📊 Screen Layout
Header Section
- Transaction Count – Total number of stock movements displayed
- Example:
332 Transactions
- Example:
📊 Quantity Summary
The quantity summary provides a quick snapshot of stock movement totals for the selected scope (product, filter, or date range).
| Metric | Description |
|---|---|
| In | Total quantity added to inventory through inward movements |
| Out | Total quantity removed from inventory through outward movements |
| Net | Net inventory impact calculated as In − Out |
🔘 Export & Reset Actions
📤 Export
Allows users to download the currently displayed Movement History data in a supported format Excel for offline analysis, reporting, or sharing.
🔄 Reset
Clears all applied filters and search criteria, restoring the Movement History view to its default state with the complete dataset.
📑 Table Columns Description
| Column Name | Description |
|---|---|
| Date | Exact timestamp when the stock movement was recorded |
| Stage | Inventory stage where movement occurred (e.g., RM, WIP, FG, Store) |
| Sub Stage | Operation or process step (e.g., Batch, OP30, OP40, OP50, Final Inspection, Packing) |
| Quantity | Net quantity change for the movement |
| Type | Logical business event responsible for the movement (Check below table) |
| Reference | Human-readable business reference resolved from the source module |
| Serial Numbers | Serial or batch numbers linked to the movement (shown only for serialized items) |
🎨 Quantity Representation
| Indicator | Meaning |
|---|---|
| 🟢 Green (+) | Stock Inward / Addition |
| 🔴 Red (−) | Stock Outward / Consumption |
Quantity always reflects the net effect of the transaction on inventory.
🔁 Stock Movement Type → Reference Mapping
Each movement Type determines:
- Which business table the
referenceIdpoints to - What value is rendered in the Reference column
📌 Reference Resolution Rules
| Type (shown as) | Reference Source | Reference Display |
|---|---|---|
| Opening Balance | Either Upload data or System calculated for the period | Opening Balance |
| Adjustment | Manual stock adjustment | Process Number - Process Name, or Stock adjustment when no process is selected |
| PurchaseInward (GRN) | GRN / Purchase Inward | GRN Number |
| INTERNAL_MAT_INWARD (Internal Material Inward) | Internal Material Inward | Material Inward Number |
| MiscellaneousInward (Miscellaneous Inward) | Miscellaneous Inward | Inward Number |
| CustomerJobWorkIn (Customer Job Work In) | Customer Job Work In | Customer DC Number |
| JOBWORK_DC_OUT (Customer Job Work Out) | Customer Job Work Out (Outward DC) | Outward DC Number |
| Inspection | Inward Inspection | Work Order Number (inspection number). For a Service DC In inspected by serial numbers: Process Number - Process Name |
| ServiceDCIn (Returnable DC In) | Returnable / Service DC In | Inward Number |
| ServiceDCOut (Returnable DC Out) | Returnable / Service DC Out | DC Number. On the entry a DC In makes when material returns: DC Out Number / Inward Number |
| NonReturnableDC (Non Returnable DC) | Non-Returnable DC | DC Number |
| SUP_JBW_OUT (Supplier Job Work Out) | Supplier Job Work Out | DC Number. For a stock adjustment to outsource (Adjustment-OS): Process Number - Process Name |
| SUP_JBW_IN (Supplier Job Work In) | Supplier Job Work In | Supplier DC Number |
| OS (Out Source) | Outsource inspection | Supplier Job Work In DC Number · Process Number - Process Name |
| SP (Special Process) | Special process | Process Number - Process Name |
| WorkOrder (Work Order) | Batch / Work Order | Batch Number (also for finished goods used in a batch) |
| ProductionInward (Production Inward) | Production batch inward | Batch Number |
| ProdInwardIns (Production Inward Inspection) | Production batch inspection | Inspection Number |
| TK (Machine Process), BLK (Bulk Entry), HBLK (Hourly Production Entry), ASM (Assembly), NCR | Control Plan Process | Process Number - Process Name |
| FINS (Final Inspection) | Final Inspection | Final Inspection Number · Process Number - Process Name |
| FINH (Final Inspection, 100% check sheet) | Control Plan Process | Process Number - Process Name |
| CONSUMPTION (Consumption) | Consumption | Consumption · GRN Number (consumed from inspected purchase inward), Consumption · Opening Balance, or Consumption #id on older entries |
| INV (Invoice) | Sales Invoice | Invoice Serial Number (with (Draft) / (Cancel)) |
| FinalInspection | Not Applicable | N/A |
🔎
UNKNOWNis shown only for a movement type that has no reference rule, for example a manual entry with a free type. Report it to the DMeX support team.
🧠 How to Read a Movement Row
Example
- Stage: WIP
- Sub Stage: OP30
- Quantity:
+7 - Type: Machine Process
- Reference:
30 - MILLING 1
Interpretation
👉 7 units were added to WIP inventory at Operation OP30 as a result of executing
Process 30 – Milling 1.
🧾 Serial Number Handling
- Displayed only for serialized or batch-controlled items
- Multiple serials are grouped per movement row
- Serial visibility depends on item master configuration
🏭 Business Coverage
The Movement History consolidates stock movements originating from:
- Manufacturing operations
- Quality inspection and NCR processes
- Customer job work (Inward / Outward)
- Supplier job work (Inward / Outward)
- Purchase and GRN transactions
- Service delivery challans
- Sales invoices and dispatches
- Manual and system-driven adjustments
This ensures end-to-end traceability across the product lifecycle.
✅ Design Principles
- Chronological accuracy (timestamp + internal sequence)
- Cross-module consistency (MES, Inventory, Quality, Sales)
- Clear, human-readable references
- Immutable, audit-ready ledger
- Scalable for high-volume transactional data