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 | Reference Source | Reference Display |
|---|---|---|
| Opening Balance | Either Upload data or System calculated for the period | |
| Adjustment | Manual Adjustment | |
| CustomerJobWorkIn | Job Work DC In | Customer DC Number |
| FinalInspection | Not Applicable | N/A |
| FINS | Control Plan Process | Process Number - Process Name |
| Inspection | Inspection | Work Order Number |
| INV | Sales Invoice | Invoice Serial Number |
| NonReturnableDC | Non-Returnable DC | DC Number |
| OS | Control Plan Process | Process Number - Process Name |
| PurchaseInward | GRN / Purchase Inward | GRN Number |
| ServiceDCOut | Service DC Out | DC Number |
| SUP_JBW_IN | Supplier Job Work In | DC Number |
| SUP_JBW_OUT | Supplier Job Work Out | DC Number |
| TK | Control Plan Process | Process Number - Process Name |
🔎 If a movement type does not require a business reference, the Reference column will show
N/A.
🧠 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