Inventory Management
Track your materials, supplies, and inventory usage with DrillerDB's inventory system.
Quick Start: Track Inventory
- Choose tracking mode (Usage-Only or Full Stock)
- Add items to your material catalog
- Set pricing and stock thresholds
- Record usage on projects
- Review reports for cost analysis
Features Overview
| Feature | Purpose |
|---|---|
| Inventory Items | Manage your material catalog |
| Stock Tracking | Monitor quantity levels |
| Transactions | Log usage and adjustments |
| Reports | Analyze inventory costs |
| Purchase Orders | Create and manage POs |
Tracking Modes
DrillerDB supports two inventory tracking modes to match your operational needs.
| Mode | What It Does | Best For |
|---|---|---|
| Usage-Only | Track consumption without stock levels | Simple cost tracking, no warehouse management |
| Full Stock Tracking | Complete inventory with quantities | Companies managing physical inventory |
Start with usage-only mode if you're unsure. You can upgrade to full stock tracking later when ready for quantity management.
Topics in This Section
- Managing Inventory Items - Organize and maintain your material catalog
- Adding Inventory Items - Create new items in your material catalog
- Stock Level Tracking - Understanding tracking modes and managing inventory quantities
- Inventory Transactions - Recording usage, adjustments, and inventory movements
- Inventory Reports - Usage analysis, cost tracking, and inventory trends
- Purchase Orders - Creating and managing purchase orders for inventory replenishment
Getting Started
Start by understanding the two tracking modes DrillerDB offers. Full stock tracking maintains running balances of materials on hand, while usage-only mode tracks consumption for cost analysis without managing physical inventory levels. Choose the mode that best fits your operational needs.
Once you've selected your tracking mode, begin building your material catalog by adding inventory items. Each item requires a unique ID, descriptive name, category, unit of measure, and unit price. This foundational data supports accurate cost tracking across all your projects.
As your team uses materials on projects or receives shipments, transactions create an audit trail documenting every quantity change. Regular review of transaction history and reports helps you optimize reorder points, identify usage trends, and make data-driven purchasing decisions.
Step-by-Step: Weekly Inventory Reconciliation
- Review usage transactions from active jobs
- Compare expected vs on-hand quantities
- Record adjustments with reasons for any variance
- Create purchase orders for low-stock items
- Share reorder needs with operations and billing teams
Related Topics
- Projects - Apply inventory usage to project costs
- Pump & Service Work Orders - Track service parts consumption
- Reports - Export inventory cost and usage trends