Warehouse & Inventory Module
The Warehouse module provides comprehensive inventory management across multiple warehouse locations. Track stock levels, manage warehouse hierarchies, adjust inventory, and generate detailed stock reports.
Warehouse Setup
Creating a Warehouse
- Navigate to Products System › Warehouse
- Click + (Create Warehouse)
- Enter Name, Address, City and Zip Code, and pick a Parent warehouse if this is a sub-store
- Click Create
Warehouse Fields
| Field | Description |
|---|---|
| Name | Warehouse identifier (e.g., "Main Warehouse", "Branch Store") |
| Address | Physical street address |
| City | City location |
| City Zip | Postal/ZIP code |
| Parent Warehouse | Optional parent for hierarchical organization |
Hierarchical Warehouses
Organize warehouses in a parent-child hierarchy:
Main Warehouse (Parent)
├── Branch Store A (Child)
├── Branch Store B (Child)
└── Online Fulfillment Center (Child)
├── Zone 1
└── Zone 2
Setting Up Hierarchy
- Create the parent warehouse first
- When creating child warehouses, select the Parent Warehouse
- Child warehouses inherit organizational structure
Managing Warehouses
| Action | Description |
|---|---|
| View | See warehouse details and all products stored |
| Edit | Update warehouse information |
| Delete | Remove warehouse (requires empty inventory) |
Stock Tracking
Two-Level Stock System
The system tracks inventory at two levels:
1. Global Stock
- Total quantity across all warehouses
- Shown on product listing pages
- Updated automatically from warehouse totals
2. Warehouse-Specific Stock
- Quantity in each specific warehouse
- Enables location-based inventory management
- Sum of all warehouse stocks = Global stock
Stock Distribution Example
Product: Office Chair (SKU: CHR-001) Warehouse Distribution: ├── Main Warehouse: 100 units ├── Branch Store A: 50 units ├── Branch Store B: 30 units └── Online Fulfillment: 70 units ──────────────────────────────────── Global Stock Total: 250 units
Stock Status Indicators
| Status | Condition | Display |
|---|---|---|
| In Stock | More than 20 units | Green badge |
| Medium Stock | 6 to 20 units | Yellow badge |
| Low Stock | 5 units or fewer (including zero) | Red badge |
Stock Adjustments
Adjusting Stock
- Go to Products System › Product Stock
- Find the product and click the Adjust Stock icon
- Choose Add Stock or Subtract Stock
- Enter the Quantity, pick a Warehouse (leave it empty to change the global stock only) and add a Reason (Optional)
- Click Update Stock
Adjustment Types
| Type | Effect | Use Case |
|---|---|---|
| Add | Increases stock quantity | Receiving goods, returns, corrections |
| Subtract | Decreases stock quantity | Damaged goods, shrinkage, corrections |
Adjustment Form Fields
| Field | Description |
|---|---|
| Current Stock | Display of current quantity (read-only) |
| Adjustment Type | Add or Subtract |
| Quantity | Number of units to adjust |
| Warehouse | Optional: specific warehouse to adjust |
| Reason | Optional: note explaining the adjustment |
Warehouse-Specific Adjustments
When adjusting stock, you can:
- Global Adjustment: Leave warehouse empty to adjust global stock
- Warehouse Adjustment: Select specific warehouse to adjust only that location
Audit Trail
All adjustments are logged in the Stock Report with:
- Product name
- Quantity changed
- Type: "manually" for adjustments
- Description/reason
- Timestamp
Warehouse Products
Viewing Warehouse Products
- Go to Products System › Warehouse
- Click View next to the warehouse
- View all products stored in that warehouse
Product Warehouse Details
- Go to Products System › Product Stock
- Click View Warehouses icon next to the product
- View stock distribution across all warehouses
Warehouse Details View Shows:
- Product information (Name, SKU, Category, Unit)
- Total stock quantity
- Stock cards for each warehouse with quantities
- Stock status per warehouse
- Summary statistics:
- Number of warehouses
- Total quantity
- Average per warehouse
- Highest stock location
Stock Reports
Product Stock Report
Navigate to Accounting System › Reports › Product Stock
Report Features:
- Filter by date range
- View all stock movements
- Export to Excel/PDF
Movement Types Tracked:
| Type | Description |
|---|---|
| manually | Manual stock adjustments |
| invoice | Stock reduced by sales invoice |
| bill | Stock added by purchase bill |
| purchase | Stock added by purchase order |
| pos | Stock reduced by POS transaction |
| Goods Receipt | Stock added by a goods receipt (Only when goods are received on site mode) |
| Debit Note | Stock reduced by goods returned to the supplier |
Warehouse Report
Navigate to POS System › Reports › Warehouse Report
Report Shows:
- Total warehouse count
- Total product count across warehouses
- Product distribution chart by warehouse
- Visual breakdown of inventory allocation
Watching for Low Stock
There is no low-stock report or alert, and you can't set a reorder level per product. Use the Low Stock badge in Products System › Product Stock (5 units or fewer; the limit is fixed), and the View Warehouses page for each warehouse. When the badge shows, raise a purchase request to start the procurement cycle again.
System Integration
Automatic Stock Updates
Stock levels are automatically updated by:
| Module | Effect on Stock |
|---|---|
| POS Sales | Decreases stock on sale completion |
| Purchase Orders | Increases stock when saved (default) or when goods are received — see below |
| Invoices | Decreases stock when invoice created |
| Bills | Increases stock when bill recorded (not for lines linked to a purchase order, which already added it) |
| Debit notes | Decreases stock for goods returned to the supplier (only bill lines not created from a purchase order) |
Procurement and Purchase Orders
The warehouse is where purchased material ends up; Procurement decides when it gets there.
From purchase to use
Stock leaves the warehouse only through a customer invoice, a POS sale, Subtract Stock, a debit note on a supplier bill, or by undoing a purchase (deleting a goods receipt, cancelling or deleting a purchase order). Nothing issues material to a project; see Procurement › Use it: stock out for the workaround and how the cost reaches the project.
| Procurement step | What happens with the warehouse |
|---|---|
| Purchase request | Nothing. A request is charged to a project and budget line, not to a warehouse. |
| Select quote › purchase order | You choose the Warehouse with the purchase date and category. A purchase order created directly also has a warehouse. |
| Goods receipt | You choose the Warehouse that receives the goods; it defaults to the purchase order's warehouse. The field appears, and is required, only when your plan includes warehouses. |
| Bill from purchase order | Adds no stock for lines linked to the order. Bill lines without a purchase order still add stock. |
When stock enters the warehouse is set by Stock posting in Settings › System Settings › Company Settings:
| Mode | Stock is added | Shows in the stock report as |
|---|---|---|
| When purchase orders and bills are saved (current) — the default | The full ordered quantity, as soon as the purchase order is saved, before anything arrives | purchase / bill |
| Only when goods are received on site | Only what each goods receipt records, into the warehouse chosen on it | Goods Receipt |
- Deleting a goods receipt removes the stock it added; the warehouse can go negative.
- Cancelling or deleting a purchase order reverses its stock; closing it does not.
POS Integration
- POS can be configured for specific warehouse
- Sales deduct from assigned warehouse stock
- Global stock updates accordingly
Best Practices
Warehouse Organization
- Use clear, descriptive names for warehouses
- Set up hierarchy for multi-location businesses
- Assign addresses for shipping integration
Stock Management
- Perform regular stock counts
- Document all manual adjustments with reasons
- Check the Low Stock badges in Product Stock before raising purchase requests
- Review stock reports regularly
Multi-Warehouse Tips
- Track which warehouse handles which orders
- Monitor stock distribution across locations
- Use warehouse details view for quick checks
- Plan stock per warehouse: there is no transfer between warehouses yet
Quick Reference
| Task | Path |
|---|---|
| Create Warehouse | Products System › Warehouse › + |
| View Warehouse Products | Products System › Warehouse › View |
| Adjust Stock | Products System › Product Stock › Adjust Stock |
| View Warehouse Details | Products System › Product Stock › View Warehouses |
| Stock Movement Report | Accounting System › Reports › Product Stock |
| Warehouse Distribution | POS System › Reports › Warehouse Report |