ERP ModuleStock Management
Stock Transactions
Viewing and understanding stock movement history
Stock Transactions
All stock movements are recorded as transactions for full traceability.
Transaction Types
Inbound Transactions
| Type | Source | Description |
|---|---|---|
| Receipt | Purchase Order | Goods received from supplier |
| Transfer In | Other Site | Transfer received |
| Return In | Customer | Customer return received |
| Adjustment In | Manual | Positive adjustment |
| Production In | Production | Manufactured goods |
Outbound Transactions
| Type | Destination | Description |
|---|---|---|
| Shipment | Customer | Goods shipped to customer |
| Transfer Out | Other Site | Transfer shipped |
| Return Out | Supplier | Return to supplier |
| Adjustment Out | Manual | Negative adjustment |
| Production Out | Production | Components consumed |
| Waste | Disposal | Scrapped/expired |
Viewing Transactions
Transaction Log
- Go to ERP > Stock > Transactions
- View all movements
- Filter and search
Filter Options
| Filter | Description |
|---|---|
| Date Range | Transaction date period |
| Product | Specific product |
| Stock Site | Specific location |
| Type | Transaction type |
| Reference | Order/document number |
Transaction Details
Click any transaction to see:
| Field | Description |
|---|---|
| Date/Time | When it occurred |
| Type | Transaction type |
| Product | Item moved |
| Quantity | Amount moved |
| Before | Stock before |
| After | Stock after |
| Location | Stock site/bin |
| Reference | Related document |
| User | Who performed |
Transaction Sources
From Orders
Order-related movements:
Sales Order → Reservation → Pick → Ship
Purchase Order → Receive → Put AwayFrom Transfers
Transfer movements:
Transfer Order → Ship → In Transit → ReceiveFrom Adjustments
Manual adjustments:
- Stock counts
- Write-offs
- Corrections
From Production
Manufacturing movements:
- Components consumed
- Finished goods received
Audit Trail
Full Traceability
Every transaction records:
- Who made the change
- When it happened
- Why (reason/reference)
- Before and after quantities
Compliance
Transaction logs support:
- Financial audits
- Inventory audits
- Regulatory compliance
- Dispute resolution
Transaction Reports
Movement Summary
Overview of movements:
| Report | Contents |
|---|---|
| By Period | Movements in date range |
| By Product | All movements for item |
| By Type | Specific transaction types |
| By User | Movements by person |
Stock Movement Report
Detailed movement analysis:
- Select date range
- Choose products/categories
- Select stock sites
- Generate report
Sample Output:
| Date | Product | Type | Qty | Balance |
|---|---|---|---|---|
| Jan 1 | Widget A | Receipt | +100 | 100 |
| Jan 3 | Widget A | Shipment | -25 | 75 |
| Jan 5 | Widget A | Shipment | -30 | 45 |
Stock Flow Analysis
Visual movement analysis:
graph LR
A[Opening: 100] --> B[Receipts: +500]
B --> C[Shipments: -400]
C --> D[Adjustments: -10]
D --> E[Closing: 190]Transaction Reversals
Correcting Errors
If a transaction was made in error:
- Create offsetting transaction
- Note reason for correction
- Both transactions remain in log
Void vs Reverse
| Action | Result |
|---|---|
| Void | Removes from consideration (if supported) |
| Reverse | Creates opposite transaction |
Never directly edit historical transactions. Always create corrections.
Best Practices
Documentation
- Include reference numbers
- Add notes for unusual movements
- Use consistent reason codes
Monitoring
- Review transactions daily
- Watch for unusual patterns
- Investigate discrepancies promptly
Retention
- Keep transaction history per policy
- Archive for compliance requirements
- Enable reporting on historical data