Skip to content
Mostafa Abbas

Projects / ERP / Business Systems

ERP Inventory Module

An inventory and purchasing module covering stock movements, multi-warehouse transfers, reorder thresholds and supplier purchase orders within an existing ERP system.

Year
2023
Role
Full-Stack Developer
Category
ERP / Business Systems
Stack
C#.NETReactTypeScriptSQL Server

The problem

Stock levels drifted from reality because concurrent movements were applied optimistically, and warehouse staff had no clear view of pending transfers.

The solution

Transactional movement handling with database-level constraints, plus an operations view that surfaces pending and in-transit stock alongside on-hand quantities.

Challenges

Retrofitting transactional guarantees into a live system required a phased rollout with dual-writes and reconciliation reports before the old path was removed.

Outcome

Stock discrepancies became rare enough to investigate individually instead of being absorbed as routine shrinkage.