Module 09: Inventory Management¶
The Inventory module (/inventory/*) delivers real-time multi-warehouse stock control, valuation tracking, stock movement execution, physical stock count audits, and bulk price management.
🎯 Core Capabilities¶
1. Inventory Dashboard (/inventory)¶
- Total Stock Valuation (AED), Low Stock Alert Cards, Stock Movement Velocity Graphs, and Active Warehouses Summary.
2. Goods Receipt / Inward Stock (/inventory/receive)¶
- Receive incoming stock deliveries from supplier Purchase Orders into designated warehouses.
- Generate Goods Receipt Notes (GRN) with line-level received vs. damaged quantity tracking.
3. Deliver Goods / Outward Stock (/inventory/delivery)¶
- Fulfill outward delivery orders linked to confirmed Sales Orders. Auto-decrements warehouse stock on hand.
4. Stock Transfers (/inventory/transfers)¶
- Transfer stock items between internal warehouses (e.g.
Central Warehouse→Retail Outlet). - Tracks transfer status (
Draft,In Transit,Completed).
5. Stock Adjustments (/inventory/adjustments)¶
- Perform manual stock quantity overrides (damage, write-off, internal consumption).
- Requires mandatory audit reason selection (
Damage,Loss,Internal Use,Initial Balance). - Automatically posts GL inventory adjustment entries.
6. Physical Stock Take Audits (/inventory/stock-take)¶
- Conduct wall-to-wall physical inventory counts by warehouse.
- Calculates variance (
System Quantityvs.Physical Counted). - One-click Reconcile Variances button to automatically align inventory ledgers and post variance JVs.
7. Bulk Price Editor (/inventory/price-editor)¶
- Batch editing grid for updating selling prices, list prices, and minimum margins across hundreds of products simultaneously.
8. Catalogs: Products, Categories, UOM & Warehouses¶
- Products: Manage SKU codes, barcodes, descriptions, cost price (moving average), sales price, minimum stock reorder level.
- Categories: Organize products into hierarchical categories with custom GL account overrides.
- Units of Measure (UOM): Configure base and secondary UOM conversion factors (e.g.
1 Box = 24 Pieces). - Warehouses: Manage storage facilities, addresses, and warehouse manager assignments.
💡 Step-by-Step Instructions¶
Conducting a Stock Take Audit¶
- Navigate to Inventory → Stock Take (
/inventory/stock-take). - Click Start Stock Take, select warehouse (
Main Warehouse), and choose category. - Print or open the counting sheet. Enter the physical counted numbers for each SKU line.
- Review highlighted red variances (e.g., SKU-1002: System = 50, Physical = 47, Variance = -3).
- Click Reconcile Variances. The system updates stock levels to 47 and posts an Inventory Adjustment Loss JV.